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

Avsnitt(45)

How to automate report building in Excel

How to automate report building in Excel

Are you an accountant or finance professional looking to enhance your daily workflows? Don't miss this episode, which delves into the exciting capabilities of dynamic arrays, empowering you to effort...

29 Feb 202411min

Master the latest Excel changes: your ultimate guide

Master the latest Excel changes: your ultimate guide

For accounting and finance professionals, it's vital that you keep up-to-date with changes to Microsoft Excel functionality. This episode explains what you need to know, including the latest changes ...

1 Feb 202415min

How to master using different Excel techniques together

How to master using different Excel techniques together

Do you want to improve your Excel skills in 2024? Start the new year on a positive note with these essential tips that can help you master a couple of Excel techniques together.  In this episode, we s...

4 Jan 202417min

Top Excel tips for your first 100 days in a new job

Top Excel tips for your first 100 days in a new job

Starting a new role in accounting and finance? We understand it can be stressful as you try to make a good first impression.  This Excel Tips episode is specially designed with your first 100 days in ...

1 Dec 202314min

How to create improved data visualisations in Excel

How to create improved data visualisations in Excel

If you're looking for ways to display diverse types of data using Excel's charts and visualisation tools, this podcast, loaded with tips, will show you how. The example in this episode compares one mo...

1 Nov 202314min

Master 10 new and revamped Excel features

Master 10 new and revamped Excel features

Do you want an Excel edge?  Whether you're a seasoned pro or starting out, master these 10 new and revamped features to help streamline your workflow and boost your spreadsheet efficiency.  For fast a...

3 Okt 202314min

Boost your skills with tips for Excel function updates

Boost your skills with tips for Excel function updates

Excel is constantly evolving and improving, and it's crucial to stay up to date with all the latest changes. This companion podcast is here to help you sort quickly through the most relevant function ...

1 Sep 202313min

Unlock 14 expert tips for Excel formulas

Unlock 14 expert tips for Excel formulas

Unleash your Excel skills by using the valuable functionality of formulas. Go straight to episode sections: The formula bar – 1:06 Starting formulas – 1:41 Using functions – 2:58 Function arguments –...

1 Aug 202323min

Populärt inom Business & ekonomi

framgangspodden
varvet
badfluence
rss-jossan-nina
rss-borsens-finest
avanzapodden
svd-tech-brief
rss-svart-marknad
uppgang-och-fall
fill-or-kill
rss-dagen-med-di
borsmorgon
kapitalet-en-podd-om-ekonomi
affarsvarlden
rss-kort-lang-analyspodden-fran-di
tabberaset
lastbilspodden
24fragor
bathina-en-podcast
borslunch-2