Run real code
Live editor, instant feedback. Everything runs right here in your browser.
Course code
The exact Python files from each lecture. Copy, paste, run.
Slides & explainers
Short decks and walkthroughs that go alongside the lectures.
What this add-in actually is, in five slides. Plus the questions everyone asks first.
What xlwings is, the Excel object model (Book, Sheet, Range), and how to run scripts and custom functions.
Lite handles 95% of Excel automation. The 5% that still needs full Python, and the workarounds.
Four sales files, one distributor master, one Word template. One click in Excel. See the whole capstone in 8 slides.
Pull live exchange rates, addresses, AI completions, and anything with a URL straight into your sheet.
Generate personalized Word docs from a template. Drop placeholders, hand Python a dict, get a finished doc.
Turn a DataFrame into an interactive HTML chart you can hover, zoom, and filter, in two lines.
The AI built into xlwings Lite. The =WINGMAN() formula, the chat that writes and debugs your Python, and what to know before your data leaves the machine.
You've got the skills. Three practical tips for putting Excel automation to work, plus where to go deeper.