Are you working as a temp, hired for basic Excel tasks–cleaning up messy spreadsheets, doing tedious, repetitive work no one wants to do? Imagine...
In this article, I’ll demonstrate how a single sheet in an Excel workbook can outshine even the most sophisticated ERP systems and cloud-based FP&A tools currently...
The idea of tripling your pay with Excel is not clickbait or snake oil; it’s a proven reality that you can verify yourself. If you’re one of the billion Excel...
When discussing the value of advanced Excel skills, it’s essential to ground the conversation in evidence: not just theory or popularity, but measurable, real-world...
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...
By Hiran de Silva It was Wednesday morning, and I’d spent most of Tuesday on a LinkedIn thread — the one which said, essentially, that Power Query replaces Access as a...