Are you working as a temp, hired for basic Excel tasks–cleaning up messy spreadsheets, doing tedious, repetitive work no one wants to do? Imagine...
In this article, I’ll demonstrate how a single sheet in an Excel workbook can outshine even the most sophisticated ERP systems and cloud-based FP&A tools currently...
The idea of tripling your pay with Excel is not clickbait or snake oil; it’s a proven reality that you can verify yourself. If you’re one of the billion Excel...
When discussing the value of advanced Excel skills, it’s essential to ground the conversation in evidence: not just theory or popularity, but measurable, real-world...
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 inside each other like...
1. Introduction – Focal Squares to Spray Guns Welcome. Today, I’m going to show you something that will completely reframe how you see Excel—not as a local...
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...
Uncategorized
Revisiting the 2017 WSJ Excel Debate—The Power Query Illusion and Misunderstood Collaboration
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...
Uncategorized
Excel vs the $100 Billion Illusion: How the Enterprise Goldmine Has Been Hiding in Plain Sight
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...
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...