Videos Learn with Our Expert Trainers
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
- 4527 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
- 3829 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
- 3698 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
- 4115 views
In this video, you will learn about Microsoft365 and how it can help you and your team be creative and work together securely.
The video covers the Office apps like Word, Excel, and PowerPoint, which allow you to save your files in the cloud with OneDrive.
This means you can access your files from anywhere.
You can store any type of file, including images, spreadsheets, and presentations.
The video also demonstrates how you can share and work in real-time with your coworkers, whether you're in the office or on the go.
Microsoft365 also offers mobile apps for your devices, allowing you to stay organized and connected.
Additionally, you can be productive from any browser with Office for the web.
This tutorial will help you understand how to work and collaborate from anywhere and on any device using Microsoft365. By following these steps, you can enhance your productivity and achieve better results.
The video covers the Office apps like Word, Excel, and PowerPoint, which allow you to save your files in the cloud with OneDrive.
This means you can access your files from anywhere.
You can store any type of file, including images, spreadsheets, and presentations.
The video also demonstrates how you can share and work in real-time with your coworkers, whether you're in the office or on the go.
Microsoft365 also offers mobile apps for your devices, allowing you to stay organized and connected.
Additionally, you can be productive from any browser with Office for the web.
This tutorial will help you understand how to work and collaborate from anywhere and on any device using Microsoft365. By following these steps, you can enhance your productivity and achieve better results.
- 2:54
- 4200 views
In this video training on Microsoft 365, you will learn about the intelligent search feature in the Microsoft 365 environment.
The video covers the subtleties of searching in Microsoft 365, including how to find documents, emails, and other information efficiently.
By using the search tools in Microsoft 365, you can easily locate files, folders, teams, conversations, and more.
This will help you save time and improve your productivity by quickly accessing the information you need.
The video covers the subtleties of searching in Microsoft 365, including how to find documents, emails, and other information efficiently.
By using the search tools in Microsoft 365, you can easily locate files, folders, teams, conversations, and more.
This will help you save time and improve your productivity by quickly accessing the information you need.
- 2:06
- 4148 views
In this video, you will learn about the SUM function in Microsoft 365. The video demonstrates how to use the SUM function to add up a range of cells in Excel.
It explains the syntax of the SUM function and shows how to add adjacent cells, non-adjacent cells, and cells from different worksheets.
This knowledge will help you efficiently calculate sums in Excel and improve your data analysis skills.
It explains the syntax of the SUM function and shows how to add adjacent cells, non-adjacent cells, and cells from different worksheets.
This knowledge will help you efficiently calculate sums in Excel and improve your data analysis skills.
- 4:37
- 4306 views
In this video, you will learn about the SUMIF function in Excel.
The video covers how to use the SUMIF function to add cells that meet specific criteria.
It demonstrates the syntax of the function and provides examples of how to use it to add cells based on conditions.
This will help you efficiently add numbers in Excel and improve your data analysis skills.
The video covers how to use the SUMIF function to add cells that meet specific criteria.
It demonstrates the syntax of the function and provides examples of how to use it to add cells based on conditions.
This will help you efficiently add numbers in Excel and improve your data analysis skills.
- 5:27
- 4377 views
In this video, you will learn about basic math in Excel.
The video covers how to perform calculations using operators like plus, minus, asterisk, and forward slash, as well as functions like SUM.
You can add numbers by typing them directly in a formula or by referencing cells that contain numbers.
The formula automatically updates if you change the referenced cells.
The video also demonstrates subtracting, multiplying, and dividing numbers in Excel.
This knowledge will help you perform basic math calculations efficiently in Microsoft 365.
The video covers how to perform calculations using operators like plus, minus, asterisk, and forward slash, as well as functions like SUM.
You can add numbers by typing them directly in a formula or by referencing cells that contain numbers.
The formula automatically updates if you change the referenced cells.
The video also demonstrates subtracting, multiplying, and dividing numbers in Excel.
This knowledge will help you perform basic math calculations efficiently in Microsoft 365.
- 2:28
- 3959 views
In this video, you will learn about using functions in Microsoft 365. The video covers the basics of functions and demonstrates how to use them effectively in various Microsoft 365 applications.
This will help you enhance your productivity and make the most out of the Microsoft 365 suite.
This will help you enhance your productivity and make the most out of the Microsoft 365 suite.
- 5:12
- 4264 views
In this video, you will learn about Microsoft 365 and how it can benefit you.
The video covers the Office Online suite, its advantages, and the potential of Word, Excel, and PowerPoint online.
It also demonstrates how to navigate Office Online, manage storage spaces, collaborate, and share documents.
This training will help you become familiar with the online version of Microsoft Office and its various tools.
By the end of the video, you will have a better understanding of how to use Office Online to create and collaborate on documents, presentations, and more.
This knowledge will enable you to work efficiently and effectively with Microsoft 365.
The video covers the Office Online suite, its advantages, and the potential of Word, Excel, and PowerPoint online.
It also demonstrates how to navigate Office Online, manage storage spaces, collaborate, and share documents.
This training will help you become familiar with the online version of Microsoft Office and its various tools.
By the end of the video, you will have a better understanding of how to use Office Online to create and collaborate on documents, presentations, and more.
This knowledge will enable you to work efficiently and effectively with Microsoft 365.
- 2:04
- 3890 views
In this video, you will learn about more complex formulas in Microsoft 365. The video covers advanced formula techniques and demonstrates how to create complex formulas in Excel using functions and operators.
This will help you enhance your data analysis skills and make more sophisticated calculations in Excel.
This will help you enhance your data analysis skills and make more sophisticated calculations in Excel.
- 4:17
- 4752 views