I've been treating Excel like a glorified calculator for most of my life. Sure, formulas made doing more complex calculations easier and automatically updated data, and there are free Excel templates ...

Back in December, I wrote about Microsoft’s decision to drop support for Visual Basic for Applications (VBA) from the next version of Office. I had, and still have, many concerns about the switch. The ...

Macros in Microsoft Office are blocked for security reasons, but you can enable and use signed macros. This tutorial explains how to create a self-signed digital certificate. By default, all Microsoft ...

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...

When you hear Excel automation, it’s easy to assume it refers only to those complex, or even basic, VBA scripts and macros that seem too intimidating to edit or reuse. However, with any real, ...