Category - Uncategorized

For years, there’s been a persistent claim echoing across social media and corporate boardrooms alike: “Most companies have disabled VBA.” Or more...

It’s official. “Excel Hell” exists. We’ve all heard the whispers in the cubicles. Maybe you’ve even seen it firsthand: 73 linked files, all nested...

1. Introduction – Focal Squares to Spray Guns Welcome. Today, I’m going to show you something that will completely reframe how you see...

There’s a peculiar kind of dogma that persists in the modern business software world — a belief that Excel, though useful, is inherently limited...

In November 2017, The Wall Street Journal published a thought-provoking piece that triggered a wave of responses from the Excel community. Among the...

By Hiran de Silva Introduction: Beyond the Posts This article was inspired by numerous posts from Paul Barnhurst and other influencers in the...

Annual Budgeting – Requirements These are the requirements for the Annual Budgeting Benchmarking Survey. Distribute pre-populated budget...

This explainer is for Excel professionals who are familiar with Power Query and Power Pivot, but who may not be aware of Excel’s native...

By Hiran de Silva Chris Argent’s latest post, in conversation with Giles Male and Mike Rose, touches on Excel’s LAMBDA functions and the usual...

By Hiran de Silva In the strange and swirling carnival that is LinkedIn, one recurring act continues to draw a crowd: “Is VBA dead?” The question...