Automate Office Tasks with Python
You spend an hour every week doing something a script could do in four seconds, and you have never written a script because every tutorial assumes you want to become a software engineer.
48 pages PDF + EPUB $17 USD
Python Automation
Everything published here about replacing repetitive work with short Python scripts: organising files, cleaning spreadsheets, pulling data from the web, and knowing when a script is worth the twenty minutes it takes to write.
Why this is its own topic
Most programming material assumes you want to become a programmer. That is a reasonable goal and it is not the only one. A large number of people need exactly one thing from code: to stop doing the same task by hand for the forty-seventh time.
The guides and books below treat Python as a tool rather than a career. They cover the specific, repeatable problems that justify writing a script, renaming files, wrangling spreadsheets, pulling numbers off a web page, and they stop before the material starts requiring a computer science degree to follow.
Books on this
Guides on this
-
Automate File Organisation with Python
There are nine hundred and fourteen files in the average Downloads folder. That is not a made-up number. It is what came out of a survey…
-
Python Excel Automation for Beginners
There is a spreadsheet somewhere in your week that takes forty minutes you will never get back. It arrives on Monday, or it arrives on the…
-
Web Scraping with Python, No Experience Required
You open the same web page every morning, find the same number, copy it, and paste it into a spreadsheet. You have done this every working…