January 2026
Beginner to intermediate
272 pages
6h 31m
English
Content preview from Python in Excel Step-by-Step
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,
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.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.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.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.
INTRODUCTION
At the time of this writing, I’ve been in the technology field for 28 years and have been doing analytics for the last 14. Over my career, I’ve seen many hype cycles come and go (e.g., “Big Data”). I mention this only to emphasize how profoundly I was impacted by what I saw in May of 2023 – an early version of Python in Excel.
As an analytics consultant and educator, I was blown away by Microsoft’s vision for Excel. There was only one reason why Microsoft would spend so much time and effort into building Python in Excel: Microsoft sees Excel becoming the world’s most used do-it-yourself (DIY) data science platform.
Doing data science with Excel is not new. Using Solver, you can implement advanced analytics like market basket analysis, logistic regression, simulations, and so on.
However, using Excel in this way often requires setting up complex worksheet templates that are error prone. If this wasn’t a big enough hurdle, many of the most powerful analytics techniques (e.g., cluster analysis) cannot be implemented using Solver.
Enter Python in Excel.
As you will learn in this book, Python is not only foundational for Microsoft’s vision of Excel as a data science platform, but knowledge of Python is also required to make the most of Microsoft’s Copilot artificial intelligence (AI) technology.
Microsoft Excel has always been, first and foremost, a tool for analyzing data. For professionals wanting to have more impact at work using data, Python is the jewel in Excel’s ...
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.