Главная
Study mode:
on
1
Start
2
Overview of List Design
3
Formatting Lists as Tables
4
Filtering Records from Lists or Tables
5
Removing Duplicates from Lists or Tables
6
Flash Fill
7
Single & Multi-Level Sorting
8
Inserting Automatic Subtotals in Lists
9
Inserting Data Charts Using Recommended Charts
10
Formatting & Editing Chart Elements
11
Creating & Applying Custom Chart Templates
12
Adding & Removing Data from Charts
13
Inserting Sparklines
14
Printing Charts
15
Inserting Pivot Tables
16
Filtering Pivot Tables
17
Using Report Layouts in Pivot Tables
18
Refreshing & Changing Source Data in Pivot Tables
19
Inserting Pivot Charts
20
Data Validation
21
Applying Built-In Conditional Formatting
22
Creating Custom Conditional Formats
23
Linking Data
24
Comments
25
Protection
Description:
Dive into this comprehensive intermediate Excel 2019 tutorial designed for beginners to experienced users looking to enhance their spreadsheet skills. Learn to efficiently navigate the user interface, calculate data using formulas and functions, and master advanced features like sorting, filtering, and Pivot Tables. Explore list design, table formatting, data validation, and conditional formatting. Discover how to create and customize charts, use Sparklines, and implement data protection. Practice linking data, working with comments, and automating tasks. By the end of this 1 hour and 31 minute tutorial, gain the confidence to manipulate data, create insightful visualizations, and streamline your Excel workflow for increased productivity.

Excel 2019 Intermediate Tutorial

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