Webinar – Dashboards #4 – PivotCharts and Slicers

Price: AU$25

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 with dynamic arrays to create specific reports/charts

As always, I will share other tips and tricks along the way.

Date: 26/03/2024
Time: 1:00 PM AEDST
Event: Dashboards #4 - PivotCharts and Slicers
Topic: Dashboards #4 - PivotCharts and Slicers
Public: Public
Registration: Click here to register.