Excel 2019 Power User Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
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.
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
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