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 bidirectional data flow...
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 suspects of so-called...
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 appears with such...
A well-meaning influencer, let’s call him Paul Barnhurst for convenience, posts: “With Python, Power Query, Lambdas, and Office Scripts, is VBA now obsolete?” Cue...
1. The Ubiquity and Appeal of Excel Excel is the most widely used digital business tool on the planet, with over a billion licenses reportedly in circulation. Its...
In a recent discussion about Excel and enterprise tools, a crucial idea crystallized: we urgently need a framework for evaluating real-world applicability of the various...
In an age of Office Scripts, Python integrations, and flashy Power Automate demos, it’s easy to believe the narrative that Excel VBA is outdated. But here’s the truth...
In the noisy world of social media, where tutorials are viral and “tips” are 60 seconds long, the story of Excel VBA has been hijacked. Most people today...
For over 30 years, Excel and VBA have powered some of the most widely used and adaptable business tools in the world. Yet, despite their longevity and proven value, the...
This discussion covers a multi-part explainer.