Excel Dashboards - Sparklines & Conditional Formats
September
10
2025
(Wednesday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 60 Minutes
58 Days Left To REGISTER
Duration: 60 Minutes
58 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Overview
This session requires the subscription version of Excel.
Sparkline charts are small charts that are specifically designed for dashboards.
We will add ticks and crosses using conditional formats to identify measures (good and bad) that may need review.
The Chart Data sheet structure has already been populated so we will review some of the formulas used in its creation.
Why you should Attend
Running out of space for your dashboards?
Need to include a lot of information on your dashboard?
Need to include icons on your dashboards?
Sparklines and conditional formats can offer a solution.
Areas Covered in the Session
- Reviewing report formulas
- MATCH function
- Dynamic arrays
- Handling high score is bad vs low score is bad in a formula
- Default settings you may need to change for Sparkline charts
- Controlling the display of ticks and crosses
- Formats for dashboards
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)