Excel 2019 Intermediate Tutorial

Excel 2019 Intermediate Tutorial

Learnit Training via YouTube Direct link

Comments

24 of 25

24 of 25

Comments

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2019 Intermediate Tutorial

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

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