Author - Hiran de Silva

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

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

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...

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

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...