Platform Banner

Tutorials Look for a precise manipulation or a trick on software

Sort

Filters

Selected for you

2:38
Vu 4876 fois
VLOOKUP: How and when to use it
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.
3:05
Vu 4764 fois
The nuts and bolts of VLOOKUP
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.
2:39
Vu 4616 fois
Look up values on a different worksheet
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.
2:52
Vu 5166 fois
Input and error messages
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.
6:12
Vu 4752 fois
Manage drop-down lists
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.
3:37
Vu 4933 fois
Take conditional formatting to the next level
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.
4:20
Vu 4627 fois
Use formulas to apply conditional formatting
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.
4:30
Vu 4599 fois
Manage conditional formatting
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.
2:02
Vu 4085 fois
Use conditional formatting
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.
1:38
Vu 3845 fois
Sort and filter data
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.
4:46
Vu 4088 fois
Sort details
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.
3:27
Vu 4143 fois
AutoFilter details
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.

An Error Has Occurred

Unable to save your progress. Please reload the page, log in, and try again. If the problem persists, please contact an administrator.

Close

Reminder

Show

/

Join Live Training Session