Master advanced Excel 2021 techniques in this comprehensive tutorial designed for users of all levels. Explore nested functions, database operations, and powerful lookup tools like XLOOKUP. Learn to manipulate data efficiently with UNIQUE, SORT, SORTBY, and FILTER functions. Dive into the LET function for complex calculations and discover how to consolidate data from multiple sources. Gain an introduction to macros and learn how to record and play them to automate repetitive tasks. Enhance your spreadsheet skills and boost productivity with hands-on exercises and expert guidance throughout this hour-long video course.

Syllabus

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