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 …
Python in Excel: How to do hierarchical clustering with Copilot
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 →
Copilot for Excel: How to do exploratory data analysis with Python
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 →
Python in Excel: How to do inferential statistics with Copilot
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 →
Python in Excel: How to transform text 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 →
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 →