Teaching analytics with modern Excel
Python's incorporation into Excel offers data analysts robust new tools, particularly in the realm of data visualization. This blog post introduces Matplotlib, a core Python library for crafting …
Continue Reading about Python in Excel: How to understand the Matplotlib package →
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? →
Data visualization is a fundamental aspect of effective data analysis. And although Excel is a versatile tool, certain visualization types remain difficult or even impossible to create with its …
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 my favorite applications of Python is time series analysis, particularly through the use of the Pandas package. This package was designed, in large part, to handle time series data in ways that …
Continue Reading about Python in Excel: How to create a running total →
As a Python enthusiast for a few years and an Excel aficionado for even longer, it's been exciting to see Python become officially supported in Excel. Yet, I still receive a lot of questions from …
Continue Reading about Python in Excel: How to make an open-high-low-close (OHLC) chart →
