This is the fourth in the series and focuses on creating a dashboard using PivotCharts with Slicers.
PivotTables are extremely powerful and allow you to summarise large data sets very quickly without using any formulas. PivotCharts are charts that are based on PivotTables and are extremely interactive. This dashboard will use Slicers to add interactivity to the dashboard so that users can change the dashboard.
The session includes
- how a PivotTable works
- creating a PivotTable that works well with a chart
- formats for large values
- making PivotCharts display better for dashboards
- making changes to PivotTables to improve headings
- sorting and Top 10 reports
- use Slicers to control filters on multiple PivotTables
- using the GETPIVOTDATA function to create specify reports/charts
As always, I will share other tips and tricks along the way.
Level: Intermediate
Duration: 1 hour
Price: AU$25