How to create a dashboard using Excel's dynamic arrays
Excel Tips1 Mai 2024

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:

Search for them in your podcast platform.

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

Denne episoden er hentet fra en åpen RSS-feed og er ikke publisert av Podme. Den kan derfor inneholde annonser.

Episoder(48)

Why Excel macros still matter in 2026

Why Excel macros still matter in 2026

Excel macros are far from obsolete. And here's why.  This episode explores why VBAs (Visual Basic for Applications) still play an important role in workflow efficiency for accountants and finance pr...

1 Jun 9min

Template tips to boost workflows

Template tips to boost workflows

Most finance professionals have made this mistake at least once.  You open last month's file, update the numbers, hit save, and only then realise you should have saved it as this month's version of ...

1 Mai 7min

Increment dates easily in Excel

Increment dates easily in Excel

What if you could simplify Excel date calculations with one powerful custom function?  Well, this episode explains how.  You'll learn:  How to handle different date increments including days, ...

1 Apr 7min

Master your messy data

Master your messy data

Messy, unstructured data.  It slows reporting, creates errors, and tests everyone's patience. Right?  This episode breaks down how the new Regular Expressions (REGEX) work and how they help you fi...

2 Mar 6min

Build Better Excel Models

Build Better Excel Models

You may know The Seven Habits of Highly Effective People as a cornerstone of modern business thinking.  But what happens when those same principles from this book are applied to one of the most wide...

2 Feb 12min

Smarter, faster, easier: Here's what's new in Excel

Smarter, faster, easier: Here's what's new in Excel

Excel Tips Summer Season Encore presentation from October 2025 In this episode of Excel Tips, we explore the latest Excel updates that can help to boost productivity and simplify workflows for finance...

1 Jan 14min

Unlock 7 underused Excel features you still need today

Unlock 7 underused Excel features you still need today

Handy new Excel features are added regularly – but some "older" functions are still particularly useful to your workflows. Smart power users know these older functions and their value – which is why...

1 Des 202516min

How to simplify complex calculations with custom functions

How to simplify complex calculations with custom functions

Did you know that you can transform the way you can build models, reports and schedules with custom functions?  This episode guides you on how they make complex calculations cleaner and easier to ma...

3 Nov 20258min

Populært innen Business og økonomi

stopp-verden
lydartikler-fra-aftenposten
dine-penger-pengeradet
e24-podden
rss-penger-polser-og-politikk
rss-borsmorgen-okonominyhetene
pengepodden-2
rss-skravla-gar
rss-pa-konto
livet-pa-veien-med-jan-erik-larssen
pengesnakk
finansredaksjonen
utbytte
morgenkaffen-med-finansavisen
tid-er-penger-en-podcast-med-peter-warren
okonomiamatorene
stormkast-med-valebrokk-stordalen
rss-markedspuls-2
lederpodden
liberal-halvtime