Analytics & AI for Modern Excel
Hierarchical clustering is a technique that groups similar data points into clusters based on their attributes, forming a hierarchy or tree-like structure. Imagine organizing customers based on their …
Continue Reading about Python in Excel: How to do hierarchical clustering with Copilot →
Exploratory data analysis (EDA) is the process of analyzing data to uncover trends, anomalies, and relationships without preconceived assumptions. It typically involves summarizing data with …
Continue Reading about Copilot for Excel: How to do exploratory data analysis with Python →
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 →
