YoVDO

Excel 2019 Power User Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Mining Courses Data Analysis Courses VLOOKUP Courses PivotTables Courses Array Formulas Courses

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 Science
University 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