Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel 2019 Power User
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (2:18)
Troubleshooting VLOOKUP (8:44)
Using IFERROR (2:36)
Replacing VLOOKUP with XLOOKUP (3:58)
Index Match (4:47)
Text Functions (4:47)
PivotTables - 2019 Features (6:24)
PivotTables - Calculated Field (3:26)
PivotTables - Calculated Items (2:23)
PivotTables - Show Values As (1:18)
Array Formulas and Functions (2:27)
Index and Match Array Function (5:53)
Conditional Format New Rule Examples (5:24)
Combo Charts and Sparklines (5:32)
Add Developer Recording Macros (5:11)
Editing, Saving, and Stepping Into a Macro (4:22)
Recording a Format Macro (4:45)
Conclusion (0:48)
Array Formulas and Functions
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock