Not only can this bundle teach you to master Excel VBA, it actually gives you the full Microsoft Office suite for Windows along with it, and for a limited time, it’s only $79 (Reg. $609).

VBA has the same security clearance as Excel, while Office Scripts only has access to the workbook. VBA does not have a Power Automate connector, while Office Scripts can run through a Power Automate.

When you record a macro, Excel translates your actions into VBA code under the hood. So in addition to creating macros by recording them, you can also write them manually in VBA code.

TL;DR Key Takeaways : Macros in Excel 365 automate repetitive tasks, saving time and improving productivity by converting recorded actions into VBA code. Common tasks automated by macros include ...

Or, you can work with either of the downloadable Excel workbooks. If you’re entering the code yourself, please don’t copy it from this web page.

VBA has completely transformed the way I interact with Excel. It does require a learning curve, though, and at times you may even encounter errors while executing your custom functions.