Analytics & AI for Modern Excel
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 →
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 →
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? →
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 →
If you've ever encountered the challenge of sorting through data to find or manipulate specific text, you'll know the potential headaches it can cause. Excel's integration of regular expression …
Continue Reading about How to understand regular expressions in Excel →
Over on LinkedIn, Dennis Sawyers is always a lively and outspoken voice worth following. His latest post has sparked my interest, compelling me to share my own thoughts candidly. Dennis argues …
Continue Reading about Will Python, Copilot, and Excel make Power BI obsolete? →
