By Hiran de Silva As Microsoft Excel turns 40 this month, it’s remarkable how the world’s most widely used business tool still attracts an endless stream of white papers...
By Hiran de Silva Listen to the podcast discussion above. Today I came across a LinkedIn post by Mary Knoeferl, who describes herself as a data analytics educator and...
By Hiran de Silva Imagine this.You’ve done the work your boss asked for. You’ve built the spreadsheet. You’ve emailed it across. Task complete, right? That’s how most of...
A podcast by Hiran de Silva Imagine you’ve just found a useful article on the internet. Would you copy the entire web page into a Word document and email that document...
By Hiran de Silva People sometimes ask: “If the Digital Librarian is such a game-changer, why hasn’t anyone thought about it before?” The answer is: they have. For over...
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 formula, and keep it...
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...