Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using XLOOKUP to Perform Complex Lookups
In this video, you will learn how to use XLOOKUP to perform complex lookups.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using RANDARRAY and RANDBETWEEN to Randomize Data
In this video, you will learn how to use RANDARRAY and RANDBETWEEN to randomize data.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: - Operator (One or the Other)
In this video, we will cover FILTER with logic and learn about - Operator (One or the Other).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - FILTER with Logic: = Operator (Both or Neither)
In this video, we will cover FILTER with logic and learn about = Operator (Both or Neither).
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Simple SEQUENCE and Unstacking Records
In this video, we will cover simple SEQUENCE and unstacking records.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Introduction to Spills and Arrays
In this video, we will get introduced to Spills and Arrays.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 12 - perform a WhatIf analysis
In this video, we will focus on Exercise 12 of this section, where we will perform a WhatIf analysis.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Custom Data Validation
In this video, we will cover custom data validation.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Assembling a Dashboard - Part 2
In this video, you will learn how to assemble a dashboard - part 2.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Assembling a Dashboard - Part 1
In this video, you will learn how to assemble a dashboard - part 1.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Formatting a Pivot Chart - Part 2
In this video, you will learn how to format a pivot chart - part 2.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Importing Data into Excel
In this video, you will learn how to import data into Excel.
Curated Video
Microsoft Excel 2021365 - Beginner to Advanced - Using Date and Time Functions
In this video, you will learn how to use date and time functions.
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.