Главная
Study mode:
on
1
Start
2
Nesting Functions
3
Database Functions
4
XLOOKUP
5
UNIQUE
6
SORT and SORTBY
7
FILTER
8
LET
9
Consolidate
10
Introduction to Macros
11
Recording and Playing Macros
12
Conclusion
Description:
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.

Excel 2021 Advanced Tutorial - Part 3 of 3

Learnit Training
Add to list
0:00 / 0:00