In this article, I’m addressing a critical misconception about a common yet powerful Excel solution: the client-server, hub-and-spoke model, specifically for the reg...

The REG Call Handler Challenge has sparked responses that diverge from my intent. While feedback from Tony Wong and others has been invaluable, it highlights a...

In many organizations, the purpose of modeling and reporting is often cited as providing actionable results. But what exactly does that mean? An...

In this article, I want to address the bias prevalent in social media regarding certain topics and how this skews the knowledge base and conditioning of...

Introduction Recently, a poll conducted by Paul Barnhurst sparked a heated debate on LinkedIn about the meaning of “cash flow statement.” The discussion...

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