Skip to content
Global sound
Excel Tips

Excel Tips

Why Excel macros still matter in 2026

· 10 min

Show notes

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…

Website: 08fe4945-be1f-4a9d-a023-db879e2b8021.libsyn.com

Live, last hour: 10,513 songs on 5,407 stations in 145 countries

Discover the world through radio

More ways to discover (9)

Heard something good? Save it, or open it straight away in Spotify.

RustyradioContinue listening