Excel 2021 Power User Tutorial

Master advanced Excel 2021 techniques in this comprehensive power user tutorial. Dive deep into database functions, including XLOOKUP, VLOOKUP, INDEX, and MATCH. Explore two-way searches with XLOOKUP, manipulate text functions, and create advanced pivot tables. Learn to utilize INDEX MATCH array functions, implement advanced conditional formatting, and design sophisticated Excel charts. Gain an introduction to macros and explore practical macro examples. Designed for experienced Excel users seeking to enhance their skills, this tutorial provides in-depth knowledge on intermixing tools to solve complex problems efficiently and push Excel to its limits.

Start
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