Excel 365 (2019) Intermediate

Introduction

Excel 2019 Intermediate Tutorial

Download the exercise zip file

• 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 & Multi-Level 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 Built-In 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

Please ensure that you have the sound enabled on your Computer.

NOTE: Please disregard the video title as this is the Intermediate Course.