Analytics & AI for Modern Excel
ARIMA (short for AutoRegressive Integrated Moving Average) is a classic statistical model for time series forecasting. It works by combining three elements: autoregression (using past values to …
Continue Reading about Copilot in Excel: How to build ARIMA forecasts with Python →
Feature engineering involves transforming raw data into meaningful variables to enhance machine learning models. It includes creating new features, encoding categorical data, and scaling or …
Continue Reading about Python in Excel: How to do feature engineering with Copilot →
Forecasting is a constant challenge for Excel users. Business data doesn’t just grow in straight lines... it shifts with trends, cycles, and noise. Exponential smoothing is a family of methods that …
Continue Reading about Copilot in Excel: How to build exponential smoothing forecasts with Python →
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 …
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 →
