Excel 306: Power User - Advanced Reporting Using PivotTables
If you are already familiar with PivotTable basics, this session will take you to the next level. We’ll explore how to define, analyze, format, and display the results of your Excel reporting with interactive Slicers, Timelines, and PivotCharts. You’ll learn new ways to analyze raw data and create a custom, dynamic dashboard on its own worksheet. Growing your PivotTable and analysis skills will help you focus on the interesting Key Performance Indicators (KPIs) of your project!
Recommended Duration: 45-minutes + Q & A
Core Objectives
- Build PivotTables and PivotCharts
- Organize your data
- Modify the PivotTable field list
- Explore the Analyze Data button
- Advanced formatting tips
- Conditional Formating
- Add Slicers to a PivotTable
- Add a Timeline to a PivotTable
- Add and Modify a PivotChart
