May 2026
Intermediate to advanced
418 pages
10h 7m
English
Overview
Professionals in nearly every industry use Excel to create powerful tools that can adapt quickly to fast-changing environments. But Excel's automation language, VBA, stopped evolving a long time ago. Python, on the other hand, has exploded in popularity, so Microsoft's official Python integration came as no surprise. This thoroughly revised hands-on guide helps you unlock Excel's full potential using Python.
Analysts, engineers, data scientists, and other power users will learn how to extend Excel's powerful analytics engine with Microsoft's Python in Excel feature. And with Excel's AI Copilot tool, even Python newbies can easily accomplish advanced tasks. Author Felix Zumstein—creator of the popular open source package xlwings—also dives into complementary solutions, including xlwings and OpenPyXL, that make the most of the combined capabilities of Excel and Python.
- Learn how to use Python's core features
- Get started with modern tools, including Jupyter notebooks and Visual Studio Code
- Apply powerful pandas commands to acquire, clean, and analyze data
- Use advanced analytics via pandas in Excel, using Python in Excel
- Manipulate Excel files with Python, using xlwings and OpenPyXL
- Automate Excel with Python, using xlwings and xlwings Lite
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.