If you can use VLOOKUP, you can learn Python.
Python is now built into Excel. That means the spreadsheet you already love can do everything Python can — clean huge files, scrape websites, build dashboards, send emails. This course shows you how, one bite-sized lesson at a time.
Start from absolute zero
We assume you've never installed Python, never opened a terminal, and never written a function. Every term gets defined. Every step has a screenshot.
Built around real Excel work
Every concept lands in something you actually do: reconciling ledgers, cleaning lead lists, headcount reports, monthly variance analysis.
Inspired by the best teachers
Modeled after Automate the Boring Stuff with Python and the For Dummies series — practical, friendly, and ruthlessly beginner-first.
Scenario-based by role
Dedicated modules for Finance, Data Analyst, HR/Operations, and Sales/Marketing — so you learn on the problems your job throws at you.
Step-by-step walkthroughs
Every lesson breaks tasks into numbered steps with full code, expected output, and "what to do if it breaks" notes.
Free, forever
The whole site stays free. Read in any order, jump to the parts that solve your problem today, come back when you need more.
What you'll be able to do by the end
- Open, read, and edit Excel files of any size with Python — including ones too big for Excel itself.
- Write
=PY()formulas inside Excel cells to do things VLOOKUP and pivot tables can't. - Clean messy data in seconds — fix dates, strip whitespace, deduplicate, standardize names.
- Automate repetitive reports that used to eat half your morning.
- Build charts and dashboards straight from raw data.
- Pull data from websites, APIs, PDFs, and emails directly into your spreadsheets.
- Write small scripts you can re-run whenever you want, in seconds.
The course at a glance
Seventeen modules grouped into four tiers. Click any module to see its lessons.
Introduction to Python
What Python is, why it's everywhere, and why Excel users are finally being invited to the party.
Module 02 · FoundationsSetting Up Your Environment
Install Python the right way, get Excel's =PY() working, and meet your code editor.
Variables & Data Types
Strings, numbers, booleans — and how a Python "variable" is just a named cell.
Module 04 · FoundationsControl Flow
If / else / loops — how Python decides and repeats.
Module 05 · FoundationsFunctions
Build your own reusable mini-tools. Like custom Excel formulas, but more powerful.
Module 06 · FoundationsData Structures
Lists, dicts, tuples, sets — Python's answer to rows, columns, and lookup tables.
Module 07 · Excel ToolkitWorking with Files
Open CSVs, text files, and folders full of spreadsheets without breaking a sweat.
Module 08 · Excel ToolkitPython inside Excel — =PY()
Use Python in a cell, just like a formula. Pass ranges, return tables, mix and match.
Module 09 · Excel ToolkitPandas Crash Course
The library that turns Python into a super-spreadsheet. Filter, sort, group, pivot.
Module 10 · Excel ToolkitData Cleaning & Transformation
Dates that won't sort, names with stray spaces, half-empty columns — fixed in one pass.
Module 11 · Excel ToolkitData Visualization
Charts in Excel, charts in Python, charts in =PY() cells. Bar, line, scatter, heatmap.
Automating Boring Excel Tasks
Merging 100 files, renaming sheets, sending emails — set it once and walk away.
Module 13 · ScenariosFinance & Accounting
Reconciliations, variance analysis, budget consolidation, invoice processing.
Module 14 · ScenariosData & Business Analyst
Cleaning huge exports, joining tables, building self-refreshing dashboards.
Module 15 · ScenariosHR & Operations
Headcount reports, payroll prep, timesheet cleanup, employee data hygiene.
Module 16 · ScenariosSales & Marketing
Lead-list cleanup, campaign reporting, CRM exports, funnel analysis.
Module 17 · CapstoneCapstone Projects
Four end-to-end projects that combine everything you've learned. Ship them. Show them.
Who this is for
The accountant
Who's tired of building the same reconciliation in Excel every month.
The analyst
Whose VLOOKUPs are getting too slow and whose CSVs are getting too big.
The HR coordinator
Who'd like headcount reports to update themselves.
The sales ops lead
Who exports the CRM weekly and wishes the next step were automatic.