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 in Excel: How to understand the Seaborn package
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 →
How to create dynamic measures in Excel with Python in Excel
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 →
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 see all packages available in Python 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 →
Useful links for getting started with Python in Excel
Python integration with Excel has arrived! While I enjoy guiding newcomers, diving into the documentation can often provide the most comprehensive understanding. Below, I've compiled a list of key …
Continue Reading about Useful links for getting started with Python in Excel →