Teaching analytics with modern 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 →
In previous posts, we explored building interactive visualizations in Excel, including interactive window functions like moving averages and dynamic measures: In this post, we're going to merge …
Continue Reading about Python in Excel: How to create custom date ranges and metrics →
Python's incorporation into Excel offers data analysts robust new tools, particularly in the realm of data visualization. This blog post introduces Matplotlib, a core Python library for crafting …
Continue Reading about Python in Excel: How to understand the Matplotlib package →
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? →
As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, …
Continue Reading about The End of DAX and M? How AI and Python Are Transforming Excel →
Excel has for decades been a mainstay for business and data professionals, providing a familiar environment for organizing, analyzing, and visualizing data. Its built-in charts and graphs offer a …
Continue Reading about Python in Excel: Why use Python for data visualization? →
