Python in Excel: Unlocking powerful data analysis and automation solutions
- By Liam Bastick, Kathryn Newitt
- Published Dec 31, 2025 by Microsoft Press.
Best Value Purchase
Book + eBook Bundle
- Your Price: $59.39
- List Price: $98.98
- Includes EPUB and PDF
- About eBook Formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB
The open industry format known for its reflowable content and usability on supported mobile devices.
PDF
The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
More Purchase Options
eBook
- Your Price: $35.19
- List Price: $43.99
- Estimated Release: Dec 31, 2025
- Includes EPUB and PDF
- About eBook Formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB
The open industry format known for its reflowable content and usability on supported mobile devices.
PDF
The popular standard, used most often with the free Acrobat® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Description
- Copyright 2026
- Edition: 1st
- Book
- ISBN-10: 0-13-543797-0
- ISBN-13: 978-0-13-543797-1
Seasoned Experts Liam Bastick and Kathryn Newitt unveil a groundbreaking guide to mastering data analysis and automation with Python in Excel
Python in Excel: Unlocking powerful data analysis and automation solutions is a hands-on, practical guide that leverages the authors decades of expertise to teach readers how to harness the newly integrated Python capabilities within Microsoft Excel, mapping familiar Excel concepts to Python foundations. Covering essential topics such as Python syntax, data structures, data analysis with pandas, visualization, and the use of AI tools like Copilot, the book empowers professionals to elevate their data analysis and automation skills. Readers will gain the ability to perform advanced forecasting, build predictive models, and streamline workflows, making them more efficient and competitive in todays data-driven workplace.
By reading this book, you will:
- Understand the fundamentals of Python programming directly within Excel
- Map your existing Excel skills to Python concepts for easier learning
- Automate repetitive tasks and workflows Analyze and visualize data with powerful
- Python libraries like pandas Build advanced forecasting and predictive models without leaving Excel
- Explore and manipulate data efficiently using Pythons concise syntax
- Integrate AI tools such as Copilot to assist with coding and analysis
- Connect Excel with external data sources using Python and Power Query
- Develop custom solutions for business modeling and data science
- Create a roadmap for further study and mastery of Python in Excel
Sample Content
Table of Contents
Chapter 1 Introduction to Python and Python in Excel
Chapter 2 Getting to know Python in Excel
Chapter 3 Using Python libraries
Chapter 4 Using The Python Editor
Chapter 5 Introduction to AI and Copilot
Chapter 6 Using Copilot with Python in Excel
Chapter 7 Using Copilot and Power Query connectors with Python in Excel