Tutorials Look for a precise manipulation or a trick on software
In this video, you will learn about VLOOKUP and how and when to use it.
The video covers the VLOOKUP function, which is similar to a phone book, where you start with a piece of data and use it to find other related information.
The video demonstrates how to use VLOOKUP to find prices based on part numbers in a large spreadsheet.
By entering the part number in a specific cell, you can retrieve the corresponding price.
This will help you efficiently find information in a large dataset and save time.
The video covers the VLOOKUP function, which is similar to a phone book, where you start with a piece of data and use it to find other related information.
The video demonstrates how to use VLOOKUP to find prices based on part numbers in a large spreadsheet.
By entering the part number in a specific cell, you can retrieve the corresponding price.
This will help you efficiently find information in a large dataset and save time.
- 2:38
- 4657 views
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
- 4618 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
- 4459 views
In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers how to find documents, images, videos, people, and conversations using the search bar located at the top of your Microsoft Office apps.
It also demonstrates how to search your online storage services and run an online search in the Microsoft Bing search engine.
This powerful tool helps you gain time and efficiency in your searches, making it easier to access your most recently used documents.
This will help you improve your productivity and find what you need quickly in the Microsoft 365 environment.
It also demonstrates how to search your online storage services and run an online search in the Microsoft Bing search engine.
This powerful tool helps you gain time and efficiency in your searches, making it easier to access your most recently used documents.
This will help you improve your productivity and find what you need quickly in the Microsoft 365 environment.
- 2:52
- 4255 views
In this video, you will learn how to manage drop-down lists in Excel.
The video covers various techniques such as hiding and unhiding columns or rows, password protecting worksheets, locking specific cells, editing and deleting dropdown list options, and managing named ranges.
This knowledge will help you effectively organize and control data in your Excel spreadsheets.
The video covers various techniques such as hiding and unhiding columns or rows, password protecting worksheets, locking specific cells, editing and deleting dropdown list options, and managing named ranges.
This knowledge will help you effectively organize and control data in your Excel spreadsheets.
- 6:12
- 4488 views
In this video, you will learn how to take conditional formatting to the next level.
The video covers how to apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
It demonstrates how to use the quick analysis option for formatting and how to have more control over the type of formatting applied by creating new rules.
You will also learn how to format cells that are blank or contain errors.
This knowledge will help you enhance your data analysis and visualization skills using conditional formatting in Microsoft 365.
The video covers how to apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
It demonstrates how to use the quick analysis option for formatting and how to have more control over the type of formatting applied by creating new rules.
You will also learn how to format cells that are blank or contain errors.
This knowledge will help you enhance your data analysis and visualization skills using conditional formatting in Microsoft 365.
- 3:37
- 4605 views
In this video, you will learn how to use formulas to apply conditional formatting in Microsoft 365. The video demonstrates selecting cells in the Product column and using a formula to format them based on the values in the In stock column.
By creating rules with different formulas, you can apply different fill colors to cells based on their values.
This tutorial will help you enhance your formatting skills and make your data more visually appealing.
By creating rules with different formulas, you can apply different fill colors to cells based on their values.
This tutorial will help you enhance your formatting skills and make your data more visually appealing.
- 4:20
- 4556 views
In this video, you will learn how to manage conditional formatting in Microsoft 365. The video covers the rules manager, where you can create, edit, and delete formatting rules for specific areas of a workbook or worksheet.
It also explains how to manage the precedence of rules when conflicting rules apply to cells.
By changing the order of the rules, you can control how cells are formatted based on their values.
The video also demonstrates how to use conditional formatting to sort and filter a worksheet based on the applied formatting.
This will help you effectively utilize conditional formatting in Microsoft 365 and improve your data analysis and visualization.
It also explains how to manage the precedence of rules when conflicting rules apply to cells.
By changing the order of the rules, you can control how cells are formatted based on their values.
The video also demonstrates how to use conditional formatting to sort and filter a worksheet based on the applied formatting.
This will help you effectively utilize conditional formatting in Microsoft 365 and improve your data analysis and visualization.
- 4:30
- 4568 views
In this video, you will learn about using conditional formatting in Microsoft 365. Conditional formatting provides visual cues to help you make sense of your data by highlighting highs, lows, and other data trends based on specified criteria.
You can apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
The video demonstrates how to quickly apply conditional formatting using the formatting button in the ribbon, as well as how to have more control over the formatting by creating new rules.
You can format cells based on their values, such as using icon sets, and even format cells that are blank or contain errors.
This tutorial will help you enhance your data analysis skills and make your data more visually appealing.
You can apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
The video demonstrates how to quickly apply conditional formatting using the formatting button in the ribbon, as well as how to have more control over the formatting by creating new rules.
You can format cells based on their values, such as using icon sets, and even format cells that are blank or contain errors.
This tutorial will help you enhance your data analysis skills and make your data more visually appealing.
- 2:02
- 3975 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
- 3782 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
- 4056 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
- 4121 views