Analytics & AI for Modern Excel
K-Nearest Neighbors (KNN) is a straightforward and powerful analytical tool that helps you make predictions by looking at the most similar cases or "neighbors" in your data. It's intuitive because it …
Continue Reading about Python in Excel: How to do k-nearest neighbors with Copilot →
Decision trees are intuitive analytical tools that help us explore and predict outcomes by asking simple, branching questions about our data. They're popular because they're visual, easy to interpret, …
Continue Reading about Python in Excel: How to build decision trees 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 →
K-means clustering is a machine learning technique that groups similar data points into meaningful clusters. For Excel users, it’s a simple but powerful way to uncover hidden patterns like customer …
Continue Reading about Copilot in Excel: How to do K-means clustering 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 →
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 →
