Analytics & AI for Modern Excel
As a data analyst, spotting intriguing patterns and insights in data is a thrilling part of your role. But how do you determine whether those patterns actually mean something or are simply random …
Continue Reading about Python in Excel: How to do inferential statistics with Copilot →
Text transformation and analysis has never exactly been Excel’s strong suit. Sure, native text functions have significantly improved in recent years with new parsing and even regular expression …
Continue Reading about Python in Excel: How to transform text with Copilot →
As an Excel trainer, MVP, and tech enthusiast, I can tell you firsthand: a ton of VBA code is still out there. Enough that if you're coming into certain sectors (hello, finance!), you'll need to take …
Continue Reading about Copilot for Excel: How to work with VBA macros →
Something I frequently hear as an Excel and AI trainer is that "ChatGPT is better than Copilot in Excel." This frustrates me for a couple reasons. First, it's really an apples-to-oranges comparison. …
Continue Reading about How to get detailed Excel help with Copilot Notebooks →
As an Excel trainer and course creator who often covers more advanced topics, I get a lot of questions about these newer features, particularly Python in Excel and Copilot in Excel. "When should I use …
Continue Reading about How to understand Advanced Analysis with Python for Copilot in Excel →
Excel faces an interesting challenge with integrating artificial intelligence tools like Copilot. Ironically, Excel's exceptional user experience might be precisely why AI integration feels slow and …
Continue Reading about Is Excel’s user interface just too good for AI? →
