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

Excel 2021 Expert Tutorial

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