How to use this course

Three suggested paths

🟢 Path A — Total beginner (recommended for most people)

Read Modules 1 through 12 in order, doing every exercise. Then pick whichever role module (13–16) fits your job, then Module 17 for the capstone.

Time: Roughly 12–20 hours, depending on how much you experiment.

🟡 Path B — "I've coded a little before"

Skim Modules 1 and 3–6, do all of Module 2 (setup) properly, then go full speed from Module 7 onwards.

Time: Roughly 6–10 hours.

🟠 Path C — "I have a specific Excel pain to fix today"

Do Module 2 (setup), Module 7 (files), Module 9 (pandas), and then jump straight to your role module. You can fill in the foundations later — most readers do.

Time: 4–6 hours.

What every lesson looks like

Every lesson page follows the same shape, so you always know where to look:

1. Objectives box at the top — what you'll know by the end.
2. Body — the actual lesson, broken into short sections with code samples.
3. Step-by-step walkthroughs in numbered cards for any real task.
4. Key takeaways — the three to five bullets you'd write on a sticky note.
5. Exercise — a small, do-it-yourself task that's quick to get a win on.
6. Prev / Next at the bottom — the lesson flows top-to-bottom through the course.

How to do the exercises (without giving up)

Three rules:

1. Try first, then read the answer. Even five minutes of "I don't know what to do" builds the muscle that reading never will.
2. It's fine to look things up. Real professional Python work involves Googling roughly every 90 seconds. We're not training you for an exam.
3. An error message is a clue, not a verdict. The last line of an error usually tells you exactly what went wrong. We have a whole lesson on this (Module 2, Lesson 6).

One small commitment

Do not skip Module 2 (Setup). It's the only module where the work isn't optional. If your Python isn't installed correctly, none of the rest of the course works on your machine. Take the 30 minutes; you'll never need to do it again.

What to do when you're done

You'll know you've "graduated" when you can:

• Open any spreadsheet in Python.
• Write a script that does the equivalent of three things you'd normally do by hand in Excel.
• Run a small =PY() formula inside Excel.
• Read an unfamiliar piece of Python code and roughly guess what it does.

From there, the world is your oyster — web scraping, dashboards, machine learning, automation, scripting your whole job. We list further-reading recommendations at the end of Module 17.