Every time I run a Copilot for Excel workshop, there’s one question that always comes up: “How can I make Copilot remember my prompts so it can do my weekly reports automatically?” Short …
How to understand the modern Excel AI stack
A client recently asked me to give a kind of “state of the union” talk on Excel and its growing AI stack. And honestly, it’s not wrong to call it messy. There are so many new pieces floating around. …
Continue Reading about How to understand the modern Excel AI stack →
How I became an Excel trainer… the Stringfest origin story
Whenever I get asked the same thing two or three times, I figure it's worth turning into a post. So I am genuinely surprised I haven't written about how I became an Excel trainer yet. I've written …
Continue Reading about How I became an Excel trainer… the Stringfest origin story →
Copilot in Excel: How to do named entity recognition with the COPILOT() function
Excel users often work with large amounts of unstructured text data, whether it's customer reviews, survey responses, business emails, or social media comments. Extracting structured insights from …
Copilot in Excel: How to do principal component analysis with Python
There’s more data than ever before, so wouldn’t it be nice if you could squeeze the meaning out of all your variables into just a few that really matter? That’s exactly what Principal Component …
Continue Reading about Copilot in Excel: How to do principal component analysis with Python →
Python in Excel: How to check for normality of returns
Analyzing the distribution of stock returns is a cornerstone of financial modeling, as many foundational financial theories, including Modern Portfolio Theory and the Black-Scholes model, assume that …
Continue Reading about Python in Excel: How to check for normality of returns →