Главная
Study mode:
on
1
Start
2
Introduction
3
Start Screen
4
Excel Interface
5
Zooming, Navigating, and Shortcuts
6
Performing Excel Calculations
7
Simple Excel Functions
8
ABS, REF, and AutoFill Functions
9
Checking Compatibility
10
Inserting, Moving, and Cutting
11
Cell Styles
12
Themes
13
Showing and Hiding Worksheets
14
Grouping Worksheets
15
Freeze Panes
16
Custom Views
17
Saving Templates
18
Spell Check
19
Print Preview
20
Conclusion
21
Introduction
22
Formatting Lists as Tables
23
Flash Fill
24
Custom Sorting
25
Subtotals
26
QA Tool
27
Data Charts
28
Sparklines
29
Introduction to Pivot Tables
30
Advanced Pivot Tables Options
31
Data Validation
32
Conditional Formats
33
Comments and Notes
34
Linking Data
35
Privacy and Protection
36
Conclusion
37
Introduction
38
Nesting Functions
39
Database Functions
40
XLOOKUP
41
UNIQUE
42
SORT and SORTBY
43
FILTER
44
LET
45
Consolidate
46
Introduction to Macros
47
Recording and Playing Macros
48
Conclusion
Description:
Embark on a comprehensive 3-hour 49-minute tutorial designed for beginners to experienced users seeking to enhance their Microsoft Excel 2021 skills. Master the user interface, navigate efficiently, and progress through basic calculations to advanced features. Learn to manipulate data with formulas, functions, and pivot tables. Explore intermediate tools for sorting, filtering, and data visualization. Dive into advanced topics including complex database functions, macros, and task automation. Gain practical knowledge through hands-on exercises and real-world examples, covering everything from basic spreadsheet operations to sophisticated data analysis techniques. By the end of this in-depth course, acquire the skills to efficiently organize, analyze, and present data, significantly boosting your productivity in Excel 2021.

Excel 2021 Full Course Tutorial

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