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

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This advanced Excel course teaches users to combine functions and features for faster data analysis, including XLOOKUP, INDEX/MATCH array formulas, advanced PivotTables, conditional formatting, charts, and introductory VBA macros. It assumes proficiency with foundational Excel skills.

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

Reviews

Start your review of Excel 2021 Power User Tutorial

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.