Teaching analytics with modern Excel
Among all of the amazing enhancements in Excel, one that really resonates with the core of Excel is dynamic arrays. Spreadsheets became popular primarily because of their tactile ability to visually …
Continue Reading about How to create interactive visualizations in Excel using dynamic arrays →
Download this post as a PDF: One of the greatest wins for Excel users learning Python is access to a comprehensive suite of data visualization tools. However, compared to Excel, the default plots …
Continue Reading about Python in Excel: How to create interactive visualizations →
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 →
