PivotTables & Slicers - Create Dashboards & Summary Reports

Learn advanced PivotTable techniques in Excel, including creating dashboards, summary reports, and using Slicers in this comprehensive 29-minute video tutorial. Master cross-tab reports, frequency distributions from text data, and CPA pass rate reports. Explore features such as Show Values As, Group By, and Summarize Values By to enhance data analysis skills. Download provided start and finished files to practice along, and refer to the included PDF notes for additional guidance.

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