How to create a dashboard using Excel’s dynamic arrays

Do you want to improve your dashboard-creating skills in Excel? Look no further.

This episode has all the expert tips you need to know using dynamic arrays to create a dashboard.

For fast access, use these timestamps:

1. About the report template and using dynamic arrays - 0:17
2. About dynamic arrays - 0:55
3. Dynamic charts and dashboards using dynamic arrays - 1:33
4. Variance charts and budget comparisons - 2:34
5. Building the tables and chats - 4:26
6. Additional resources 10:49

Tune in now. 

Host: Neale Blackwood CPA has more than 20 years of experience as a Microsoft Excel educator. He is the author of more than 200 INTHEBLACK articles as well as a book, Advanced Excel Reporting for Management Accountants.

You can listen to the first two in this dynamic arrays three-part series at the Excel Tips home page.

CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:

• INTHEBLACK
• INTHEBLACK Out Loud
• With Interest
• Excel Tips

Search for them in your podcast platform.

You can email the podcast team at podcasts@cpaaustralia.com.au