Is VBA “dead”? Is VBA less powerful than Python, JavaScript, or another programming language? These discussions often fall into a strange trap, comparing VBA...

In this piece, I want to clarify a topic that might cause some confusion: Excel macros. You may have often heard me say that there are “macros” and then...

Since the introduction of Visual Basic for Applications (VBA) in Excel, we’ve had the capability to work with arrays–structures that allow multiple values as...

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