Главная
Study mode:
on
1
Start
2
Introduction
3
Overview of List Design
4
Formatting Lists as Tables
5
Filtering Records from Lists or Tables
6
Removing Duplicates from Lists or Tables
7
Flash Fill
8
Single & Multi-Level Sorting
9
Inserting Automatic Subtotals in Lists
10
Inserting Data Charts Using Recommended Charts
11
Formatting & Editing Chart Elements
12
Creating & Applying Custom Chart Templates
13
Adding & Removing Data from Charts
14
Inserting Sparklines
15
Printing Charts
16
Inserting Pivot Tables
17
Filtering Pivot Tables
18
Using Report Layouts in Pivot Tables
19
Refreshing & Changing Source Data in Pivot Tables
20
Inserting Pivot Charts
21
Data Validation
22
Applying Built-In Conditional Formatting
23
Creating Custom Conditional Formats
24
Linking Data
25
Comments
26
Protection
Description:
Dive into advanced Excel 2019 techniques in this comprehensive tutorial designed for users of all levels seeking to enhance their spreadsheet skills and boost productivity. Learn to efficiently manage data through list design, table formatting, and filtering. Master advanced features like Flash Fill, multi-level sorting, and automatic subtotals. Explore data visualization with charts, custom templates, and sparklines. Gain expertise in pivot tables and charts, including filtering, report layouts, and data refreshing. Discover essential tools such as data validation, conditional formatting, and cell protection. Perfect your Excel proficiency with practical lessons on linking data and utilizing comments, equipping you to tackle complex spreadsheet tasks with confidence.

Excel 2019 Advanced Tutorial

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