Главная
Study mode:
on
1
Start
2
Introduction
3
DB Functions, XLOOKUP, VLOOKUP, INDEX, MATCH
4
Excel XLOOKUP Two-Way Search
5
Text Functions
6
Advanced Pivot Tables
7
INDEX MATCH Array Function
8
Advanced Conditional Formats
9
Excel Charts
10
Introduction to Macros
11
Macro Examples
12
Conclusion
Description:
Master advanced Excel 2021 techniques in this comprehensive power user tutorial. Dive deep into data mining tools like VLOOKUP, XLOOKUP, INDEX, and MATCH functions. Explore dynamic ranges, advanced pivot tables, and conditional formatting to expedite data analysis. Learn to create sophisticated charts and harness the power of macros for automation. Designed for experienced Excel users, this tutorial will elevate your skills, enabling you to solve complex problems more efficiently and push the boundaries of Excel's capabilities.

Excel 2021 Power User Tutorial

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