A Lecture by Hiran de Silva [Opening]Most people already know 99% of what I’m about to show you. Power Query, dynamic arrays, pivot tables, even a bit of VBA—that’s the...
By Hiran de Silva How old do you have to be to drive a car?Most people will instinctively answer with the legal driving age. But the truth is, you can drive at any...
By Hiran de Silva For as long as spreadsheets have existed, their most devoted users have dreamt of one thing: relational database capability inside the spreadsheet. The...
By Hiran de Silva On social media, it is often claimed that Excel and Access are rivals. A recent LinkedIn post even argued that Excel with Power Query can replace a...
By Hiran de Silva It was Wednesday morning, and I’d spent most of Tuesday on a LinkedIn thread — the one which said, essentially, that Power Query replaces Access as a...
By Hiran de Silva Podcast narrated Christopher T. Fennell recently made the provocative claim that “Power Query replaces Access.”Many professionals, including myself...
Uncategorized
When Miseducation Masquerades as Expertise— A Response to “Power Query Replaces Access”
By Hiran de Silva Christopher T. Fennell recently claimed that “Power Query replaces Access.”This isn’t just wrong — it’s a textbook case of how social media...
By Hiran de Silva The current wave of social media commentary—whether voiced by Lily Cooper, Frank Custers, or Christopher T Fennell—captures a widespread but deeply...
By Hiran de Silva We’ve all seen the slogan: “Your value with Excel depends on how well you know Excel.”It’s plastered across courses, feature launches, and training...
By Hiran de Silva Imagine two neighbouring countries. In one, people love apples. In the other, people love oranges. Farmers in each country grow what their people want...