Excel Dashboards - Formula-Based
September
04
2025
(Thursday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 60 Minutes
52 Days Left To REGISTER
Duration: 60 Minutes
52 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
Overview
These dashboard techniques work in all Excel versions.
We will create summary reports from the data and from those summary reports we will extract the chart data which we will then base our charts on.
We will look at techniques to create small charts and how we can combine those on a dashboard.
Why you should Attend
Trying to get your dashboards to work? Discover the function, formulas and techniques that make creating a dashboard easier.
Areas Covered in the Session
- Formula basics
- Formulas that work with dates
- Automating headings
- SUMIFS function
- INDEX function
- Formats for dashboards
- Using chart templates
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)