By Hiran de Silva Introduction: Beyond the Posts This article was inspired by numerous posts from Paul Barnhurst and other influencers in the FP&A space. While these...
Author - Hiran de Silva
Annual Budgeting – Requirements These are the requirements for the Annual Budgeting Benchmarking Survey. Distribute pre-populated budget templates to 400 operating...
Uncategorized
Explainer: Why Excel’s Hidden Architecture Matters More Than You Think — And How Power Query’s Detour Can Derail You
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...