Completed
- Exercise 05
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Advanced Excel 365 Training: Dynamic Arrays, Complex Lookups, and Power Tools
Automatically move to the next video in the Classroom when playback concludes
- 1 - Course Introduction
- 2 - Exercise 01
- 3 - What are Dynamic Array Functions?
- 4 - Introduction to Spills and Arrays
- 5 - Extract and Count Unique Entries
- 6 - Unique vs Distinct
- 7 - Extract Multiple Unique Columns
- 8 - Extract Unique Values by Column
- 9 - The SORT Function
- 10 - The SORT Function - Horizontal Sort
- 11 - The SORTBY Function
- 12 - The SORTBY Function - Horizontal SORTBY
- 13 - The SEQUENCE Function
- 14 - The FILTER Function
- 15 - FILTER with Logic: + Operator OR
- 16 - FILTER with Logic: * Operator AND
- 17 - FILTER with Logic: = Operator Both or Neither Criteria
- 18 - FILTER with Logic: - Operator One or the Other but Not Both
- 19 - RANDARRAY and RANDBETWEEN
- 20 - Use XLOOKUP to Perform Complex Lookups
- 21 - The XMATCH Function
- 22 - Exercise 02
- 23 - Lookups with Multiple Criteria
- 24 - Lookups with Duplicate Values
- 25 - Exercise 03
- 26 - The LET Function
- 27 - Create Your Own Formulas with LAMBDA
- 28 - Exercise 04
- 29 - Create a Data Model in Power Pivot
- 30 - Create Relationships Between Tables
- 31 - Add Calculated Columns
- 32 - Build a PivotTable from Multiple Sources
- 33 - Exercise 05
- 34 - Import Data Using Power Query
- 35 - Clean Data with Power Query
- 36 - Combine Files from a Folder
- 37 - Add More Files to the Data Model and Refresh
- 38 - Exercise 06
