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 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 →
Excel, Copilot and Python… the new trinity of data analysis?
Over the years, I've been a strong advocate for the integration of Python into the workflow of Excel users, followed by the incorporation of AI technologies. Microsoft has now directly integrated both …
Continue Reading about Excel, Copilot and Python… the new trinity of data analysis? →
Power Automate for Excel: How to view Microsoft Forms responses in Excel
As analysts, some of the more interesting, personal, and important data we might gather could come from surveys, and using Microsoft Forms is a great way to easily create and share those surveys. We …
Continue Reading about Power Automate for Excel: How to view Microsoft Forms responses in Excel →