Analytics & AI for Modern Excel
In previous posts, I’ve discussed the Matplotlib package for plotting, particularly in the context of Python in Excel. In this post, I’ll demonstrate some quick wins for creating business-focused …
Continue Reading about Python in Excel: How to build your first Matplotlib plots →
One of the most exciting skills to learn in BI tools like Power BI or Tableau is how to create dynamic measures. The idea is that since dashboard space is limited, using dynamic controls—such as …
Continue Reading about How to create dynamic measures in Excel with Python in Excel →
Creating a dynamic dropdown list that expands or contracts with your source data is a fantastic way to enhance user experience in an Excel workbook! In this post, we'll explore how to set up a dynamic …
Continue Reading about How to create a dynamic dropdown list in Excel →
In an earlier post, I discussed adding conditional formatting to an Excel chart. One key benefit of using Python in Excel for this—rather than relying on standard Excel charting—is the flexibility it …
Continue Reading about How to create interactive scatterplots with Python in 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 →
Python in Excel significantly enhances the capabilities of Excel users, enabling more sophisticated data analysis and visualization. However, it's important to note that Python in Excel operates …
Continue Reading about How to see all packages available in Python in Excel →
