A01=John Wengler
algorithm
algorithms
anaconda
Author_John Wengler
Category=UFC
Category=UM
Category=UMX
clean code
code
coding
coding for beginners
coding for kids
computer
computer books
computer programmer gifts
computer programming
computer science
computers
data analysis
database
databases
eq_bestseller
eq_computing
eq_isMigrated=1
eq_isMigrated=2
eq_new_release
eq_nobargain
eq_non-fiction
excel
IDLE
learn python
learning python
math
mathematics
pivot table
programmer gifts
programming
python
python 3
python books
python data science
python for beginners
python for data analysis
python machine learning
python programming
security
spreadsheet
spyder
tech
technology
VLOOKUP
Product details
- ISBN 9781718504646
- Dimensions: 177 x 234mm
- Publication Date: 19 May 2026
- Publisher: No Starch Press,US
- Publication City/Country: US
- Product Form: Paperback
Secure
checkout
Fast Shipping
Easy returns
Automate the Excel Stuff with Python bridges the gap between Excel expertise and Python programming without forcing you to start from scratch. Unlike other programming guides, it's specifically designed for Excel users who need more power and automation, not for professional programmers. This book focuses on enhancing your existing Excel skills rather than replacing them. You'll learn how Python's dataframes work like virtual spreadsheets, extending what you already know while automating repetitive tasks. You'll be able to import and export data seamlessly between Excel and Python to integrate coding into your current workflow. Concise, practical examples throughout will get you up and running quickly. Each topic addresses real problems Excel users face, with solutions you can implement immediately. The structure is deliberately flexible. Chapters progress logically but stand independently, so you can jump to exactly what you need without reading everything that came before. This makes it perfect for solving urgent problems or learning at your own pace. You'll apply the techniques you learn to automate reports, clean messy data, perform complex calculations, and handle large datasets that would overwhelm Excel alone-all while leveraging your existing spreadsheet knowledge.
John Wengler taught himself Python to automate a spreadsheet process and solve a “million-dollar problem” at work. He is the author of Managing Energy Risk and has taught at the Illinois Institute of Technology and Tulane University.
