A lot of people look at today’s AI boom and worry: “Are my Excel skills still useful? Will AI take my job and my spreadsheets?” The truth is the opposite. There’s never been a better time to lean into …
The End of DAX and M? How AI and Python Are Transforming Excel
As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, …
Continue Reading about The End of DAX and M? How AI and Python Are Transforming Excel →
Python in Excel: Why use Python for data visualization?
Excel has for decades been a mainstay for business and data professionals, providing a familiar environment for organizing, analyzing, and visualizing data. Its built-in charts and graphs offer a …
Continue Reading about Python in Excel: Why use Python for data visualization? →
Python in Excel: How to understand the plotnine package
Python in Excel offers powerful tools for creating impactful visualizations, and one standout option is the plotnine package. In this post, we'll delve into the origins and philosophy of plotnine, …
Continue Reading about Python in Excel: How to understand the plotnine package →
How to create a dynamic dropdown list 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 →
How to conditionally format a scatterplot 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 →