Excel Tips

Excel Tips

CPA Australia

Excel Tips is a podcast for accounting, business and finance professionals who are looking to sharpen their spreadsheet skills and learn new hacks and tricks from Neale Blackwood CPA, a Microsoft Excel expert. Excel Tips helps spreadsheet users discover Excel’s hidden features and shortcuts and understand how best to apply the newest features and functionality. The podcast is a companion to regular articles in INTHEBLACK, CPA Australia’s award-winning business magazine. Every podcast episode includes links to the accompanying Excel Tips digital magazine article. 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. Subscribe today to stay up-to-date with the latest episodes. Excel Tips is presented by CPA Australia, one of the world’s largest accounting bodies, with core services that include education, training, technical support and advocacy. CPA Australia publishes three podcasts: With Interest, INTHEBLACK and Excel Tips. To find out more about our podcasts, visit https://www.cpaaustralia.com.au/tools-and-resources/podcasts - or search for the shows in your podcast service. To contact the podcast team email us at podcasts@cpaaustralia.com.au.

Categories: Education

Listen to the last episode:

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:

Search for them in your podcast platform.

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

Previous episodes

  • 23 - How to create a dashboard using Excel’s dynamic arrays 
    Wed, 01 May 2024 - 0h
  • 22 - How to automate report building in Excel (part 2) 
    Tue, 02 Apr 2024 - 0h
  • 21 - How to automate report building in Excel 
    Thu, 29 Feb 2024 - 0h
  • 20 - Master the latest Excel changes: your ultimate guide 
    Thu, 01 Feb 2024 - 0h
  • 19 - How to master using different Excel techniques together 
    Thu, 04 Jan 2024 - 0h
Show more episodes

More Singaporean education podcasts

More international education podcasts

Choose the genre of podcast