Analytics & AI for Modern Excel
Running live online Excel training for a big group — and I mean big (50, 75, 100+ people per instructor) — is a completely different beast from a normal-sized workshop. All the things that make …
Continue Reading about How to deliver live online Excel training for large audiences →
If you’ve used Copilot in Excel and noticed that some prompts work beautifully while others miss the point, the difference usually comes down to how you ask. Copilot responds to structure, not magic …
Continue Reading about How to understand prompt patterns for Copilot in Excel →
Exploratory data analysis often feels like wide-open territory. There’s no single formula or button that tells you the "right" way to cut through your data. And when Python enters the picture, the …
Continue Reading about Copilot in Excel: How to understand Think Deeper with Python →
People ask me all the time what to do if they don’t have paid Copilot or Power Automate or any of the other “new wave” Microsoft tools. Usually it comes from two groups: analysts who genuinely want to …
Continue Reading about How to get AI-ready even if you don’t have paid Copilot →
For years, running a logistic regression in Excel meant relying on add-ins like XLMiner or the Analysis Toolpak. They worked in a basic sense, but they were rigid and opaque, and they didn’t give …
Continue Reading about Python in Excel: How to do logistic regression with Copilot →
Excel users typically turn to Solver for optimization, but let's face it—Solver isn't exactly user-friendly, with its confusing menus, tricky constraints, and cryptic error messages. Luckily, there's …
Continue Reading about Python in Excel: How to build optimization models with Copilot →
