Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 2021 Power User Tutorial

Learnit Training via YouTube

Start learning Write review
Corporate Finance Institute Ad

Finance Certifications Goldman Sachs and Amazon Teams Trust

Learn More → CodeSignal Ad

2,000+ Free Courses with Certificates: Coding, AI, SQL, and More

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This advanced course teaches Excel power-user techniques for combining functions and tools to solve time-intensive tasks efficiently. Topics include XLOOKUP, advanced PivotTables, array formulas, conditional formatting, charts, and introductory macros.

Syllabus

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

Taught by

Learnit Training

Reviews

Start your review of Excel 2021 Power User Tutorial

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.