Completed
- Modern Lookups: XLOOKUP and XMATCH
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Excel 365 Intermediate Training - 4-Hour Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 - Course Introduction
- 2 - Exercise 01
- 3 - Design Better Spreadsheet
- 4 - Improve Readability with Cell Styles
- 5 - Control Data Input: Data Validation
- 6 - Add Navigation to a Workbook
- 7 - Create a Summary Sheet
- 8 - Use Forms to Input Data Quickly
- 9 - Exercise 02
- 10 - Logical Functions: Basic Recap
- 11 - Logical Functions: AND and OR
- 12 - Nested IF Statements
- 13 - The IFS Function
- 14 - Conditional IF: COUNTIFS and SUMIFS
- 15 - Error Handling with IFERROR and IFNA
- 16 - Use Logical Functions with Conditional Formatting
- 17 - Exercise 03
- 18 - VLOOKUP: Exact vs Approx Match
- 19 - HLOOKUP
- 20 - Flexible Lookups: INDEX and MATCH
- 21 - Modern Lookups: XLOOKUP and XMATCH
- 22 - Lookups with Duplicates
- 23 - Lookups with the CHOOSE Function
- 24 - The SWITCH Function
- 25 - Exercise 04
- 26 - Sort on Multiple Columns
- 27 - Sort with a Custom List
- 28 - The SORT and SORTBY Functions
- 29 - The FILTER Function
- 30 - Extract and Sort Unique Values
- 31 - Exercise 05
- 32 - Find Duplicates with Conditional Formatting
- 33 - Find Duplicates with Formulas
- 34 - Exercise 06
- 35 - Use Mean, Median and Mode
- 36 - The LARGE and SMALL Functions
- 37 - RANK and RANK Average
- 38 - The SUBTOTAL and AGGREGATE Functions
- 39 - Exercise 07
- 40 - ROUND Values
- 41 - Special Rounding
- 42 - Exercise 08
- 43 - Custom Formatting Explained
- 44 - Practical Uses of Custom Formatting
- 45 - Advanced Conditional Formatting
- 46 - Exercise 09
- 47 - Conclusion
