Archive - October 2024

In recent discussions on social media, there has been confusion regarding the term “cash flow statement,” with some posts and training courses...

In a recent article, we explored the concept of separating data from the analysis or processing that takes place after extracting data into another environment...

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