Completed
) 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.
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
