Teaching analytics with modern Excel
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 →
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? →
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? →
