Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 365 Advanced
Section 1: Introduction
Course Introduction (3:50)
DOWNLOAD ME: Course Files
DOWNLOAD ME: Exercise Files
Exercise 01 (1:02)
Section 2: Dynamic Array Formulas
What are Dynamic Array Functions? (2:25)
Introduction to Spills and Arrays (6:09)
Extract and Count Unique Entries (3:41)
Unique vs Distinct (4:10)
Extract Multiple Unique Columns (2:21)
Extract Unique Values by Column (3:36)
The SORT Function (5:49)
The SORT Function - Horizontal Sort (6:06)
The SORTBY Function (4:21)
The SORTBY Function - Horizontal SORTBY (3:59)
The SEQUENCE Function (4:51)
The FILTER Function (6:05)
FILTER with Logic: + Operator (OR) (5:14)
FILTER with Logic: * Operator (AND) (3:59)
FILTER with Logic: = Operator (Both or Neither Criteria) (3:09)
FILTER with Logic: - Operator (One or the Other but Not Both) (3:25)
RANDARRAY and RANDBETWEEN (9:22)
Use XLOOKUP to Perform Complex Lookups (7:28)
The XMATCH Function (4:10)
Exercise 02 (1:27)
Section 3: Advanced Lookup and Reference Functions
Lookups with Multiple Criteria (6:18)
Lookups with Duplicate Values (5:39)
Exercise 03 (1:48)
Section 4: Create Your Own Functions
The LET Function (9:34)
Create Your Own Formulas with LAMBDA (11:27)
Exercise 04 (2:00)
Section 5: Power Pivot
Create a Data Model in Power Pivot (6:37)
Create Relationships Between Tables (4:24)
Add Calculated Columns (5:58)
Build a PivotTable from Multiple Sources (3:52)
Exercise 05 (1:14)
Section 6: Working with Power Query
Import Data Using Power Query (5:25)
Clean Data with Power Query (9:18)
Combine Files from a Folder (6:28)
Add More Files to the Data Model and Refresh (6:40)
Exercise 06 (4:25)
Section 7: Advanced PivotTables and Pivot Charts
Create a Custom PivotTable Style (8:33)
Apply Custom Number Formatting (6:40)
Sorting Using Custom Lists (3:36)
Create Report Filter Pages (2:03)
Adjust Slicer Settings (9:03)
Lock Workbooks but not Slicers (3:11)
Add a Calculated Field (4:01)
Create a Calculated Item (4:40)
Use GETPIVOTDATA with Data Validation (6:54)
Create Dynamic Pivot Chart Labels (5:22)
Exercise 07 (1:59)
Section 8: Form Controls and Checkboxes
Introduction to Form Controls (6:02)
Combo Box: Select from a List (5:43)
Check Box: Check/Uncheck Option (7:00)
NEW Checkboxes (7:32)
Option Button: Choose an Option (5:02)
Spin Button: Move Up and Down a List (5:28)
List Box: Select from a List of Items (5:52)
Scroll Bar: Scroll Through a List (7:21)
Exercise 08 (1:51)
Section 9: Macros and VBA
Use Macros to Automate Tasks (6:39)
Record, Save and Run Macros (9:59)
Record Macros with Relative Referencing (6:58)
Multi-Step Macros (7:09)
The VBA Editor (7:55)
Assign Macros to Buttons (6:43)
Create a Custom Macro Ribbon (6:34)
Generate VBA Code with Copilot (5:01)
Exercise 09 (1:25)
Section 10: AI Tools (Microsoft Copilot and ChatGPT)
Introduction to Copilot (3:18)
Generate Sample Excel Datasets with AI (6:03)
Ask Questions and Get Help (2:05)
Copilot for Excel 365 (requires licence) (8:18)
Exercise 10 (2:01)
Section 11: Course Close
Course Close (3:48)
Course Quiz and Certificate of Completion
What are Dynamic Array Functions?
Complete and Continue