Analytics & AI for Modern Excel
In an earlier post I talked about the Python in Excel initialization environment: I likened it to the starting lineup of packages that load every time you open a workbook. It’s what gives you …
Continue Reading about Python in Excel: How to edit the initialization environment →
For decades, Excel training meant formulas, charts, and PivotTables. Now, learners open Excel and see a Copilot icon in the ribbon, a Python cell, or an automated workflow running in the background. …
K-means clustering is a machine learning technique that groups similar data points into meaningful clusters. For Excel users, it’s a simple but powerful way to uncover hidden patterns like customer …
Continue Reading about Copilot in Excel: How to do K-means clustering with Python →
As an Excel trainer, MVP, and tech enthusiast, I can tell you firsthand: a ton of VBA code is still out there. Enough that if you're coming into certain sectors (hello, finance!), you'll need to take …
Continue Reading about Copilot for Excel: How to work with VBA macros →
