Start with the free xlwings Lite Practice Lab - a working set of tools rather than a theory course, drawn from day-to-day client projects. Three things in it: (1) an AI Coder Instruction File - a long (~1,800-line) directive file that is the core context you feed your AI so it produces clean, reliable xlwings Lite code; (2) step-by-step field guides - three hands-on modules (Data Manipulation, Cleaning, Campaign Build) shipped with the exact workbooks, guides and code used to test and validate; (3) live apps to pull apart - web scrapers, database connect, AI schema detection, machine learning and quants reports.
The core protocol for getting usable AI code generation, which generalizes well beyond Excel: Show - context is king, give the AI everything (images, schemas, rules). Tell - instruct, don't assume; be direct and iterate, because one instruction is never enough. Inspect - trust but verify; all AI output must be validated, it makes mistakes.
All guides, workbooks, apps and the instruction file are free to download: xlwings-lite.tigzig.com. Post: https://www.tigzig.com/post/python-in-excel-field-guide-practice-lab-for-ai-assisted-xlwings-lite. (xlwings Lite is built by Felix Zumstein.) Related: which AI coder to use https://www.tigzig.com/agents-faq/which-ai-coder-for-python-in-excel-xlwings.
← All Agents FAQ