Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
Start
Excel Power User 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
Excel Power User Conclusion
Pivot Tables Introduction
Organizing Data in Tables
More Data Organization Techniques
Data Mining
Custom Sort Command and Functions
Merge Data Using XLOOKUP
Pivot Tables - Setup
Pivot Tables - Building Reports
Pivot Tables - Formats, Drilldowns, and Refreshing
Pivot Tables - Designing for Reports and Charts
Pivot Tables - Cal Fields, Items, and Grouping
Power Pivot - Turning It On
Power Pivot - Adding Data and Establishing Relationships
Power Pivot - RELATED Function and Pivot Tables
Pivot Tables Conclusion
Intro to Data Analysis Introduction
Working with Tables
Conditional Formats
Using the IF FUNCTION
Database Functions
Unique, Sort, and Filter Functions
Charts and Sparklines
Working with Pivot Tables
Intro to Data Analysis Conclusion
XLOOKUP Introduction
VLOOKUP Refresher
XLOOKUP Basics
INDEX and MATCH
XLOOKUP - Approx Match Results
XLOOKUP - Returning Multiple Values
XLOOKUP - Two Way Search
XLOOKUP Conclusion
Learnit Training
Get personalized course recommendations, track subjects and courses with reminders, and more.
