This book is a hands-on, practical guide showing how to use the newly integrated Python capabilities within Microsoft Excel, mapping familiar Excel concepts to Python foundations. Liam Bastick and Kathryn Newitt cover topics such as Python syntax, data structures, data analysis with pandas, visualization, and the use of complementary tools such as Power Query and Copilot. Readers will gain the ability to perform advanced forecasting, build predictive models, and streamline workflows, making you more efficient and competitive in today’s data-driven workplace.

<ASIN:0135437970 >

Author: Liam Bastick and Kathryn Newitt
Publisher: Microsoft Press
Date: January 2026
Pages: 368
ISBN: 978-0135437971
Print: 0135437970
Kindle: B0FVSVH5SW
Audience: Excel users
Level: Introductory/Intermediate
Category: Python and Data Science

Topics include:

• 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 Python’s 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

For recommendations of Python books see Books for Pythonistas and Python Books For Beginners in our Programmer's Bookshelf section.

For recommendations of books on data science see Reading Your Way Into Big Data in our Programmer's Bookshelf section.

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.