Hiran de Silva This explainer is inspired by an ongoing debate with Christopher T Fennell on LinkedIn, who portrays Power Query as a database to replace a relational...
By Hiran de Silva This is a demonstration of a topic that often comes up in discussions with Peter Bartholomew. It’s designed as an explainer for those unfamiliar with...
By Hiran de Silva The words legacy and obsolete carry an air of dismissal. Legacy suggests we tolerate something old until it can be replaced. Obsolete suggests it is...
By Hiran de Silva. Inspired by a LinkedIn post by George Mount. For more than a decade, social media has been flooded with “Excel tips,” “shiny new features,” and “best...
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...