Automation in Excel sounds technical but at its core, it’s simply about getting Excel to handle your repetitive tasks so you don’t have to. In this episode, Mike breaks down three approaches: Macros, VBA, and Office Scripts.
A macro can take a manual process and automate it quickly and without mistakes. Mike explains how the Macro Recorder lets you create one without writing a single line of code, where its limitations kick in, and when you’ll need to get hands-on with VBA.
He also covers Office Scripts – Microsoft’s more modern, cross-platform alternative, and gives an honest assessment of where it currently stands compared to VBA.
Rounding things off, Mike draws a clear line between Power Query and macros: Power Query owns data transformation, macros own everything else.
If there’s a task you do every week that never changes, this episode will convince you it’s worth automating.