Elevate your Excel 2019 skills to power user level in this comprehensive tutorial designed for advanced users. Dive deep into advanced functions like VLOOKUP, INDEX, MATCH, and OFFSET, learning how to troubleshoot and optimize their usage. Explore data mining techniques, dynamic ranges, and innovative problem-solving approaches. Master PivotTables with calculated fields and items, array formulas, conditional formatting, and combo charts. Delve into macro recording and editing to automate complex tasks. By the end of this 75-minute tutorial, you'll have the knowledge to tackle time-intensive tasks efficiently and push Excel to its limits, setting you apart as a true power user.
Overview
Syllabus
Start
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
