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