PivotTables & Slicers - Create Dashboards & Summary Reports

PivotTables & Slicers - Create Dashboards & Summary Reports

ExcelIsFun via YouTube Direct link

) Build a Cross Tab Report with a PivotTable

3 of 15

3 of 15

) Build a Cross Tab Report with a PivotTable

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

PivotTables & Slicers - Create Dashboards & Summary Reports

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

  1. 1 ) Introduction
  2. 2 ) What is a PivotTable? What is a Cross Tab Report.
  3. 3 ) Build a Cross Tab Report with a PivotTable
  4. 4 ) PivotTable Cached Data
  5. 5 ) Building a Standard PivotTable as Part of Dashboard
  6. 6 ) Standard PivotTable vs. Data PivotTable
  7. 7 ) What is a Dashboard?
  8. 8 ) Use Group By Feature to group Monthly and Yearly Amounts
  9. 9 ) Summarize Values By to Change Aggregate Function
  10. 10 ) Use Slicers to Filter Entire PivotTable
  11. 11 ) Cell Phone Data Examples from Video to Build Frequency Distribution:
  12. 12 ) Show Values As to Change to Specific Calculations
  13. 13 ) CPA Data Examples from Video to Build CPA Pass Rate Report
  14. 14 ) Practice Problems, Homework
  15. 15 ) Summary

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.