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.
Instructor
Neale Blackwood