Excel Pivot Tables Tutorial - From Basics to Advanced Techniques

Excel Pivot Tables Tutorial - From Basics to Advanced Techniques

Learnit Training via YouTube Direct link

What are Pivot Tables?

3 of 27

3 of 27

What are Pivot Tables?

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Pivot Tables Tutorial - From Basics to Advanced Techniques

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

  1. 1 Start
  2. 2 Introduction
  3. 3 What are Pivot Tables?
  4. 4 Preparing Data for Analysis
  5. 5 Pivot Table Components
  6. 6 Building Pivot Tables to Show Different Values
  7. 7 Adding Fields to Pivot Tables
  8. 8 Using Built-In Filters
  9. 9 Filtering Data with Slicers
  10. 10 Displaying New Values from Data Sources
  11. 11 Inserting Pivot Charts
  12. 12 XLOOKUP
  13. 13 Joining Data Sets with XLOOKUP
  14. 14 Introduction to Advanced Pivot Tables
  15. 15 Inserting Pivot Tables from Tables
  16. 16 Calculated Fields
  17. 17 Using the Timeline Tool
  18. 18 Report Filter Pages
  19. 19 Pivot Table Layouts
  20. 20 Creating Pivot Table Designs
  21. 21 Adding Power Pivot Tabs to the Ribbon
  22. 22 Adding Tables to Power Pivot Data Model
  23. 23 Creating Table Relationships
  24. 24 Creating Columns with DAX Expressions
  25. 25 Displaying New Source Data in Power Pivot Tables
  26. 26 Data Mining with Flash Fill
  27. 27 Conclusion

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.