Let’s consider a scenario where we have an employee of the week voting spreadsheet. We have a list of candidates and the corresponding votes, and the task is to...
Author - Hiran de Silva
In today’s digital age, the pursuit of social media influence is pervasive. The formula is well-known: post daily, track what resonates, and double down on the...
There’s a recurring theme that often comes up in discussions about VBA: people either demonize it or dismiss it outright. You’ll hear things like, “VBA is outdated,” or...
THIS IS A DRAFT. The LIBRARIAN EXPLAINER Series Part 2 In the previous section, we learned that data resides in a central repository—the “library.” The idea...
THIS IS A DRAFT. The LIBRARIAN EXPLAINER Series Part 1 When we work with Excel, we are working with data. However, many people who use Excel do not fully understand data...
Today, we begin a series on Creative Thinking with Excel. But before diving into techniques, let’s explore why creative thinking matters. What difference does it...
Have you ever stopped to consider the price of convenience? In our daily lives, we perform simple actions without giving them a second thought—walking, riding a bike...
By Hiran de Silva Some years ago, I stopped using the word automation when discussing improvements in processes—particularly in Excel. This may sound strange, but I have...
In a previous article, I discussed the remarkable capabilities of tools like ChatGPT, which can interpret complex inputs—whether it’s a prompt or, in my case, a 30...
Let’s talk about Power BI, one of the most popular tools in business intelligence today. It’s trending, in demand, and highly valuable. Power BI’s appeal is clear: its...