Want Sweet Deals? Join our Mailing List
By Tracy Stephens
Excel is a mainstay of the modern workplace, but it isn’t always the best tool for the job.
Excel is a mainstay of the modern workplace, but it isn’t always the best tool for the job. Python for Excel Power Users offers a better way, showing how Python and other coding tools can boost your productivity by streamlining your workflow. Even if you’re inexperienced at programming, you are not starting from scratch—this book leverages what you already know in Excel to introduce you to useful Python concepts that will have you up and coding in no time. Beyond Python, you’ll learn skills such as:
Practical examples illustrate how your new coding skills can be immediately applied to your day-to-day work. You’ll be amazed at how much more you can do once you escape the confines of the spreadsheet and replace Excel in your workflow.
September 2025, 200 pp.
ISBN-13: 9781718503984
Chapter 1: When Is Excel Not Enough?
Chapter 2: Setting Up Your Python Environment
Chapter 3: Python Concepts and Their Excel Equivalents
Chapter 4: Writing Python Scripts
Chapter 5: Version Control with Git
Chapter 6: Coding Interactively with Jupyter Notebooks
Chapter 7: Data Analysis with Pandas
Chapter 8: SQL for the Non-Engineer
Chapter 9: Working with APIs
Chapter 10: Programmatic Charting with Plotly
Chapter 11: Interactive Reports with Dash
Chapter 12: Practical Object-Oriented Programming
Chapter 13: Debugging and Testing Your Code
Chapter 14: Three Habits to Write Good Code
The chapters in red are included in this Early Access PDF.
We’ll send you sweet deals on upcoming books and let you know when new books are released. We’ll never sell, give away, or use your personal information for nefarious purposes. Choose the categories you’re interested in (check as many as you’d like):