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

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course is designed for advanced Excel users looking to enhance their skills beyond typical Excel tools and processes. Participants will learn to intermix tools in Excel to accomplish time-intensive tasks, develop a deeper understanding of data mining tools like VLOOKUP, and explore advanced solutions like the INDEX, MATCH, and OFFSET functions. The course focuses on expediting data analysis through dynamic ranges and pushing Excel to its limits with new problem-solving perspectives. The teaching method includes video tutorials covering various topics such as DB functions, XLOOKUP, advanced pivot tables, Excel charts, macros, and more. The intended audience for this course are individuals who have completed Excel Beginner, Intermediate, and Advanced training, or are proficient in the skills covered in those courses.

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.