Videos Learn with Our Expert Trainers
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
- 4492 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
- 3831 views
Discover how to use the immersive reader feature in Outlook to enhance your email experience. Learn to customize the voice settings, text preferences, grammar options, and reading focus, and even translate messages into different languages. With this feature, you can listen to and share information from your emails more easily, making communication more accessible and efficient.
- 01:33
- 440 views
In this video, you will learn how to conditionally format dates in Microsoft 365. The video covers the process of highlighting overdue tasks in red, tasks due in a week or more in green, and tasks due within seven days in yellow.
This will help you easily identify and track the status of tasks based on their due dates.
This will help you easily identify and track the status of tasks based on their due dates.
- 2:38
- 4050 views
In this video, you will learn about conditionally formatting text using Microsoft 365. The video covers the process of formatting text based on specific conditions, such as highlighting cells that meet certain criteria or applying different font styles to different values.
This feature is useful for visually organizing and analyzing data in Excel.
By mastering conditional formatting, you can enhance the visual appeal and readability of your spreadsheets, making it easier to identify trends and patterns.
This tutorial will provide you with step-by-step instructions on how to apply conditional formatting in Microsoft 365, helping you optimize your data analysis and presentation skills.
This feature is useful for visually organizing and analyzing data in Excel.
By mastering conditional formatting, you can enhance the visual appeal and readability of your spreadsheets, making it easier to identify trends and patterns.
This tutorial will provide you with step-by-step instructions on how to apply conditional formatting in Microsoft 365, helping you optimize your data analysis and presentation skills.
- 2:12
- 3747 views
In this video, you will learn how to copy and remove conditional formatting in Microsoft 365. The video covers the process of applying conditional formatting to a cell and demonstrates how to copy the formatting to other cells.
It also shows how to remove conditional formatting from specific cells and the entire worksheet.
This knowledge will help you effectively apply and manage conditional formatting in your Microsoft 365 documents.
It also shows how to remove conditional formatting from specific cells and the entire worksheet.
This knowledge will help you effectively apply and manage conditional formatting in your Microsoft 365 documents.
- 1:11
- 3668 views
Discover how to customize and manage teams meeting options using Outlook. Learn to schedule, invite participants, and modify meeting options according to your needs. From controlling participant interactions to assigning co-organizers, this video provides essential tips for handling various settings. Find out how to optimize your meeting experience and ensure smooth collaboration. #outlook #discovery #collaborate
- 01:56
- 453 views
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
- 4452 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
- 4497 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
- 4344 views
Discover how to set up personalized reminders in Outlook to manage your time effectively. Whether it's for birthdays or important tasks, these reminders can keep you on track. Learn to create recurring events, set private reminders, and utilize the 'out of office' feature to avoid scheduling conflicts. With these Outlook features, you'll never miss key dates and can prevent unwanted meetings from being added to your calendar when you're unavailable.
- 01:59
- 615 views
In this video, you will learn how to copy a VLOOKUP formula in Microsoft 365. The video demonstrates the process of using absolute cell references by adding dollar signs to your arguments.
By doing this, you can copy the formula down a column and ensure that the references remain fixed.
The video also provides tips on using the F4 key to add dollar signs correctly and highlights common mistakes to avoid when using VLOOKUP, such as arranging data in columns and using the correct range lookup argument.
This tutorial will help you efficiently copy VLOOKUP formulas and avoid errors in your spreadsheets.
By doing this, you can copy the formula down a column and ensure that the references remain fixed.
The video also provides tips on using the F4 key to add dollar signs correctly and highlights common mistakes to avoid when using VLOOKUP, such as arranging data in columns and using the correct range lookup argument.
This tutorial will help you efficiently copy VLOOKUP formulas and avoid errors in your spreadsheets.
- 3:27
- 4494 views