Author - Hiran de Silva

This post refers to the LinkedIn post PART 1 here, and PART 2 here. In today’s data-driven world, Excel remains one of the most widely used tools for business...

Beyond the Combine Button: Realities of Enterprise-Scale Budget Consolidation in Excel Thank you to everyone who took part in the Power Query consolidation challenge...

This isn’t your typical Excel challenge. Here’s an Excel test set at your job interview. The interviewer smiles as you settle in. “We believe spreadsheets are the...

In any industry-shaking transformation, there are bound to be detractors. My Excel enterprise methodology—a model that uses client-server architecture with relational...

In the world of Excel, almost everyone thinks they know what clever looks like. Ask around and you’ll hear familiar responses: Power Query, pivot tables, dynamic arrays...

ChatGPT is either mad, or drunk. I asked it for a basic benchmark for consolidating 382 Budgets at 4 group and sub-group levels. It said to expect an average duration of...

[VIDEO SCRIPT]Type: Pre-Learning Intro to Live “Excel Happening” [Opening: Presenter On Camera or Animated Character] Presenter (smiling):Welcome.This is a short...

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

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