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

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

When evaluating Excel challenges and techniques, one critical aspect often overlooked is scalability. In many cases, we shouldn’t be teaching or applying...

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 work being done with it...

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

Imagine a bustling, thriving marketplace where horse-drawn motor cars are the pinnacle of motoring excellence. Every conversation, every promotion, every sales pitch...

Eric Hartwig is an Excel expert, avid enthusiast, and philosopher. Eric Hartwig raises an important point about the responsibility of those with experience to support...

Two weeks ago, I posted an article on LinkedIn with a splash screen featuring a Flash illustration, extending the conversation about the spreadsheet mindset into...

Power Query Purpose: Power Query is primarily an ETL (Extract, Transform, Load) tool designed for data import, transformation, and cleaning. It is user-friendly...