100+ Ways to Use Python in Excel for FP&A and Financial Data Analysis

This is the most complete guide you'll find for free on Python in Excel for FP&A and Finance

Did you know that Excel now has Python built inside?

This means you can supercharge your data analysis and financial planning, automate complex tasks, and uncover insights faster than ever before!

I’m Christian Martinez, and in this video, I’ll show you 100+ ways to use Python in Excel for FP&A. 📊

We’ll start with the basics:
✅ What is Python?
✅ How does Python in Excel work?
✅ Why is this a game-changer for FP&A professionals?
✅ How to install and set it up in Excel

Then, we’ll dive deep into all the ways you can use Python in Excel for real-world FP&A tasks, including:
📌 Data Cleaning & Transformation
📌 Financial Modelling & Analysis
📌 Forecasting & Time Series Analysis
📌 Data Visualization & Advanced Charting
📌 Machine Learning for FP&A

By the end of this video, you’ll have a complete toolkit to elevate your FP&A game with Python in Excel!

⏳ Timestamps
⏩ 0:00 Start
⏩ 0:40 What is Python?
⏩ 2:30 How to Install Python in Excel
⏩ 5:50 Your First Python Code
⏩ 13:10 Data Cleaning
⏩ 16:45 Data Visualizations

📥 Download the FP&A Dataset & Python Code
👉 Get the exact Excel file I used in this video!
https://github.com/The-Financial-Fox/pythonforfinance2025


💬 Get Involved!
💬 Comment below: What FP&A task would you like to automate with Python in Excel?
👍 If you found this helpful, LIKE the video!
🔔 Subscribe for more Python + Finance tutorials!

📌 More FP&A & Excel Videos:
https://www.youtube.com/watch?v=igLLxALX-wc&t=4s

https://www.youtube.com/watch?v=rN49URY3Q_c&t=5s

https://www.youtube.com/watch?v=Y3QuKkpFfj0&t=10s