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

YouTube

Excel 2021 Advanced Tutorial - Part 3 of 3

Learnit Training via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Dive into advanced Excel 2021 techniques in this comprehensive tutorial video, the final part of a three-part series. Master complex functions like nesting, database operations, and XLOOKUP. Explore powerful features such as UNIQUE, SORT, SORTBY, and FILTER for efficient data manipulation. Learn to streamline calculations with the LET function and consolidate data from multiple sources. Gain an introduction to macros, including how to record and play them for task automation. Access accompanying exercise files to practice and reinforce your learning throughout this hour-long session, designed to elevate your Excel skills to an advanced level.

Syllabus

Start
Nesting Functions
Database Functions
XLOOKUP
UNIQUE
SORT and SORTBY
FILTER
LET
Consolidate
Introduction to Macros
Recording and Playing Macros
Conclusion

Taught by

Learnit Training

Reviews

Start your review of Excel 2021 Advanced Tutorial - Part 3 of 3

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.