Why Combine Python and Excel?

Why should you combine Python and Excel? In short, Python removes the limitations set by Excel’s built-in formulas. The same reasons why Python is one of the most popular languages for application developers apply to those working with Python in Excel. Working with Python in Excel brings Python’s advanced analytics libraries (pandas, NumPy), automation capabilities, data visualization tools (Matplotlib) and scalability to Excel.

Prerequisites and Setup

Installing Python and pip

1. Download the latest version of Python from