Excel 2019 Advanced Tutorial

Excel 2019 Advanced Tutorial

Learnit Training via YouTube Direct link

Introduction

2 of 26

2 of 26

Introduction

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2019 Advanced Tutorial

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Start
  2. 2 Introduction
  3. 3 Overview of List Design
  4. 4 Formatting Lists as Tables
  5. 5 Filtering Records from Lists or Tables
  6. 6 Removing Duplicates from Lists or Tables
  7. 7 Flash Fill
  8. 8 Single & Multi-Level Sorting
  9. 9 Inserting Automatic Subtotals in Lists
  10. 10 Inserting Data Charts Using Recommended Charts
  11. 11 Formatting & Editing Chart Elements
  12. 12 Creating & Applying Custom Chart Templates
  13. 13 Adding & Removing Data from Charts
  14. 14 Inserting Sparklines
  15. 15 Printing Charts
  16. 16 Inserting Pivot Tables
  17. 17 Filtering Pivot Tables
  18. 18 Using Report Layouts in Pivot Tables
  19. 19 Refreshing & Changing Source Data in Pivot Tables
  20. 20 Inserting Pivot Charts
  21. 21 Data Validation
  22. 22 Applying Built-In Conditional Formatting
  23. 23 Creating Custom Conditional Formats
  24. 24 Linking Data
  25. 25 Comments
  26. 26 Protection

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.