Tutorials Look for a precise manipulation or a trick on software
In this video, you will learn about the nuts and bolts of VLOOKUP.
The video breaks down how VLOOKUP works and explains its four arguments:
the lookup value, the table array, the column reference, and the range lookup.
It also highlights some important considerations, such as the need for the lookup values to be in the left-hand column of the table array and the arrangement of data in columns vertically.
The video demonstrates how to use VLOOKUP to find exact matches or partial matches and provides examples of both.
This tutorial will help you understand and effectively use the VLOOKUP function in Microsoft 365.
The video breaks down how VLOOKUP works and explains its four arguments:
the lookup value, the table array, the column reference, and the range lookup.
It also highlights some important considerations, such as the need for the lookup values to be in the left-hand column of the table array and the arrangement of data in columns vertically.
The video demonstrates how to use VLOOKUP to find exact matches or partial matches and provides examples of both.
This tutorial will help you understand and effectively use the VLOOKUP function in Microsoft 365.
- 3:05
- 4494 views
In this video, you will learn how to look up values on a different worksheet using Microsoft 365. The video demonstrates how to use the VLOOKUP function to aggregate data from multiple worksheets into one place.
By entering the appropriate arguments, such as the column reference and the range of cells to search, you can find matching values and retrieve the desired information.
This tutorial will help you efficiently gather and analyze data from different worksheets, improving your data management skills.
By entering the appropriate arguments, such as the column reference and the range of cells to search, you can find matching values and retrieve the desired information.
This tutorial will help you efficiently gather and analyze data from different worksheets, improving your data management skills.
- 2:39
- 4333 views
In this video, you will learn about sorting and filtering data in Microsoft Excel.
The video covers how to change the order of your data by sorting it and how to filter a range of cells or a table to focus on specific data.
This will help you analyze and organize your data more effectively.
The video covers how to change the order of your data by sorting it and how to filter a range of cells or a table to focus on specific data.
This will help you analyze and organize your data more effectively.
- 1:38
- 3535 views
In this video, you will learn about sorting details in Microsoft 365. The video covers how to efficiently sort and organize your documents and information using the intelligent search feature in Microsoft 365. This will help you save time and improve your productivity by easily finding the documents and information you need.
- 4:46
- 3979 views
In this video, you will learn about AutoFilter details in Microsoft 365. The video covers how to filter data by unchecking and checking values, filtering for blank cells, using criteria to filter, applying AutoFilter to multiple columns, and auditing filters by cell and font color.
This will help you effectively filter and analyze data in Excel.
This will help you effectively filter and analyze data in Excel.
- 3:27
- 4041 views
In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and efficiently find documents, information, and even conversations within the Microsoft 365 suite.
This will help you save time and efficiently find documents, information, and even conversations within the Microsoft 365 suite.
- 1:38
- 3710 views
In this video, you will learn about the new features and enhancements in Office 2016. The video covers the changes in Outlook, such as the ability to attach files from different locations and change permissions.
It also explores new charts and maps in Excel, including the ability to create tables based on geographical data.
Additionally, the video showcases the collaboration features in all Office applications, allowing users to share and edit documents simultaneously.
The video concludes by highlighting the "Tell me what you want to do" feature and the smart lookup function available in Office 2016. This tutorial will help you make the most of Office 2016 and improve your productivity.
It also explores new charts and maps in Excel, including the ability to create tables based on geographical data.
Additionally, the video showcases the collaboration features in all Office applications, allowing users to share and edit documents simultaneously.
The video concludes by highlighting the "Tell me what you want to do" feature and the smart lookup function available in Office 2016. This tutorial will help you make the most of Office 2016 and improve your productivity.
- 3:22
- 4190 views
In this video, you will learn about how things are organized in Microsoft 365. The video covers the search tools in Microsoft 365 and demonstrates how to find documents, emails, notes, and more.
This will help you save time and be more efficient in your searches, allowing you to easily access the information you need.
This will help you save time and be more efficient in your searches, allowing you to easily access the information you need.
- 1:58
- 4137 views
In this video, you will learn about the ribbon in Microsoft Outlook.
The ribbon is a collection of tabs that provide access to various commands and actions.
The main tabs include Home, Send/Receive, Folder, View, and File.
Each tab is specific to the module you are in, such as Mail or Calendar.
The ribbon can be customized to display only the tabs or both tabs and commands.
Additional options and features can be accessed through pop-up tabs or by hovering over buttons.
To customize the ribbon, go to the File tab and select Options.
This video provides a closer look at the ribbon and its functionality in Microsoft Outlook.
This knowledge will help you effectively manage your content and improve your productivity.
The ribbon is a collection of tabs that provide access to various commands and actions.
The main tabs include Home, Send/Receive, Folder, View, and File.
Each tab is specific to the module you are in, such as Mail or Calendar.
The ribbon can be customized to display only the tabs or both tabs and commands.
Additional options and features can be accessed through pop-up tabs or by hovering over buttons.
To customize the ribbon, go to the File tab and select Options.
This video provides a closer look at the ribbon and its functionality in Microsoft Outlook.
This knowledge will help you effectively manage your content and improve your productivity.
- 3:55
- 4393 views
In this video, you will learn how to save, publish, and share files using Microsoft 365. The video covers the features of Office apps like Word, Excel, and PowerPoint, which allow you to be creative and work together securely.
You can save your files in the cloud with OneDrive, making them accessible from anywhere.
Microsoft 365 allows you to store any type of file, including images, spreadsheets, and presentations.
You can also share and collaborate in real-time with your coworkers, whether you're in the office or on the go.
With the mobile apps and Office for the web, you can stay organized, connected, and productive from any device and browser.
This tutorial will help you master the essential skills of saving, publishing, and sharing files using Microsoft 365, enhancing your productivity and efficiency.
You can save your files in the cloud with OneDrive, making them accessible from anywhere.
Microsoft 365 allows you to store any type of file, including images, spreadsheets, and presentations.
You can also share and collaborate in real-time with your coworkers, whether you're in the office or on the go.
With the mobile apps and Office for the web, you can stay organized, connected, and productive from any device and browser.
This tutorial will help you master the essential skills of saving, publishing, and sharing files using Microsoft 365, enhancing your productivity and efficiency.
- 2:22
- 3751 views
In this video, you will learn about how to search and find what you need using Microsoft 365. The video covers the usage of OneDrive, Yammer, and Delve in the Office 365 subscription to help you access and organize your documents, collaborate with colleagues, and discover relevant information.
This tutorial will enhance your productivity and efficiency in finding and managing your files.
This tutorial will enhance your productivity and efficiency in finding and managing your files.
- 3:58
- 4122 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
- 3686 views