Excel 2019 Power User Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
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.
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
Related Courses
Introduction to Data ScienceUniversity of Washington via Coursera Big Data Analytics in Healthcare
Georgia Institute of Technology via Udacity More Data Mining with Weka
University of Waikato via Independent Mining Massive Datasets
Stanford University via edX Pattern Discovery in Data Mining
University of Illinois at Urbana-Champaign via Coursera