Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The FILTER Function - 1
In this video, we will cover the FILTER function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The SORT and SORTBY Functions
In this video, we will cover the SORT and SORTBY functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The OFFSET Function
In this video, we will cover the OFFSET function.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using XLOOKUP and XMATCH
In this video, you will learn how to use XLOOKUP and XMATCH.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Performing Flexible Lookups with INDEX And MATCH
In this video, you will learn how to perform flexible lookups with INDEX And MATCH.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information Using VLOOKUP (Exact Match)
In this video, you will learn how to look up information using VLOOKUP (Exact Match).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Nested IFs
In this video, we will cover nested IFs.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Logical Functions (AND, OR, IF)
In this video, we will cover logical functions (AND, OR, IF).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Adding Navigation Buttons
In this video, you will learn how to add navigation buttons.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - The Golden Rules of Spreadsheet Design
In this video, we will cover the golden rules of spreadsheet design.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Protecting Workbooks and Worksheets
In this video, you will learn how to protect workbooks and worksheets.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Setting Print Titles and a Background
In this video, you will learn how to set print titles and a background.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Setting Margins and Orientation
In this video, you will learn how to set margins and orientation.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 12 - insert pictures and edit them
In this video, we will focus on Exercise 12 of this section, where we will insert pictures and edit them.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Creating Diagrams using SmartArt
In this video, you will learn how to create diagrams using SmartArt.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Inserting Shapes and Text Boxes
In this video, you will learn how to insert shapes and text boxes.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Inserting Pictures
In this video, you will learn how to insert pictures.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 09 - VLOOKUP formula
In this video, we will focus on Exercise 09 of this section, where we will apply the VLOOKUP formula.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Working with Time and Date Functions
In this video, you will learn how to work with time and date functions.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Basic Logical Functions (IF, AND, OR)
In this video, we will cover basic logical functions (IF, AND, OR).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Looking Up Information with VLOOKUP
In this video, you will learn how to look up information with VLOOKUP.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Inserting Hyperlinks to Worksheets
In this video, you will learn how to insert hyperlinks to worksheets.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Format as a Table
In this video, you will learn to format as a table.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Aligning Text and Numbers
In this video, you will learn how to align text and numbers.