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.
Overview
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.
Taught by
ExcelIsFun
Related Courses
-
Excel Basics - PivotTable Power - Amazing PivotTable Reporting Tricks - Slicers to Show Values As
-
PivotTables for Quick and Easy Reports - 34 Advanced Techniques
-
Excel for Accountants - Power Query & PivotTables to Import & Clean Data and Build Reports
-
Excel Basics - PivotTables & SUMIFS Function to Create Summary Reports
-
Excel Data Analysis - PivotTables, Power Query, Formulas and Charts
-
Excel Statistical Analysis - PivotTable & Power Query to Build Frequency Distributions
