Teaching analytics with modern Excel
A scatterplot is a chart that displays the relationship between two variables by plotting data points along the X and Y axes, with each point representing a unique pair of values. By conditionally …
Continue Reading about How to conditionally format a scatterplot in Excel →
Advanced Analysis with Python in Copilot for Excel can help with many data analysis tasks that would typically be challenging to execute in Excel. From building predictive models using techniques like …
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 →
The availability of Python integration within Excel has made Python an accessible and valuable skill for many Excel users to consider adding to their toolkit. However, as an open-source programming …
Continue Reading about How to understand the initialization environment in Python for 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 →
