Videos Learn with Our Expert Trainers
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
- 3663 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
- 449 views
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
- 4437 views
Discover techniques to efficiently organize your Outlook messages into folders. Learn to create, categorize, and manage subfolders with ease. Enhance accessibility by adding favorite folders and automating message routing with rules. Watch the tutorial for in-depth insights into using Outlook's organizational features!
- 01:57
- 429 views
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
Learn how to request a read receipt or delivery confirmation in Outlook. Discover how these features can help you track important communications and ensure your messages are received. Follow simple steps to enable read receipts and delivery confirmations, and even set them as default for all your emails. Manage your professional communications effectively with this helpful tutorial!
- 02:01
- 973 views
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
- 4334 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
- 604 views
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
- 4478 views
It also demonstrates how to save time while searching and how to access your most recently used documents.
This will help you gain efficiency and save time in your searches using Microsoft's intelligent search tool.
- 3:22
- 3878 views
Discover how to save and print emails in Outlook with this tutorial. Learn to back up important emails and organize them into a physical collection. From saving emails as EML files to printing them as PDF or physical copies, this guide covers it all. Follow the step-by-step instructions and take control of your email management.
- 01:48
- 435 views