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 →
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 →
Python in Excel: How to create PivotTables with Copilot
PivotTables in Excel are a fast, user-friendly way to summarize data and gain quick insights. However, they’re not formula-driven, which can limit control and flexibility compared to dynamic options …
Continue Reading about Python in Excel: How to create PivotTables with Copilot →