Learn to automate Excel tasks with Python programming
Learn to automate Excel tasks with Python programming
Use Python programming and data science tools to handle Excel spreadsheets, automate your workflow, and supercharge your skill set.
“I recently landed an awesome role at an accounting consulting firm. A big reason why I landed it was because I knew Python, which I learned from your book! Thanks for creating such a valuable resource, it was tremendously helpful.”
“There must be a way to automate
all that clicking.”
Hi! I'm Horatio Bota, a data scientist who knows how painful working with Excel can sometimes be.
Back in September 2018, my friend Adrian Gosa, who was working in audit at Deloitte, was trying to figure out what kind of computer programming can automate all the clicking he needed to do in SAP and Excel. Adrian and I have been friends for many years, so he asked for my input:
I pointed Adrian to a few resources on how to get set up with Python on his computer. Two days later, he wrote:
Adrian is now a Senior Accountant at Nike Europe. He uses Python — sometimes with Excel, but often on its own — every day in his work.
Over the past three years, Adrian and I have had many conversations like the one above. We soon realized that Python is an excellent tool for accounting: it's easy to pick up for someone who knows Excel, it's fast and flexible, and you can use it to glue together other accounting tools or systems.
So we decided to write a book that helps others in accounting get started with Python programming.
“This book is a must read for any accountant looking to keep pace with modern data tools.”
🎉🎉🎉
What we've put together
It's not just a book — it's everything you need tolearn how Python and accounting fit together.
When we first started this project, our idea was to put together a few tips and tricks on how to use Python with Excel. The more time we put into planning our content, the more we realized we had an opportunity to create something much better. Something that wasn’t just a collection of tricks, but an end-to-end guide on using Python in accounting.
Here's what we have now.
The Book
A hands-on guide to Python and its data science tools focused on accounting tasks and data, spread across 300+ pages.
The book takes you on a four-part journey:
- Part One: Python ABCs introduces the building blocks of the Python programming language. If you've never seen code before, this part of the book will show you how to define variables and functions in Python, how to work with lists and loops, and more.
- Part Two: Working with Tables is where the rubber meets the road in using Python for accounting. This part of the book shows you how to use the pandas Python library to handle Excel spreadsheets.
- Part Three: Visualizing Data shows you how to turn data from Excel tables into perfectly crafted plots using Python code.
- Part Four: Sales Analysis Project takes you through an end-to-end management accounting project. You'll analyze sales and profitability with Python, pandas, and a few other Python libraries.
The book contains everything you need to know about using Python programming in accounting, distilled into short, easy to read chapters.
See for yourself — follow us to read the first chapter:
The Projects & Data
Most Python tutorials are too vague for accounting. They go over the basics, but don't show you how Python makes handling real Excel spreadsheets easy.
Python for Accounting teaches you how to use Python to work with real-world accounting tables that look like this:
We'll walk you through five quick data handling projects:
- Filtering and splitting a large Excel file into multiple sheets
- Reading and cleaning a QuickBooks general ledger
- Mining product reviews to discover what people like and dislike about their purchases
- Filling missing values in an Excel spreadsheet using data from another file
- Turning a cash flow statement into a waterfall plot
You'll learn how to use Python and automate the repetitive parts of your accounting job today.
The Workspace
Getting set up with the software you need to write and run Python on your computer is often the hardest part of learning how to code.
That's why you get access to a remote workspace that has Python installed, and is already set up with all the datasets and code files you'll need to go through the book. All in one click.
“Fantastic book! I do bookkeeping, payables, transparency reporting (...) I learned how to automate about half my workload with Python.”
Get Python for Accounting now
Choose the package that's right for you.
The Complete Guide
- The 395-page book in PDF format
- All 8 accounting datasets you'll use throughout the book
- An interactive coding notebook for each chapter that you can use to learn Python fast
- One-click access to the Python for Accounting remote workspace
- Access to the Python for Accounting Discord channel, a group where you can ask us questions and learn Python with other readers
- All updates to the first edition of the book
The Essential GUIDE
- The 395-page book in PDF format
- All 8 accounting datasets you'll use throughout the book
- An interactive coding notebook for each chapter that you can use to learn Python fast
Who we are
Horatio has over seven years of experience in data analytics and data science. He has previously worked at Microsoft Research, J.P. Morgan Chase and several startups in the UK. He has a BSc and a PhD in Computing Science from the University of Glasgow.
Adrian is a Senior Accountant at Nike Europe. He has over seven years of business and finance experience at PwC and Deloitte. Adrian has an M.A. in Business Economics and an M.Sc. in Quantitative Finance from the University of Glasgow.
Frequently Asked Questions
Sure! We offer live or online workshops for up to 100 participants.
If you're interested in a workshop for your team, send us an email at workshops@pythonforaccounting.com.
Definitely! Check out our team pricing options here.
We're planning on printing a physical version later this year, but right now everything is only available digitally.
Of course! Click the "Generate" button on your receipt from Gumroad after you purchase and you can generate a detailed invoice with any additional information you need.
You get the book as a PDF file. No DRM.
Any time! Sends us an email at support@pythonforaccounting.com and we'll get you sorted.
No problem! Email us at support@pythonforaccounting.com within 30 days and we'll refund you in full.