By Hiran de Silva In any large community, there is always an audience within the audience. Social media training for Excel is no exception. At the base of the pyramid...
By Hiran de Silva Some of the best questions in business are also the simplest. At WSP, my sponsor Tom Bower had a favourite expression: “Why can’t we just do this?”If...
By Hiran de Silva Recently, Mynda Treacy shared an excellent video that demonstrates how to bring a degree of database-style thinking into Excel. The response has been...
By Hiran de Silva When it comes to Excel education, there are two pyramids we need to talk about. One is widely shared and often celebrated. The other is rarely...
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...