Category - Uncategorized

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

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

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