This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.
- Work with business data using List Management (Tables)
- Create PivotTables
- Group items
- Filter data using Slicers
- Add formulas to the PivotTable using Calculated Fields
- Create PivotCharts
- Format PivotCharts.
Participants should be able to:
- Set up the data to be analysed using Tables
- Create PivotTables and PivotCharts
- Build formulas to better analyse the business data.