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 widely used tools in finance: Excel?

In this episode, we explore how the seven habits framework can be applied by accountants and finance professionals to design and build Excel models.

The focus is practical and grounded in real work, with key learnings including:

  • How asking better questions leads to stronger Excel models

  • Why planning and prioritisation matter before building anything

  • Designing reports first and working back to the data

  • Building proactive features that reduce errors and improve usability

  • Using automation and AI thoughtfully to support the process

The episode also looks at where Excel fits alongside tools such as Power BI, and why judgement and planning still matter even as AI becomes more capable.

Listen now.

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

For more, check out the accompanying YouTube video of this episode.

Loving this content?

Would you like to listen to more Excel Tips and other CPA Australia podcasts like INTHEBLACK and With Interest? Head to CPA Australia's YouTube channel.

And don't forget to subscribe to the channel.

Read more of Neale's Excel articles on INTHEBLACK.

You can find a CPA at our custom portal on the CPA Australia website.

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

With Interest

INTHEBLACK

Excel Tips

INTHEBLACK Out Loud

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(50)

Create interactive Excel charts

Create interactive Excel charts

Wouldn't it be useful to learn how to build interactive Excel charts that respond automatically to user input using dynamic arrays?  This expert-led episode introduces the core techniques behind fle...

3 Aug 7min

How to create accounting reports with DAX

How to create accounting reports with DAX

From trial balances to profit and loss statements, reporting sits at the centre of modern finance.  This episode explores how finance professionals can use DAX (Data Analysis Expressions) formulas a...

1 Jul 9min

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

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

Populært innen Business og økonomi

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