By Hiran de Silva In this article, I want to show how the incorrect use of Excel—or more accurately, a lack of proper understanding of its capabilities—is costing...

By Hiran de Silva This is a follow up to the earlier article on ‘Excel Hell’. In our previous discussion, we explored the hidden dangers of running an...

By Hiran de Silva There’s a certain kind of performance art that takes place on late-night TV and LinkedIn feeds alike. You know the type: A slick-tongued grifter in a...

By Hiran de Silva There’s a strange and revealing contradiction making the rounds on LinkedIn, courtesy of a post by Alfio Auteri. His post praises Power Query in...

By Hiran de Silva In the last 10, 15—let’s just round it up to 20—years, something rather curious has been unfolding in the world of Excel. Microsoft, in its boundless...

By Hiran de Silva Podcast narrated by Charlie. Mark Proctor is a respected voice in the Excel community, and in one of his videos, he walks through a method of...

By Hiran de Silva Over the last two decades, a quiet transformation has reshaped Excel—and not necessarily for the better. Microsoft, once the champion of end-user...

By Hiran de Silva Jordan Goldmeier once asserted there’s nothing you can do in Access that you can’t do better in Excel. It’s a bold claim—and a category error. It’s...

By Hiran de Silva In 1997, I made a breakthrough. I was in the right place at the right time—armed only with Microsoft Excel, Access, and a determination to improve...

By Hiran de Silva In enterprise environments, Excel is ubiquitous. It’s the tool of choice for budgeting, reconciliation, forecasting, reporting, and analysis. Its...