By Hiran de Silva Most people use spreadsheets in the same simple way: to store data.You open a file, type in what you want to record, maybe add a...
Category - Uncategorized
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...
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...
By Hiran de Silva For as long as spreadsheets have existed, their most devoted users have dreamt of one thing: relational database capability inside...
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...
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...
By Hiran de Silva Podcast narrated Christopher T. Fennell recently made the provocative claim that “Power Query replaces Access.”Many professionals...
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...
By Hiran de Silva The current wave of social media commentary—whether voiced by Lily Cooper, Frank Custers, or Christopher T Fennell—captures a...
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...