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 for Excel: How to work with VBA macros
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 →
How to get detailed Excel help with Copilot Notebooks
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 →
How to understand Advanced Analysis with Python for Copilot in Excel
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 →
How to write effective prompts for Copilot in Excel
Prompting is becoming an essential skill for analysts working with generative AI tools like Microsoft Copilot. But prompt writing in Excel isn’t quite like chatting with ChatGPT. Excel’s strengths are …
Continue Reading about How to write effective prompts for Copilot in Excel →
Is Excel’s user interface just too good for AI?
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? →