• How to create a dashboard using Excel’s dynamic arrays

  • May 1 2024
  • Length: 11 mins
  • Podcast

How to create a dashboard using Excel’s dynamic arrays

Listen for free

View show details

  • Summary

  • 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
    Show More Show Less
Show More Show Less
activate_Holiday_promo_in_buybox_DT_T2

What listeners say about How to create a dashboard using Excel’s dynamic arrays

Average customer ratings

Reviews - Please select the tabs below to change the source of reviews.

Audible.co.uk reviews

Amazon reviews
No Reviews are Available