Teaching analytics with modern Excel
One of my favorite applications of Python is time series analysis, particularly through the use of the Pandas package. This package was designed, in large part, to handle time series data in ways that …
Continue Reading about Python in Excel: How to create a running total →
Data visualization plays a crucial role in simplifying complex data, uncovering patterns, and effectively conveying findings to others. However, starting a new chart can be daunting. With a plethora …
Continue Reading about How to visualize data with Copilot in Excel →
As a Python enthusiast for a few years and an Excel aficionado for even longer, it's been exciting to see Python become officially supported in Excel. Yet, I still receive a lot of questions from …
Continue Reading about Python in Excel: How to make an open-high-low-close (OHLC) chart →
I'm not sure about your experience, but personally find Excel's charting features antiquated at times. They can be quite finicky to use, particularly when it comes to customization. Iterating between …
Continue Reading about How to resize Python plots in Excel →
In a previous post I explored some "quick wins" for wrangling and analyzing data in Python that would be otherwise difficult to do in Excel. That post largely avoided data visualization, so this post …
Continue Reading about Here are some quick wins for visualizing data with Python in Excel →
Data visualization is both an art and a science, and selecting the right chart can be overwhelming. My advice is to start by getting something on the page to break the logjam. You can always refine or …
Continue Reading about AI-Powered Excel: How to get the most of Recommended Charts →
