Summary
Excel Charts and Pivot Tables
This course provides advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: how to build more complex functions, use data analysis tools, make an impact with powerful chart features, and collaborate with other users.
Outline
-
Chapter 1: Tables
- Module A: Sorting
- Module B: Filtering tables
- Module C: Structured references
- Module D: Validation
- Module E: Transposing data
-
Chapter 2: Summarizing data
- Module A: Consolidation
- Module B: Subtotals
-
Chapter 3: PivotTables
- Module A: Creating and formatting PivotTables
- Module B: Manipulating PivotTables
- Module C: PivotCharts
-
Chapter 4: Advanced charts
- Module A: Special chart types
- Module B: Sparklines
- Module C: Quick Analysis