Analytics & AI for Modern Excel
Portfolio optimization is a classic finance problem: given a set of assets, what mix creates the lowest overall risk? In this post, we'll use Python in Excel to answer that question. We'll start …
Continue Reading about Python in Excel: How to build a minimum-risk portfolio →
When I started Stringfest Analytics, I assumed the hard part would be the work itself: building training that lands, keeping current with Excel and Python, and figuring out how to explain tools like …
Continue Reading about The Excel trainer’s guide to not signing something insane →
CAPM is one of those finance models that can sound more complicated than it really is. At the core, we are trying to answer a practical question: how closely does a stock move with the overall …
Continue Reading about Python in Excel: How to build the capital asset pricing model (CAPM) →
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 …
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 →
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 →
