Master advanced Excel 2019 techniques in this comprehensive power user tutorial designed for experienced users seeking to enhance their skills beyond typical tools and processes. Dive deep into data mining with VLOOKUP, INDEX, MATCH, and OFFSET functions, learn to expedite data analysis through dynamic ranges, and explore innovative problem-solving approaches. Discover how to intermix Excel tools for efficient task completion, create advanced PivotTables, work with array formulas, and leverage conditional formatting. Gain hands-on experience with combo charts, sparklines, and macro recording to automate tasks. Perfect for those who have completed basic Excel training and want to push the boundaries of what's possible with the software.
Overview
Syllabus
Start
Introduction
Troubleshooting VLOOKUP
Using IFERROR
Replacing VLOOKUP with XLOOKUP
Index Match
Text Functions
PivotTables - 2019 Features
PivotTables - Calculated Field
PivotTables - Calculated Items
PivotTables - Show Values As
Array Formulas and Functions
Index and Match Array Function
Conditional Format New Rule Examples
Combo Charts and Sparklines
Add Developer Recording Macros
Editing, Saving, and Stepping into a Macro
Recording a Format Macro
Conclusion
Taught by
Learnit Training
