Skip to main content
⚡
CodeMentor AIAll tracks
📋L2 · 8 modules · 50 lessons

Python for Office Workers

Excel, Google Sheets, scraping — automate the boring parts of your job

10 lessons across 3 modules: Excel & CSV (DictReader, openpyxl read/write), Web APIs (requests, JSON parsing, Google Sheets via gspread), and Web Scraping (BeautifulSoup tables, capstone daily-price scraper). Designed for accountants, analysts, ops people — no CS background required.

Browse all 50 lessons →Try the first lesson — no signup
50
lessons
8
modules
0
capstone missions
18
languages
What you'll learn

From day one

  • ✓Excel, Google Sheets, scraping — automate the boring parts of your job
Curriculum

8 modules · 50 interactive lessons

#1Module 1 · Excel & CSV
#2Module 2 · Web APIs
#3Module 3 · Web Scraping
#4Module 4 · Email automation
#5Module 5 · Files & scheduling
#6Module 6 · API integrations
#7Module 7 · Reports & data
#8Module 8 · PDFs & documents
See all 50 lessons →

Frequently asked

Is this for non-programmers?

Yes — designed for accountants, analysts, ops people who want to stop doing the boring parts of their job by hand. No CS background needed.

Will I be able to automate my Excel sheets?

Yes — Module 1 is dedicated to Excel + CSV (openpyxl, DictReader, pandas if you want to step up).

Does it cover web scraping?

Yes — Module 3. BeautifulSoup for HTML, basic requests, polite scraping (delays, user-agent, robots.txt respect). Not a 'scrape every site' course.

Capstone?

A daily-price scraper that emails you a CSV when something on a watchlist changes. Runs as a cron job — your first real automation.

How long is this track?

Currently 10 lessons across 3 modules — shorter than the others by design. Expanding as we learn what office-worker learners want next.

First 15 lessons free, no signup

All 50 lessons unlock for $12/month or $89/year. 7-day free trial — card required, cancel in 1 click anytime in Settings.

See pricing