Category - Uncategorized

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

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

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

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

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

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

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

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

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

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