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, Python, and tools like Copilot, are we on the cusp of a paradigm shift in how data tasks are ...

In a previous post, we explored the plotnine package in Python in Excel, highlighting how its implementation of the Grammar of Graphics allows for an almost limitless array of possibilities in creating any plot imaginable: In this post, we’ll focus on how to craft layered (i.e., multiple elements ...

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, explore its core building blocks, and demonstrate some easy and impressive visualizations you can create—perfect for Excel users ...

In a previous post, we explored the Seaborn library and highlighted its fundamental plot types, showcasing how it simplifies the creation of visually appealing and insightful data visualizations directly in Excel using Python: In this post, we’ll take it a step further by diving into advanced, statistically driven 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 allowing users to select which measure to display—keeps the dashboard both compact and ...

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 offers. With Python, it’s simpler to adjust the chart when adding new variables or expanding ...

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 formatting points based on their category, we can reveal patterns, clusters, or outliers, making it easier to ...

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 within a pre-configured, pre-installed environment. For a detailed explanation of how this setup functions, you can refer to my previous blog post ...

Waffle charts are a great way to visualize data as a grid of squares where each square represents a portion of the whole. Unlike pie charts, which can be hard to interpret with many categories, waffle charts provide a cleaner, grid-based approach that makes it easy to compare parts of ...