Articles by George Mount

Python in Excel: How to visualize seasonality

July 9, 2025 | George Mount

Visualizing seasonality is a critical analytical skill in business because many essential metrics like sales, revenue, or demand often follow predictable seasonal patterns. Understanding these patterns helps businesses anticipate periods of peak activity, manage inventory, allocate resources effectively, and create accurate forecasts. Python in Excel makes seasonal analysis especially straightforward. ...
[...Read more...]

Python in Excel: How to work with Pandas MultiIndex

July 9, 2025 | George Mount

When working with complex datasets, especially panel data common in finance, managing multiple levels of indexing can quickly become overwhelming in traditional Excel. This is where Pandas’ MultiIndex feature shines. A MultiIndex in Pandas lets you efficiently handle data indexed across multiple dimensions, such as financial metrics tracked over time ...
[...Read more...]

Why Python is now essential for Excel teams

May 19, 2025 | George Mount

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 first steps should absolutely focus on core Excel competencies. But here’s the critical point: Not having ... [...Read more...]

Python in Excel: How to sample rows

May 5, 2025 | George Mount

Sampling rows from a table is common for analyzing subsets of large datasets, enabling quicker insights or testing without processing the entire dataset. In Excel, this is difficult because it lacks built-in random sampling functions, requiring complex formulas or manual steps that are time-consuming and error-prone for large tables. In ...
[...Read more...]

Python in Excel: How to simulate IRR with Copilot

March 31, 2025 | George Mount

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 flows equals zero. In finance, IRR helps investors compare the potential returns of different projects, ...
[...Read more...]

Python in Excel: How to create a dashboard with Copilot

March 20, 2025 | George Mount

Lately I’ve been digging into how Python in Excel’s AI-powered analysis might disrupt traditional static dashboards. It offers a flexible, lightweight way to explore data—letting you ask questions, adjust them as the data shifts, and uncover what’s worth focusing on. Traditional dashboards, with their fixed visuals, ... [...Read more...]
1 2 3 14