Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel 2019 Intermediate
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (0:59)
Overview of List Design (3:45)
Formatting Lists as Tables (1:58)
Filtering Records from Lists or Tables (3:34)
Removing Duplicates from Lists or Tables (3:21)
Flash Fill (3:09)
Single and Multi-Level Sorting (4:36)
Inserting Automatic Subtotals in Lists (6:08)
Inserting Data Charts Using Recommended Charts (4:52)
Formatting and Editing Chart Elements (4:30)
Creating and Applying Custom Chart Templates (3:39)
Adding and Removing Data from Charts (2:45)
Inserting Sparklines (5:28)
Printing Charts (1:04)
Inserting Pivot Tables (5:07)
Filtering Pivot Tables (4:54)
Using Report Layouts in Pivot Tables (3:06)
Refreshing and Changing Source Data in Pivot Tables (4:15)
Inserting Pivot Charts (1:57)
Data Validation (4:54)
Applying Built-In Conditional Formatting (3:13)
Creating Custom Conditional Formats (2:57)
Linking Data (4:18)
Comments (2:14)
Protection (3:45)
Removing Duplicates from Lists or Tables
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock