Articles by George Mount

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...]

How Excel users can evaluate and mitigate the risks of generative AI

May 19, 2025 | George Mount

In my Copilot workshops tailored specifically for Excel users, particularly those in finance and accounting, two recurring concerns stand out: the accuracy of AI-generated outputs and the potential exposure of sensitive data. These concerns, while important, are not entirely new. Similar risks have existed for years with traditional digital tools ... [...Read more...]

Python in Excel: How to create custom bins and frequency tables

May 12, 2025 | George Mount

If you’ve ever spent time manually grouping data into custom ranges or bins in Excel, you know it can get tedious fast. Whether it’s categorizing sales by price tiers, analyzing customer segments, or bucketing data for visualization, Excel often requires multiple nested formulas, helper columns, and PivotTables. Fortunately, ...

[...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...]

Here are some Excel features you should know to get the most of Python in Excel

March 21, 2025 | George Mount

When introducing newcomers to Python in Excel, I typically recommend that they have some basic Python knowledge beforehand. This helps reduce the mental effort required to grasp the Python in Excel environment. However, using Python within Excel also assumes a solid understanding of Excel itself. Like many technological advancements, embedding ...

[...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...]

Python in Excel: How to make a process control chart with Copilot

March 19, 2025 | George Mount

Many Excel users dismiss statistics as irrelevant, focusing solely on getting the numbers to add up and then moving on, rather than thinking in probabilities and uncertainties. Yet, these numbers often represent moments in time where they’re monitoring for significant changes to alert the business—precisely where statistics shines. ...

[...Read more...]

Python in Excel: How to create checkbox-driven visualizations

March 19, 2025 | George Mount

Integrating Python into Excel unlocks a wide range of data visualization options, though interactivity with Python-generated plots remains somewhat limited. In Excel, Python plots are essentially static images, lacking features like tooltips or the ability to explore series data. That said, with a bit of creativity, it’s possible to ...

[...Read more...]

Python in Excel: How to create regular expressions with Copilot

March 18, 2025 | George Mount

After years of being unable to work with regular expressions, Excel has finally introduced a set of convenient and useful functions for doing so: However, around the same time, regular expressions also became accessible in Excel as a result of its integration with Python: The addition of regex support in ...

[...Read more...]

1 2 3 … 14 »

Python-bloggers

Data science news and tutorials - contributed by Python bloggers

Articles by George Mount

Why Python is now essential for Excel teams

How Excel users can evaluate and mitigate the risks of generative AI

Python in Excel: How to create custom bins and frequency tables

Python in Excel: How to sample rows

Python in Excel: How to simulate IRR with Copilot

Here are some Excel features you should know to get the most of Python in Excel

Python in Excel: How to create a dashboard with Copilot

Python in Excel: How to make a process control chart with Copilot

Python in Excel: How to create checkbox-driven visualizations

Python in Excel: How to create regular expressions with Copilot