Table of Contents

Part I

1. Selecting Various Charts and Graphs
2. Chart Elements, Styles, and Analysis
3. Custom Charts, Data Filtering, and Formatting
4. Animations, Sparklines, and Conditional Formatting

Part II

5. Speed Up with PivotTables
6. Preparing and Labeling PivotTable Source Data
7. Create, Calculate, and Format PivotTables
8. Sort, Filter, and Group PivotTables
9. PivotTables Calculations, Formulas, and Functions
10. PivotCharts
11. PivotTable Slicers and Timelines
12. PivotTable Dashboards
13. Charts and PivotTable Case Studies

Part III

14. Descriptive Statistics, Correlation, and Histograms
15. Goal Seek and Sensitivity Analysis