Excel 2019 Power User Tutorial

Excel 2019 Power User Tutorial

For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com

Enroll in our live, instructor-led Excel classes:
https://bit.ly/3zWh8NF

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Exercise Files: https://bit.ly/3nIWwkC

Start 0:00
Introduction 0:03
Troubleshooting VLOOKUP 2:21
Using IFERROR 11:05
Replacing VLOOKUP with XLOOKUP 13:42
Index Match 17:40
Text Functions 22:28
PivotTables - 2019 Features 27:15
PivotTables - Calculated Field 33:40
PivotTables - Calculated Items 37:06
PivotTables - Show Values As 39:30
Array Formulas and Functions 40:49
Index and Match Array Function 43:16
Conditional Format New Rule Examples 49:09
Combo Charts and Sparklines 54:33
Add Developer Recording Macros 1:00:05
Editing, Saving, and Stepping into a Macro 1:05:17
Recording a Format Macro 1:09:39
Conclusion 1:14:25

#Excel

(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

Видео Excel 2019 Power User Tutorial канала Learnit Training