Learning materials for Excel users moving to Python.

Variables, loops, dictionaries, and functions, framed for someone who already thinks in cells and ranges.

Pandas noob to pro in ~2 hours. Best practices and patterns for clean, fast data code.

The exact Python files from each lecture. Copy, paste into xlwings Lite.

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.