Analytics & AI for Modern Excel
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 →
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 →
I'm an Excel trainer, consultant and MVP who regularly integrates Python into analytics workflows. And yes, I advise those clients that Python isn't the skillset Excel teams should start with. Your …
Continue Reading about Why Python is now essential for Excel teams →
The Internal Rate of Return (IRR) is a financial metric used to evaluate the profitability of an investment by calculating the discount rate at which the net present value (NPV) of a series of cash …
Continue Reading about Python in Excel: How to simulate IRR with Copilot →
I’m a huge proponent of using AI-powered insights and automation in Excel. In fact, I think it’s the only way forward to keep Excel competitive, and in fact, Excel will get stronger from this …
Continue Reading about How to cross-check AI-generated insights in Excel →
