Главная
Study mode:
on
1
) Introduction
2
) What is a PivotTable? What is a Cross Tab Report.
3
) Build a Cross Tab Report with a PivotTable
4
) PivotTable Cached Data
5
) Building a Standard PivotTable as Part of Dashboard
6
) Standard PivotTable vs. Data PivotTable
7
) What is a Dashboard?
8
) Use Group By Feature to group Monthly and Yearly Amounts
9
) Summarize Values By to Change Aggregate Function
10
) Use Slicers to Filter Entire PivotTable
11
) Cell Phone Data Examples from Video to Build Frequency Distribution:
12
) Show Values As to Change to Specific Calculations
13
) CPA Data Examples from Video to Build CPA Pass Rate Report
14
) Practice Problems, Homework
15
) Summary
Description:
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.

PivotTables & Slicers - Create Dashboards & Summary Reports

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Business Intelligence #Data Science #Data Analysis #Data Visualization #Slicers #Mathematics #Statistics & Probability #Frequency Distribution #Spreadsheets #PivotTables
1 of 15

) Introduction