Menu

Automate Hours of Excel Work with Python. In One Afternoon.

Learn the exact process for turning repetitive Excel work into one-click workflows in just 3.5 hours.

  • No programming experience required
  • No Python installation needed
  • No admin permissions required
  • Set up in a couple of clicks
Get Instant Access

Watch the 4-minute trailer

116,000
Learners on YouTube
3+ hours
52 short lessons
Zero
Coding experience needed
Mac, PC, Web
Works on your Excel
What you'll build

Learn Python the way Excel users actually need it.

This course does not turn you into a software engineer. It turns you into the person who automates the work everyone else still does manually.

Two of the automations you will build:

Generate Word documents in bulk

Turn a sheet of data into a folder of finished, formatted Word reports with one click.

Turn data into an interactive dashboard

Go from a raw export to a clean dashboard you can filter, hover, and explore.

  • Consolidate dozens of files into one clean table.
  • Clean and reformat messy data in seconds.
  • Build interactive dashboards from raw numbers.
  • Generate Word documents automatically.
  • Turn a 90-minute report into a one-click button.
  • Let AI write and debug the code with you.
Get Instant Access
Sound familiar?

Why you're still doing this manually.

Every week, the same grind. And the two obvious ways out both stall.

You clean and reformat the same exports by hand
Hours gone. Every single week.
You copy, paste, and repeat across dozens of files
Slow. And mistakes slip in.

You have probably already looked at both of these.

VBA

Handles the simple stuff, then gets complicated fast. And plenty of IT departments block macros outright.

Python

Looks like the answer, but the setup sounds intimidating, and most courses teach software engineering, not how to automate a spreadsheet.

There is a shorter path. It runs inside the Excel you already have, and your first automation takes about an hour.

Get Instant Access
How it works, the missing bridge

Python runs right inside Excel.

No installer, no command line, no admin rights. A free add-in called xlwings Lite runs Python on your own computer, right inside Excel's task pane. This course teaches you to use it well.

An Excel add-in

Installed in a couple of clicks from the Office store. No separate Python, no command line, no setup wizard, no VBA.

Runs on your computer

Python runs right inside Excel's task pane. Your code and data stay on your machine.

100% free

Personal and commercial use. No user limit, no usage limit, no time limit. No account needed.

Works on your Excel

Microsoft 365 or Office 2021 and newer, on Windows, Mac, or Excel in the browser.

Shares like a normal file

Your Python lives inside a regular .xlsx. No .xlsm, no macros, no scary warnings for your colleagues.

The power of Python

Clean data, build reports, create interactive charts, generate Word and PDF files, with libraries like pandas and Plotly.

Learn by doing

Python for Excel users. It clicks faster than you think.

You use Excel every day, and Python has more in common with it than you would expect. I teach every Python concept by translating it from the Excel you already know.

  • Real Python in your browser, nothing to install
  • Cheatsheets and practice exercises
  • Learn the essentials in about an hour
Get Instant Access Visit the app →
Excel you know
Python you learn
# click Run code
The AI question

Why learn Excel automation if AI writes code?

AI just gives you back code. You still need to know what to do with it and how to run it.

Know what to ask

AI only becomes useful once you understand the workflow and can describe the task clearly.

AI is a black box

You cannot see how it got there. Know the basics and you can read its code and trust the result.

Run it in Excel

A chatbot just hands you back a Python script. You will learn to use AI right inside Excel and run it with a click.

Keep your data private

You do not want to paste confidential spreadsheets into a chatbot. You will learn a safer way that keeps your data on your machine.

You will use AI in this course, knowing how to guide it and trust the result.

Sven Bosau
Your instructor

Hi, I'm Sven.

I have worked with Excel since 2011 and spent my entire corporate career at Bosch, one of the world's largest automotive suppliers, building tools to automate data work for real business needs.

Along the way I have seen every kind of messy Excel file there is, and learned how to clean it up, automate it, and, just as important, how to share those automations so colleagues can run them with a single click. This course covers all of that, including the sharing part most courses skip. Today I teach 116,000 people on my YouTube channel, Coding Is Fun.

This is really the course I wish I had when I started out on my own coding journey. And honestly, I do not like long courses. I never finish them myself. So I kept this one compact. No computer science, no fluff. Just the parts that automate real work.

2011Excel since
116kYouTube subscribers
BoschCorporate background
Let's clear this up

What about VBA, Power Query, or Python in Excel?

Why not VBA?

Python reads more like plain English, and it does not get blocked by IT the way VBA macros often do. A few lines of Python can run analytics, build interactive charts, and generate documents. Doing the same in VBA is far more complicated, if it is possible at all.

Why not Power Query?

Power Query is great for cleaning and reshaping data. Keep using it, and feed its result straight into Python to build dashboards, generate documents, and automate the rest. Or replace it and run the whole pipeline in Python.

Isn't this Microsoft's Python in Excel?

No, and the difference matters. Microsoft's version runs in the cloud, works on Microsoft 365 only, and has usage limits. xlwings LiteA free Excel add-in that runs Python on your own computer, right inside Excel. No separate install, no command line. runs on your computer, keeps your data on your machine, has no usage limits, and does both: analyze data and automate Excel.

 
Microsoft Python in Excel
xlwings Lite
Where it runsWhether the Python code is executed on Microsoft's servers or on your own machine.
Microsoft's cloud
Your computer
Your dataWhether your spreadsheet data has to leave your computer for the code to run.
Sent to the cloud
Stays on your machine
Works onWhich Excel versions you can install it in. Office 2021 and 2024 are one-time purchases, no subscription.
Microsoft 365 only
365 or Office 2021+
Usage limitsWhether there is a cap on how much Python you are allowed to run.
Yes, has a quota
None
What it doesAnalyzing returns a result into a cell. Automating also creates files, formats sheets and runs multi-step jobs.
Mainly analyze a sheet
Analyze and automate
PriceWhat it costs on top of the Excel licence you already have.
Bundled with paid M365
Free
From the community

People already learn this way every day.

A few words from the Coding Is Fun community on YouTube.

"This is the correct benchmark of technical teaching. I wish more technical trainers could adopt your clear framework for breaking down technical concepts for coding. Thank you!"

@auusiebatman

"By far this is the best tutorial video I have seen. Clear instructions, demonstrations in theory behind each concept, and easy to follow bite size steps. Learnt more in this short video than in some hour long ones."

@anthonyjobey8821

"This is brilliant! I finally start to understand some core Python and programming concepts, and this is a great tool for learning more. Well done! I recommend your channel whenever I can."

@catoberge

"Thanks for making these useful tutorials, Sven. Your teaching style makes everything look simple and clear!"

@christinewalsh111

"Your explanations are so concise and easy to follow. Thank you for making this video!"

@MyCodingDiary

"You have an amazing teaching style! Really love it and wish you could produce more content."

@srh1034
The curriculum

6 modules, 52 lessons, 3+ hours of video.

A clear path from your first script to a finished automation, then AI on top. Hover or tap any lesson to see what is inside. Four lessons are free to preview.

1
Start Here: Python Inside Excel in Minutes
Get set up and see the magic on day one
2 lessons · ~9 min
1.1
Install the xlwings Lite Add-in
Add xlwings Lite from the Office store and run your first script. One click builds a styled report, a table, and a chart. No formula, no setup.
~5 min
1.2
Meet xlwings Lite: What It Is and Why It Is Different
How it runs locally so your data stays private, why it is free even for commercial use, what you need to run it, and how it compares to Microsoft Python in Excel.
~4 min
2
Python Crash Course for Excel Users
Turn your Excel skills into Python, in about an hour
23 lessons · ~50 min
2.1
The Guided Video Tour
One walkthrough of the whole app, then you practice each topic yourself.
~7 min
A Python crash course for Excel users. In about an hour, learn to do what you already know in Excel with Python instead: a VLOOKUP, a pivot table, cleaning and combining messy files. Then lock it in with hands-on exercises in the interactive app, running real Python in your browser with nothing to install.
VLOOKUPSUMIFPivot tablesClean messy dataCombine filesA mini project
3
Automate Excel with xlwings
From reading files to writing data, charts, and tables
4 lessons · ~36 min
3.1
A Quick Tour of the xlwings Lite Add-in
Get comfortable with the editor, the requirements tab for installing packages, the output window, and the notebook.
~4 min
3.2
Reading and Writing Files (Windows, Mac, Browser)
How to safely read and write local files and folders, including the built-in data folder, drag and drop, and local folders.
~7 min
3.3
The xlwings Mental Model
The simple pyramid behind every script: workbook, sheet, and range. Plus the two ways to run code, a button or a custom Excel formula.
~8 min
3.4
xlwings in Action: A Hands-On Code Walkthrough
Add and delete sheets safely, write and read DataFrames, build dynamic ranges, create real Excel Tables, and drop in a chart.
~17 min
4
Capstone Project: Build a Real Automation
A real automation, built from scratch
16 lessons · ~69 min
4.1
The Capstone: Your Mission and the Payoff
See the real-world scenario and the finished result, then build it yourself in the next lesson.
~8 min
4.2
Build It From Scratch: The Full Walkthrough
The whole automation, coded step by step in short lessons you can follow along with, from the first button to handing it to a colleague.
15 lessons · ~61 min
The capstone, one step at a time. Four messy sales files go in. A clean audit workbook, an interactive dashboard, and twelve Word statements come out. You build every piece yourself in short lessons, so you can pause, code along, and pick it back up whenever you like.
Combine filesClean messy dataMerge a master listLive exchange ratesPlotly dashboardWord documentsControl panelShip it to a colleague
5
Supercharge Your Work with AI
Use the built-in AI assistant to write and debug code fast
5 lessons · ~23 min
5.1
Coding with AI: Meet Wingman
Why we learn the basics by hand first, and how that turns AI into a helper you can steer instead of a black box.
~3 min
5.2
Set Up Wingman, Your AI Assistant
Add an AI provider, create and store an API key safely, and pick a model. Set budgets and alerts so there are no surprises.
~3 min
5.3
The Wingman Formula
A Copilot-style formula that works on older Excel and needs no subscription. A handy extra in your toolbox.
~2 min
5.4
Debug Your Code with AI
Read a Python error yourself, then ask Wingman for a fix, and learn to keep AI from changing more than you asked.
~5 min
5.5
Let AI Write the Code: Build a Dashboard from One Prompt
Give the AI the right context, then build a full interactive sales dashboard step by step or in one shot. Then check its work.
~10 min
6
Ship It and Keep Going
Know the limits and plan your next move
2 lessons · ~6 min
6.1
Know the Limits of xlwings Lite
Where xlwings Lite stops (some APIs, direct database connections, and a few Excel features) and the simple workarounds for each.
~4 min
6.2
Course Wrap-Up and Your Next Steps
Three practical tips for the real world, and where to go next to keep growing your Python skills.
~2 min
One time. Yours forever.

Pay once, automate forever.

Lifetime access
$149$99
Launch offer · Save $50
One-time payment · Launch price ends 10 August, 12:00 noon Bangkok time
  • The full capstone project
  • All source code included
  • 3+ hours of on-demand video
  • Access to the interactive learn app
  • Practice exercises and cheatsheets
  • Ask your questions under every lesson
  • English closed captions on every lesson
  • Certificate of completion
  • Lifetime access and free updates
Get Instant Access

Secure checkout · Card or PayPal

Honest fit check

Who this is for, and who it is not.

This is for you if

  • You use Excel regularly and you are tired of repetitive work.
  • You want results at work, not a computer science degree.
  • You have Microsoft 365 or Office 2021 or newer.
  • You have zero Python experience. That is fine, we start from zero.
  • You do not need to be an Excel expert. If you can write a SUM formula, you are ready.

This is not for you if

  • You want a deep, theoretical Python course for software engineering.
  • You have never worked with Excel before.
  • You are on Office 2019 or older, where the add-in does not run.
  • Your company blocks the Office add-in store and will not allow any add-ins.
  • You want a one-click tool, not a skill you build yourself.
Questions and answers

Everything you might be wondering.

Learn how to automate Excel in an afternoon.

A skill you keep for the rest of your career.

Get Instant Access

Or watch the free preview lessons first