Videos Learn with Our Expert Trainers
In this video, you will learn how to save, share, and organize content using OneNote.
The video covers the process of saving web pages to OneNote using the OneNote Web Clipper extension in Microsoft Edge or Google Chrome.
You can choose to save a specific region, article, or the entire page.
Once saved, you can view and add notes to your clips in OneNote.
This tutorial will help you efficiently save and organize your online content using OneNote.
The video covers the process of saving web pages to OneNote using the OneNote Web Clipper extension in Microsoft Edge or Google Chrome.
You can choose to save a specific region, article, or the entire page.
Once saved, you can view and add notes to your clips in OneNote.
This tutorial will help you efficiently save and organize your online content using OneNote.
- 2:59
- 3941 views
In this video, you will learn how to assign a button to a macro in Excel.
The video demonstrates how to create a custom group on the ribbon and add the macro to it.
It also shows how to add the same macro to the Quick Access Toolbar.
This knowledge will help you efficiently implement macros in Excel and enhance your productivity.
The video demonstrates how to create a custom group on the ribbon and add the macro to it.
It also shows how to add the same macro to the Quick Access Toolbar.
This knowledge will help you efficiently implement macros in Excel and enhance your productivity.
- 2:49
- 4061 views
In this video, you will learn how to create a table in Microsoft Excel.
The video demonstrates using the "Format as Table" function to quickly convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also shows how to name your table and change its design using the Table Tools contextual tab.
Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.
This feature is especially useful when dealing with tables that have many columns.
Overall, this tutorial will help you create and format tables efficiently in Excel.
The video demonstrates using the "Format as Table" function to quickly convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also shows how to name your table and change its design using the Table Tools contextual tab.
Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.
This feature is especially useful when dealing with tables that have many columns.
Overall, this tutorial will help you create and format tables efficiently in Excel.
- 2:11
- 4079 views
In this video, you will learn about functions and formulas in Microsoft Excel.
The video covers how to use slicers to filter data, create drop-down lists, sort and filter data, use conditional formatting, create charts, and analyze data using PivotTables.
This will help you become proficient in using functions and formulas to manipulate and analyze data in Excel.
The video covers how to use slicers to filter data, create drop-down lists, sort and filter data, use conditional formatting, create charts, and analyze data using PivotTables.
This will help you become proficient in using functions and formulas to manipulate and analyze data in Excel.
- 3:24
- 4676 views
In this video, you will learn how to use slicers to filter data in Power BI.
Slicers are simple forms of filters that play a key role in designing customized charts and reports.
By adding a slicer to your visualization pane and selecting a field, such as country or date, you can filter your data and see how it impacts your other visuals.
You can select one country at a time or use the control key to select multiple countries simultaneously.
The slicer can be further customized by activating single select, disabling multi-select, or showing the select all option.
Additionally, you can create a time slicer to filter data based on a range of dates or relative dates.
The video also covers how to reset filters, switch to relative dates, and sync slicers across different pages in your report.
By mastering slicers, you will be able to effectively filter and analyze your data in Power BI.
Slicers are simple forms of filters that play a key role in designing customized charts and reports.
By adding a slicer to your visualization pane and selecting a field, such as country or date, you can filter your data and see how it impacts your other visuals.
You can select one country at a time or use the control key to select multiple countries simultaneously.
The slicer can be further customized by activating single select, disabling multi-select, or showing the select all option.
Additionally, you can create a time slicer to filter data based on a range of dates or relative dates.
The video also covers how to reset filters, switch to relative dates, and sync slicers across different pages in your report.
By mastering slicers, you will be able to effectively filter and analyze your data in Power BI.
- 1:25
- 4073 views
In this video, you will learn how to create a PivotTable and analyze your data using Microsoft 365. Pivot tables are a powerful tool for summarizing, analyzing, exploring, and presenting data in a report.
The video demonstrates how to create a PivotTable by clicking on any cell in your data, selecting "Insert," and choosing from the recommended pivot table layouts.
You can preview each recommendation to see how your data will look.
The video also shows how to format the numbers in the PivotTable as currency.
This tutorial will help you gain a better understanding of your data and make informed decisions.
The video demonstrates how to create a PivotTable by clicking on any cell in your data, selecting "Insert," and choosing from the recommended pivot table layouts.
You can preview each recommendation to see how your data will look.
The video also shows how to format the numbers in the PivotTable as currency.
This tutorial will help you gain a better understanding of your data and make informed decisions.
- 1:35
- 4241 views
In this video, you will learn how to create a PivotTable report manually using Microsoft 365. Pivot table reports are a powerful way to summarize, analyze, explore, and present your data in a report.
This video will guide you through the process of creating a PivotTable and analyzing your data.
By following the steps, you will be able to make sense of your data, especially when you have a large amount of it.
This will help you gain insights and make informed decisions based on your data.
This video will guide you through the process of creating a PivotTable and analyzing your data.
By following the steps, you will be able to make sense of your data, especially when you have a large amount of it.
This will help you gain insights and make informed decisions based on your data.
- 4:59
- 4692 views
In this video, you will learn how to sort, filter, summarize, and calculate your PivotTable data.
The video covers various ways to analyze PivotTable data, including sorting it to quickly identify trends, filtering it to focus on specific criteria, and using slicers to efficiently filter the data.
Additionally, the video demonstrates how to summarize the data using different functions and display it in various formats, such as percentages.
This knowledge will help you effectively analyze and understand your PivotTable data, enabling you to make informed decisions.
The video covers various ways to analyze PivotTable data, including sorting it to quickly identify trends, filtering it to focus on specific criteria, and using slicers to efficiently filter the data.
Additionally, the video demonstrates how to summarize the data using different functions and display it in various formats, such as percentages.
This knowledge will help you effectively analyze and understand your PivotTable data, enabling you to make informed decisions.
- 3:49
- 4431 views
In this video, you will learn about using slicers, timelines, and PivotCharts to analyze your PivotTable data.
The video covers how to set up your data sources, create a PivotTable, filter data, edit summary formulas, change header names, and display data in the desired order.
It also explains the benefits of using slicers in Excel.
This knowledge will help you showcase your data effectively and make accurate summaries.
The video covers how to set up your data sources, create a PivotTable, filter data, edit summary formulas, change header names, and display data in the desired order.
It also explains the benefits of using slicers in Excel.
This knowledge will help you showcase your data effectively and make accurate summaries.
- 3:38
- 2973 views
In this video, you will learn how to freeze or lock panes in Microsoft 365. The video covers the process of freezing the top row or the first column to keep them visible while scrolling.
This feature is useful when you want to keep the header row or a specific column always in view.
Freezing both the top row and the first column simultaneously will also be explained in the next video.
Mastering this technique will enhance your productivity and navigation in Microsoft 365.
This feature is useful when you want to keep the header row or a specific column always in view.
Freezing both the top row and the first column simultaneously will also be explained in the next video.
Mastering this technique will enhance your productivity and navigation in Microsoft 365.
- 1:06
- 3912 views
In this video, you will learn about freezing panes in detail.
The video covers how to freeze specific rows and columns in Excel to keep them visible while scrolling.
It demonstrates selecting the cell below the rows and columns you want to freeze and clicking the Freeze Panes button.
This will help you maintain context while navigating through your spreadsheet.
Additionally, the video shows how to repeat specific rows on every printed page.
By following these steps, you can effectively freeze panes in Excel and improve your workflow.
The video covers how to freeze specific rows and columns in Excel to keep them visible while scrolling.
It demonstrates selecting the cell below the rows and columns you want to freeze and clicking the Freeze Panes button.
This will help you maintain context while navigating through your spreadsheet.
Additionally, the video shows how to repeat specific rows on every printed page.
By following these steps, you can effectively freeze panes in Excel and improve your workflow.
- 3:30
- 4231 views