Analytics & AI for Modern Excel
In a previous post we looked at building decision trees in Excel with the help of Copilot and Python, using IBM's employee attrition dataset: Decision trees are great for visualizing patterns and …
Continue Reading about Python in Excel: How to build random forest models 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 →
When it comes to predictive modeling, Excel can take you surprisingly far. You can even build models like logistic regression natively. But when it comes to evaluating and validating those models, …
Continue Reading about Python in Excel: How to validate machine learning models 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 …
As analysts, we constantly report on KPIs and metrics critical to our businesses. That's essential... but the numbers we present aren't always as black-and-white as they seem. Every metric comes with …
Continue Reading about Python in Excel: How to do statistical bootstrapping with Copilot →
