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 professionals.

Key learnings:

• Why macros still matter in modern Excel workflows

• How VBA compares with Power Query

• The limits of Power Query for in-situ data fixes

• How AI can help write and debug VBA code

• How to automate data cleansing tasks in Excel

• Why VBA is a useful entry point into programming

• How to store macros in the personal macro workbook

• Ways to run macros from the quick access toolbar

Listen now to help level up your Excel skills with macros.

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.

Read more of Neale's Excel articles on INTHEBLACK.

Loving this content?

Don't forget to subscribe to EXCEL TIPS and share this episode with your colleagues and friends in the business community.

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.

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 [email protected]