Master advanced Excel 2021 techniques in this comprehensive power user tutorial. Dive deep into data mining tools like VLOOKUP, XLOOKUP, INDEX, and MATCH functions. Explore dynamic ranges, advanced pivot tables, and conditional formatting to expedite data analysis. Learn to create sophisticated charts and harness the power of macros for automation. Designed for experienced Excel users, this tutorial will elevate your skills, enabling you to solve complex problems more efficiently and push the boundaries of Excel's capabilities.
Overview
Syllabus
Start
Introduction
DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH
Excel XLOOKUP Two-Way Search
Text Functions
Advanced Pivot Tables
INDEX MATCH Array Function
Advanced Conditional Formats
Excel Charts
Introduction to Macros
Macro Examples
Conclusion
Taught by
Learnit Training
