In the “Mission Impossible” series, we focus on applying creative thinking to popular Excel techniques, taking widely recognized individual-use...

LinkedIn discussion (April 2024) Synopsys This challenge is about a spreadsheet-based Call Handling requirement that works perfectly well when a single operative is...

This article is inspired by Diarmuid Early’s recent announcement of a live two-hour webinar on writing powerful custom functions in Excel using LAMBDA. Diarmuid...

Is the USP of live teaching over the hundreds of thousands of free YouTube videos that obvious? Lately, I’ve been pondering the point of attending “live”...

Inspired by a recent conversation sparked by Alison Pollecot’s post about Excel reading from images, and a comment from Danielle, I reflected on the vast divide between...

This is not an article; it’s a challenge. A challenge for the Excel community to demonstrate and teach creative thinking using Excel. Nothing is being left out here—so...

Whenever the discussion of VBA comes up, particularly about its relevance or whether it’s becoming obsolete, I often encounter the same reaction: “VBA...

In recent discussions, one recurring theme is that VBA (Visual Basic for Applications) is obsolete. There are claims that it has been superseded by newer technologies...

In the world of data management, Excel and relational databases are often used together to handle a variety of business needs. Understanding the different perspectives...

This article follows up on my previous discussion about getting the most “bang for the buck” with Excel, contrasting simple solutions in Excel with the...