Skip to Content
Python in Excel: Unlocking powerful data analysis and automation solutions
book

Python in Excel: Unlocking powerful data analysis and automation solutions

by Liam Bastick, Kathryn Newitt
December 2025
Intermediate to advanced
369 pages
9h 31m
English
Microsoft Press
Content preview from Python in Excel: Unlocking powerful data analysis and automation solutions

Chapter 1

Introduction to Python and Python in Excel

In this chapter, you will:

  • Learn how and why Python was created

  • Explore how Excel assists with data analysis

  • Discover how Python came to be used for Excel data analysis

This book is designed to enable you to use Python in Excel to efficiently transform data into information that will help your business make wise decisions. To understand how Python in Excel can help with data interpretation, you first need to understand what Python is and what features make it so popular.

History and key features of Python

In the 1980s, Guido van Rossum created the language that would eventually be known as Python. It was a side project Guido took on when he realized that a new coding language could speed ...

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

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’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.
Head of Cybersecurity
QuotationMarkI 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.
Field Engineer
QuotationMarkI’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.
Data Platform Tech Lead
QuotationMarkI'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.
Mark W.
Embedded Software Engineer

You might also like

Python in Excel Step-by-Step

Python in Excel Step-by-Step

David Langer
Python for Excel

Python for Excel

Felix Zumstein

Publisher Resources

ISBN: 9780135438053