Completed
) Goals for video
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Data Analysis - PivotTables, Power Query, Formulas and Charts
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Intro
- 2 ) Files to use in class
- 3 ) Goals for video
- 4 ) Data Analysis Step #1: Get Data. Use Power Query to Get Data. Learn about important data analysis terms.
- 5 ) Data Analysis Step #2: Create Data Model. Use Worksheet formulas to create flat table for the Standard PivotTable tool. Learn about the new lookup function XLOOKUP.
- 6 ) Data Analysis Step #3: Create Calculations & Reports. Create first report: Year Month Sales Report with Product Slicer.
- 7 ) Grouping in a PivotTable.
- 8 ) Data Analysis Step #4: Create Visualizations: Line Chart to show sales trends.
- 9 ) Add Slicer to PivotTable.
- 10 ) Create remaining reports.
- 11 ) Show Values As Calculations in a PivotTable.
- 12 ) Limitations of Standard PivotTable: Grain of the Table.
- 13 ) Cross Tab Report.
- 14 ) Data Analysis Step #5: Get New Data and Refresh Reports & Visualizations
- 15 ) Conclusion
