Python courses: spreadsheet jobs you type and run in Google Colab
Do the spreadsheet jobs that come back every month with a few lines of Python in the free Google Colab: total and rank a sales export, stack three monthly exports into one quarter, and clean a messy invoice export before you total it.
Every module is a hands-on practice on real Colab screens where you type every line yourself, one or two lines per step, then a checklist to do it again in your own notebook. The course comes with a one-page cheat sheet and the few terms you meet most.
Who it is for: office managers, bookkeepers and analysts who total and fix exports by hand. A free Google account and a browser are enough; the made-up office-supply shop in it uses the same lines you then run on your own files.
Google Colab1 course
Python for Spreadsheet Work Jump Start
Do three everyday spreadsheet jobs with Python in the free Google Colab, typing every line yourself: total and rank a sales export, combine three monthly exports into a quarter, and clean a messy invoice export before you total it.
The 3 modules
- Python: Total a Sales Export by Customer in Google ColabGoogle Colab · Beginner · ~12 min
- Python: Combine Monthly Sales Exports into One QuarterGoogle Colab · Beginner · ~12 min
- Python: Clean a Messy Invoice Export Before You Total ItGoogle Colab · Beginner · ~12 min
Cheat sheet: Python for Spreadsheet Work Cheat Sheet · PDF
Words to know: Python pandas (Python) CSV
