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 Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard