PivotTables & Slicers - Create Dashboards & Summary Reports

This beginner course teaches Excel PivotTables for cross-tab reports, dashboards, frequency distributions, and percentage calculations. It covers grouping, aggregation changes, slicers, cached data, and Show Values As through practical examples and exercises.

Syllabus

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