Category - Uncategorized

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

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

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

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

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

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

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