Excel Dashboards - PivotCharts and Slicers
September
11
2025
(Thursday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 60 Minutes
59 Days Left To REGISTER
Duration: 60 Minutes
59 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Overview
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 are extremely interactive. This dashboard will use Slicers to add interactivity to the dashboard so that users can change the dashboard.
Why you should Attend
Need an easy-to-use interactive dashboard? PivotCharts and Slicers offer an intuitive filtering experience for users.
Areas Covered in the Session
- 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
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Access Recorded Version
One Attendee / Group Attendees
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)