Overview
This course is designed for advanced Excel users looking to enhance their skills beyond typical Excel tools and processes. Participants will learn to intermix tools in Excel to accomplish time-intensive tasks, develop a deeper understanding of data mining tools like VLOOKUP, INDEX, MATCH, and OFFSET functions, expedite data analysis through dynamic ranges, and push Excel to its limits with new problem-solving perspectives. The course focuses on building resources to solve problems faster and with less effort, catering to individuals who are willing to invest time in mastering Excel for efficient data analysis.
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