Author - Hiran de Silva

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

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