How to install Python in Excel and use it for Finance and FP&A?

Microsoft has made it easier than ever to run Python code directly inside Excel, no installations, no add-ons, no external environments.

Whether you’re in Finance, FP&A, or Data Analysis, Python in Excel opens the door to powerful automation, advanced analytics, and seamless integration between code and spreadsheets.

Here’s a quick guide to get started, plus a few powerful use cases tailored for finance professionals.

Getting Started with Python in Excel

1. Open Excel (desktop version) and launch a blank workbook.
2. In any cell, type:
   =PY(

The moment you type the opening bracket, the formula bar turns green. That’s your signal: Python mode is now active.

3. You’re now writing Python code directly inside Excel.

No need to install Python, Jupyter, or set up a separate IDE.

Quick Demo: Build a Heatmap with Dummy Data

Let’s try a simple example using Python visualization tools.