In the world of data management, Excel and relational databases are often used together to handle a variety of business needs. Understanding the...
Category - Uncategorized
This article follows up on my previous discussion about getting the most “bang for the buck” with Excel, contrasting simple solutions in...
In this article, I will challenge the notion that certain Excel tasks—such as budgeting and consolidation—are “rocket science,” a claim...
In business and technology, the best solutions often offer the greatest benefit with the least effort—commonly known as “bang for the buck...
TL:DR Excel seamlessly leveraging a relational database does not make it a ‘Custom Application’, any more than Excel leveraging Power...
Recently, Paul Barnhurst conducted a poll about planning tools, asking whether Excel will remain a key tool for planning or if specialized planning...
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...
When evaluating Excel challenges and techniques, one critical aspect often overlooked is scalability. In many cases, we shouldn’t be teaching...
There’s an idea floating around that may seem radical or even outrageous to many Excel users: Excel is powerful enough to make much of the manual...
When we think about creative problem-solving in Excel, we often focus on the mechanics—the formulas, the functions, and the shortcuts that help us...