Главная
Study mode:
on
1
Start
2
Introduction
3
Formatting Lists as Tables
4
Flash Fill
5
Custom Sorting
6
Subtotals
7
QA Tool
8
Data Charts
9
Sparklines
10
Introduction to Pivot Tables
11
Advanced Pivot Tables Options
12
Data Validation
13
Conditional Formats
14
Comments and Notes
15
Linking Data
16
Privacy and Protection
17
Conclusion
Description:
Master advanced Excel 2021 techniques in this comprehensive tutorial designed for users of all levels. Explore essential features like formatting lists as tables, utilizing Flash Fill, and implementing custom sorting. Learn to create subtotals, use the QA Tool, and generate data charts and sparklines. Dive into pivot tables, from basic concepts to advanced options. Discover data validation techniques, apply conditional formatting, and manage comments and notes. Understand how to link data across sheets and workbooks, and implement privacy and protection measures. With practical exercises and step-by-step guidance, enhance your Excel skills to boost productivity and data analysis capabilities.

Excel 2021 Advanced Tutorial

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