Главная
Study mode:
on
1
Start
2
Excel Power User 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
Excel Power User Conclusion
13
Pivot Tables Introduction
14
Organizing Data in Tables
15
More Data Organization Techniques
16
Data Mining
17
Custom Sort Command and Functions
18
Merge Data Using XLOOKUP
19
Pivot Tables - Setup
20
Pivot Tables - Building Reports
21
Pivot Tables - Formats, Drilldowns, and Refreshing
22
Pivot Tables - Designing for Reports and Charts
23
Pivot Tables - Cal Fields, Items, and Grouping
24
Power Pivot - Turning It On
25
Power Pivot - Adding Data and Establishing Relationships
26
Power Pivot - RELATED Function and Pivot Tables
27
Pivot Tables Conclusion
28
Intro to Data Analysis Introduction
29
Working with Tables
30
Conditional Formats
31
Using the IF FUNCTION
32
Database Functions
33
Unique, Sort, and Filter Functions
34
Charts and Sparklines
35
Working with Pivot Tables
36
Intro to Data Analysis Conclusion
37
XLOOKUP Introduction
38
VLOOKUP Refresher
39
XLOOKUP Basics
40
INDEX and MATCH
41
XLOOKUP - Approx Match Results
42
XLOOKUP - Returning Multiple Values
43
XLOOKUP - Two Way Search
44
XLOOKUP Conclusion
Description:
Master advanced Excel 2021 techniques in this comprehensive 4-hour tutorial designed for power users. Dive deep into complex functions like XLOOKUP, INDEX-MATCH, and OFFSET to enhance data mining capabilities. Learn to create dynamic ranges, manipulate large datasets, and build sophisticated Pivot Tables and charts. Explore data analytics tools, including conditional formatting, custom sorting, and power features. Gain proficiency in macros, Power Pivot, and advanced data analysis techniques. Develop problem-solving skills to tackle challenging Excel tasks efficiently, pushing the boundaries of what's possible with spreadsheet software. Perfect for experienced users looking to elevate their Excel expertise and streamline complex data processes.

Excel 2021 Power User Full Course

Learnit Training
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Mining #Data Analysis #Spreadsheets #Pivot Tables #VLOOKUP #XLOOKUP
0:00 / 0:00
1 of 44

Start