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 …
Python in Excel: How to create a dashboard with Copilot
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, …
Continue Reading about Python in Excel: How to create a dashboard with Copilot →
Python in Excel: How to make a process control chart with Copilot
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 …
Continue Reading about Python in Excel: How to make a process control chart with Copilot →
Python in Excel: How to create checkbox-driven visualizations
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 …
Continue Reading about Python in Excel: How to create checkbox-driven visualizations →
Python in Excel: How to create regular expressions with Copilot
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 …
Continue Reading about Python in Excel: How to create regular expressions with Copilot →
How to cross-check AI-generated insights in Excel
I’m a huge proponent of using AI-powered insights and automation in Excel. In fact, I think it’s the only way forward to keep Excel competitive, and in fact, Excel will get stronger from this …
Continue Reading about How to cross-check AI-generated insights in Excel →