Analytics & AI for Modern Excel
Have you ever had a hunch about a dataset, perhaps convinced you were onto a meaningful pattern, only to later realize you were seeing something that wasn't there? You might not know it, but you've …
Continue Reading about How data analysts can overcome the illusion of control →
As Excel increasingly integrates powerful tools ranging from Power Query to Python, analysts often wonder: When should I use one over the other? Knowing the strengths and limitations of Python in …
Continue Reading about How to understand the difference between Power Query and Python in Excel →
When introducing newcomers to Python in Excel, I typically recommend that they have some basic Python knowledge beforehand. This helps reduce the mental effort required to grasp the Python in Excel …
Python’s integration into Excel has opened a new world of possibilities for data analysis and visualization, and Seaborn is one of the most exciting tools to leverage within this environment. Seaborn …
Continue Reading about Python in Excel: How to understand the Seaborn package →
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 →
