By Hiran de Silva For decades, Excel has been viewed as “just a spreadsheet.” Yet in the right hands, it can behave like something far more powerful: a relational...
Hiran de Silva The setting: February 1997, Edexcel, London.Edexcel had just been formed from the merger of two major exam bodies. The accounting system was running on an...
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...