Let’s face it: the reality most Excel users experience today is centered around manual work. Whether it’s inputting formulas, using Power Query, dynamic arrays...

In this article, we will explore three related concepts: literal thinking, creative (lateral) thinking, and the consequential phenomenon known as the “Black Swan...

‘A podcast by Hiran de Silva, narrated by Charlie.’ After sharing some thoughts on creative thinking on LinkedIn, I was struck by the responses I received...

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...

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...