What do you think?
Rate this book
Python for Excel Users: Know Excel? You Can Learn Python
When Excel isn’t enough, it’s time to learn Python.
If you’re comfortable in Excel, but you’ve hit a wall—slow files, broken formulas, hours spent on repetitive tasks—this book offers a way forward. It shows you how to take the work you already do in spreadsheets and make it faster, smarter, and more powerful with Python.
You’ll start by setting up your environment and getting comfortable with Python through short, Excel-inspired exercises. From there, you’ll gradually move into writing scripts that automate manual work, structure your data, and generate consistent results—no prior programming knowledge required.
You’ll use your preexisting Excel skills to learn how
Translate spreadsheet logic into Python codeUse pandas to clean, reshape, and filter dataAutomate reports you’d normally build by handRead and write Excel files directly from PythonConnect to databases and APIsCreate professional visualizations with Plotly and DashOrganize code into sharable modules and write simple tests
Throughout the book, you’ll find practical examples that show why and how to move your work out of spreadsheets and into scripts, and how to resolve issues along the way.
Author Tracy Stephens has extensive practical experience with both Excel and Python. Her approach is grounded in real workflows, and she introduces each concept through tasks you’ve likely handled in Excel.
This book won’t ask you to replace everything you do in spreadsheets, but it will help you use Python to work faster, more reliably, and with greater flexibility than you ever could with Excel.
If you’re comfortable in Excel, but you’ve hit a wall—slow files, broken formulas, hours spent on repetitive tasks—this book offers a way forward. It shows you how to take the work you already do in spreadsheets and make it faster, smarter, and more powerful with Python.
You’ll start by setting up your environment and getting comfortable with Python through short, Excel-inspired exercises. From there, you’ll gradually move into writing scripts that automate manual work, structure your data, and generate consistent results—no prior programming knowledge required.
You’ll use your preexisting Excel skills to learn how
Translate spreadsheet logic into Python codeUse pandas to clean, reshape, and filter dataAutomate reports you’d normally build by handRead and write Excel files directly from PythonConnect to databases and APIsCreate professional visualizations with Plotly and DashOrganize code into sharable modules and write simple tests
Throughout the book, you’ll find practical examples that show why and how to move your work out of spreadsheets and into scripts, and how to resolve issues along the way.
Author Tracy Stephens has extensive practical experience with both Excel and Python. Her approach is grounded in real workflows, and she introduces each concept through tasks you’ve likely handled in Excel.
This book won’t ask you to replace everything you do in spreadsheets, but it will help you use Python to work faster, more reliably, and with greater flexibility than you ever could with Excel.
- GenresReference
336 pages, Kindle Edition
Published September 23, 2025
5 people are currently reading
11 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.