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 being left out here—so...
Archive - October 2024
Whenever the discussion of VBA comes up, particularly about its relevance or whether it’s becoming obsolete, I often encounter the same reaction: “VBA...
In recent discussions, one recurring theme is that VBA (Visual Basic for Applications) is obsolete. There are claims that it has been superseded by newer technologies...
In the world of data management, Excel and relational databases are often used together to handle a variety of business needs. Understanding the different perspectives...
This article follows up on my previous discussion about getting the most “bang for the buck” with Excel, contrasting simple solutions in Excel with the...
In this article, I will challenge the notion that certain Excel tasks—such as budgeting and consolidation—are “rocket science,” a claim often made by experts...
In business and technology, the best solutions often offer the greatest benefit with the least effort—commonly known as “bang for the buck.” As Nigella...
TL:DR Excel seamlessly leveraging a relational database does not make it a ‘Custom Application’, any more than Excel leveraging Power Query. Both are...
Recently, Paul Barnhurst conducted a poll about planning tools, asking whether Excel will remain a key tool for planning or if specialized planning tools will dominate...
Uncategorized
“Hello World” Budgeting, Reporting, and Forecasting Model with Excel and a Relational Database
This is a draft track for a comprehensive high-level demonstration and explainer currently in production. The model is on a small limited scale to reduce to the basic...