Workflow Macros track forced me to name steps I had memorized — painful but clarifying.
Automation Scripts
Workflow Macros: From Spreadsheet Macros to Python
Rewrite brittle macros as readable scripts triggered from familiar shortcuts.
14 hours · self-paced Self-paced BRL 480 · informational
Program narrative
Translate existing spreadsheet macros into Python modules your team can version. You will map macro steps to functions, add tests for edge cases, and package scripts for double-click launches.
Inside the bundle
- Side-by-side macro mapping worksheet
- Unit tests for parsing functions extracted from macros
- Packaging with PyInstaller notes for simple launchers
- Mentor review of a macro you bring (sanitized)
- Documentation template for operations desk teams
- Linting defaults tuned for short scripts
- Office hour on communicating changes to skeptical teammates
Outcomes we expect you to evidence
- Replace one production macro with a Python equivalent
- Store the new script in git with a README for handoffs
- Run a guided demo for a stakeholder without live data
Mentor anchor
Curriculum editor who documents how desk macros evolve into maintainable code.
Ricardo Vale
Primary reviewer for this program track.
Participant questions
Examples lean on Excel, but the translation patterns apply to Sheets exports too.
We read VBA to port logic, not extend it; goal is exit from opaque macro blobs.
Add-in marketplace distribution is out of scope; scripts stay file-based.
Recent peer notes
PyInstaller section was thinner than I wanted, yet mentors sent a follow-up gist same day.