From Power Query to the Data Model, here are the five architectural gaps that keep me paying for Microsoft 365.

Apple's Numbers spreadsheet for Mac, iPhone, and iPad, is not as powerful as Microsoft Excel, but most users will be hard-pressed to find its limitations — and will immediately see how much easier ...

Artificial Intelligence (AI) tools are reshaping the landscape of software development, particularly in the realm of generating Visual Basic for Applications (VBA) code. These innovative solutions are ...

Right now, I'm working off one of Microsoft's infamous giant press releases. The company has a tendency to do brain dumps in press release form, so we both have to sift through the release to give you ...

Microsoft Excel is an indispensable spreadsheet tool used across many professions. Financial modelling, budgeting, data analysis and project management are just a few tasks where Excel often plays a ...

How to execute a VBA sub procedure in Microsoft Excel Your email has been sent Once you stick your toe into the VBA waters, you’ll realize how powerful and flexible VBA is. Not only is the language ...

Microsoft announced today that it resumed the rollout of VBA macro auto-blocking in downloaded Office documents after temporarily rolling it back earlier this month following user feedback. The change ...

Microsoft Excel remains the top spreadsheet application available today, with a long list of built-in data calculation and visualization tools. But other spreadsheet software aren’t far behind. Why ...

Ah, Excel. This little piece of software is the unicorn of spreadsheets, and that’s why so many people want to learn it. You’ll be hard-pressed to find an office that doesn’t use Excel for one purpose ...