Excel 2019 Pivot Tables Tutorial

Excel 2019 Pivot Tables Tutorial

Learnit Training via YouTube Direct link

Adding Related Data Using VLOOKUP

3 of 22

3 of 22

Adding Related Data Using VLOOKUP

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel 2019 Pivot Tables Tutorial

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

  1. 1 Start
  2. 2 Data Mining
  3. 3 Adding Related Data Using VLOOKUP
  4. 4 Inserting Pivot Tables
  5. 5 Setting Up Pivot Tables
  6. 6 Building Pivot Tables
  7. 7 Filtering and Slicing Pivot Table Data
  8. 8 Changing Source Data and Refreshing Pivot Tables
  9. 9 Inserting Pivot Charts
  10. 10 Using Tables to Build Pivot Tables
  11. 11 Finding Correct Layouts for Reports
  12. 12 Setting Default Layouts for Reports
  13. 13 Using Pivot Table Styles
  14. 14 Subtotals and Grand Totals
  15. 15 Creating Report Pages
  16. 16 Adding the Power Pivot Tab to Excel
  17. 17 Creating Tables for the Data Model
  18. 18 Adding Relationships with Power Pivot
  19. 19 Using DAX Expressions with Power Pivot
  20. 20 Creating Pivot Tables with Power Pivot
  21. 21 When to Use Power Pivot
  22. 22 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.