Excel Data Analysis - PivotTables, Power Query, Formulas and Charts

This introductory course demonstrates a complete Excel sales-analysis workflow: importing text data with Power Query, building a flat table with worksheet formulas, creating PivotTable reports and charts, and refreshing them with new data.

Syllabus

) Intro.
) Files to use in class.
) Goals for video.
) Data Analysis Step #1: Get Data. Use Power Query to Get Data. Learn about important data analysis terms..
) 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..
) Data Analysis Step #3: Create Calculations & Reports. Create first report: Year Month Sales Report with Product Slicer..
) Grouping in a PivotTable..
) Data Analysis Step #4: Create Visualizations: Line Chart to show sales trends..
) Add Slicer to PivotTable..
) Create remaining reports..
) Show Values As Calculations in a PivotTable..
) Limitations of Standard PivotTable: Grain of the Table..
) Cross Tab Report..
) Data Analysis Step #5: Get New Data and Refresh Reports & Visualizations.
) Conclusion.