Excel 302: PivotTable and PivotCharts
In this live training event, we will start by examining a PivotTable and how to navigate them. Next, we will create several different PivotTables, including one that groups dates by months. We will also touch on some troubleshooting skills that will help make sure the data represented in your report is complete and accurate. Looking to display your data a little more visually? PivotCharts are interactive charts that display a visual view of your data.
Recommended Duration: 45-minutes + Q & A
Core Objectives
- Examine and navigate a PivotTable
- Use the PivotTable field list to modify a PivotTable
- Create a PivotTable from a data source
- Modify to change the PivotTable layout
- Refresh data using the refresh data button
- Modify PivotTable formulas
- Group data based on specific range criteria
- Show data for each page item on a new sheet in your workbook
- Create a PivotChart
- Create a dashboard using Excel Slicers
