Excel 2019 Advanced Tutorial
For ad free training and certificates please join Learnit Anytime:
https://www.learnitanytime.com
Enroll in our live, instructorled Excel classes:
https://bit.ly/3r9ZXo1
For Private Group Trainings please visit:
https://www.learnit.com/privategroup...
Join our online community! https://www.offsitebylearnit.com
Exercise Files: https://bit.ly/36ZPKzO
Start 0:00
Introduction 0:03
Overview of List Design 1:02
Formatting Lists as Tables 4:47
Filtering Records from Lists or Tables 6:45
Removing Duplicates from Lists or Tables 10:19
Flash Fill 13:40
Single & MultiLevel Sorting 16:50
Inserting Automatic Subtotals in Lists 21:27
Inserting Data Charts Using Recommended Charts 27:36
Formatting & Editing Chart Elements 32:28
Creating & Applying Custom Chart Templates 36:58
Adding & Removing Data from Charts 40:38
Inserting Sparklines 43:23
Printing Charts 48:52
Inserting Pivot Tables 49:57
Filtering Pivot Tables 55:04
Using Report Layouts in Pivot Tables 59:58
Refreshing & Changing Source Data in Pivot Tables 1:03:05
Inserting Pivot Charts 1:07:21
Data Validation 1:09:18
Applying BuiltIn Conditional Formatting 1:14:12
Creating Custom Conditional Formats 1:17:26
Linking Data 1:20:23
Comments 1:24:41
Protection 1:26:56
#Excel