Completed
- XLookUp
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Excel Advanced Excel Training Course
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction
- 2 - Exercise 01
- 3 - Dynamic Arrays
- 4 - Spill and Arrays
- 5 - Extract and Count Unique Entries
- 6 - Unique vs. Distinct
- 7 - Unique with Multiple Criteria
- 8 - Unique Values by Column
- 9 - SORT Function
- 10 - Horizontal Sort
- 11 - SORTBY Function
- 12 - Horizontal SORTBY
- 13 - Sequence and Unstacking Records
- 14 - Filter Function
- 15 - Using Filter with Logic Plus Operator
- 16 - Using Filter with Logic Asterisk Operator
- 17 - Using Filter with Logic Equals Operator
- 18 - Using Filter with Logic Minus Operator
- 19 - RANDARRAY and RANDBETWEEN
- 20 - XLookUp
- 21 - XMatch
- 22 - Exercise 02
- 23 - Two-way Lookups
- 24 - CHOOSE Function
- 25 - SWITCH Function
- 26 - Exercise 03
- 27 - Median and Mode
- 28 - Using LARGE and SMALL
- 29 - Ranking Data
- 30 - COUNTBLANK Function
- 31 - Exercise 04
- 32 - Rounding Values
- 33 - Specialized Rounding
- 34 - Aggregate Function
- 35 - Exercise 05
