One of the biggest advantages of Python in Excel is that it brings more advanced analytical tools directly into the workbook environment where so much business data already lives. Time series analysis …
Python in Excel: How to do K-means clustering
Have you ever wanted to group customers into meaningful segments based on their behavior, without manually sorting through rows of data? That is exactly what k-means clustering helps you do. In a …
Continue Reading about Python in Excel: How to do K-means clustering →
Python in Excel: How to forecast time series data with ARIMA
In a previous post, we looked at how Copilot in Excel can help us build an ARIMA forecast with Python. That approach has some real advantages: Copilot can help generate code, explain unfamiliar …
Continue Reading about Python in Excel: How to forecast time series data with ARIMA →
Python in Excel: How to do principal component analysis
In a previous post, I showed you how to use Copilot in Excel to perform principal component analysis, or PCA. This time, we're going to strip things down, dial the AI back a bit, and work through the …
Continue Reading about Python in Excel: How to do principal component analysis →
How to scale Excel tasks with Claude Skills and Cowork
Most of us have at least one task we redo every few weeks that's just structured enough to feel like it should be automated, but just messy enough that a simple script won't cut it. For me, it was …
Continue Reading about How to scale Excel tasks with Claude Skills and Cowork →
How to learn Python in Excel the right way (book review)
A few days ago, I wrote about how to teach Python in Excel in a way that actually sticks: The core idea was simple: you have to respect how Excel users already think. When Excel users reach …
Continue Reading about How to learn Python in Excel the right way (book review) →