The full course
Seventeen modules grouped into four tiers. Each lesson is self-contained — read in order, or skip ahead to what you need.
Foundations
Start here if you've never written code. By the end of this tier you'll be comfortable reading and writing basic Python.
Introduction to Python
What Python is, why it matters for Excel users, what it can (and can't) do, and how to use this course.
Module 02 · FoundationsSetting Up Your Environment
Install Python the easy way (Anaconda), set up VS Code, get a Jupyter notebook running, and turn on =PY() in Excel.
Module 03 · FoundationsVariables and Data Types
Strings, numbers, booleans, None — the building blocks of every Python value, and how they map to Excel's cell types.
Module 04 · FoundationsControl Flow
if / else / elif, for and while loops, and Python's gentle error-handling — try/except.
Module 05 · FoundationsFunctions
Define your own reusable mini-tools. Arguments, return values, defaults, and the rules that keep functions honest.
Module 06 · FoundationsData Structures
Lists, dicts, tuples, sets — Python's built-in collections and the Excel equivalents for each.
Excel toolkit
How to do Excel work with Python — files, =PY(), pandas, cleaning, charts, and automation.
Working with Files
Open CSVs, Excel workbooks, folders full of spreadsheets, and write back out. The bread-and-butter file operations.
Module 08 · Excel toolkitPython inside Excel — =PY()
Use Python in a cell like a formula. Pass ranges, return DataFrames, chart inline, and decide when =PY() is the right tool.
Module 09 · Excel toolkitPandas Crash Course
The most important library in this course. DataFrames, selection, filtering, grouping, joining, pivoting — the spreadsheet superpowers.
Module 10 · Excel toolkitData Cleaning and Transformation
Fix dates that won't sort, names with stray spaces, half-empty columns, and every other mess that real data throws at you.
Module 11 · Excel toolkitData Visualization
Matplotlib basics, pandas plotting, seaborn for prettier defaults, and how to drop charts into Excel.
Module 12 · Excel toolkitAutomating Boring Excel Tasks
Merge 100 files, rename sheets, format dozens of workbooks, send personalised emails — set it once and walk away.
Role scenarios
Full worked examples for Finance, Analyst, HR, and Sales roles. Use them as templates for your own work.
Scenario: Finance & Accounting
Reconciliations, variance analysis, budget consolidation, invoice processing, and the small daily wins that compound.
Module 14 · Role scenariosScenario: Data & Business Analyst
Cleaning huge exports, joining tables, building dashboards, ad-hoc analyses, and shipping the results.
Module 15 · Role scenariosScenario: HR & Operations
Headcount, payroll prep, timesheet cleanup, employee data hygiene, and the dozen small reports that pile up.
Module 16 · Role scenariosScenario: Sales & Marketing
Lead-list cleanup, CRM exports, campaign reporting, funnel analysis, and a weekly pipeline report you stop having to build.
Capstone projects
Four end-to-end projects that combine everything.