Course track
Spreadsheet Automation and Operational Spreadsheets
This track treats spreadsheets as real operational systems: lookup tables, control panels, reporting layers, CSV bridges, and automation endpoints. It covers when spreadsheets are good enough and when they become fragile.
Lessons13
Live now13
Draft queue0
This track page is intentionally kept out of the index until more of the public lessons are live. That keeps the curriculum navigable for humans without asking search engines to rank thin track pages before the lesson bodies exist.
Track lessons
Live lessons link out directly. Draft lessons are already scaffolded in the repo so the track can be written in order without changing slugs or metadata later.
- Lesson 1LiveSpreadsheet Automation Explained
- Lesson 2LiveExcel vs Google Sheets for Automation
- Lesson 3LiveHow to Clean Spreadsheet Data Before Automation
- Lesson 4LiveCSV vs Excel vs Google Sheets in Automation Workflows
- Lesson 5LivePower Query vs Formulas vs Scripts
- Lesson 6LivePython in Excel for Automation Workflows
- Lesson 7LivePivot Tables vs Dashboards vs Reports
- Lesson 8LiveHow to Build a Spreadsheet-Based Automation Control Panel
- Lesson 9LiveHow to Use Spreadsheets as Lookup Tables in Automations
- Lesson 10LiveHow to Stop Spreadsheet Automations from Breaking
- Lesson 11LiveImporting API Data into Spreadsheets
- Lesson 12LiveExporting Spreadsheet Data into Apps and CRMs
- Lesson 13LiveBest Spreadsheet Automation Workflows for Operations Teams
Tools that fit this track
Free, privacy-first utilities in your browser — no uploads required for most workflows.
- Excel SuiteUse in-browser merges, pivots, and SQL-style analysis for spreadsheet-led automation systems.
- CSV Tools SuiteProfile, validate, split, and convert CSV files that feed spreadsheet automations and reporting flows.
- CSV to JSON ConverterTurn spreadsheet exports into JSON for APIs, web apps, and lightweight automation payloads.
- JSON to CSV ConverterConvert API output back into CSV when spreadsheet users still need the data as a file.
Browse other course tracks
- Workflow Automation FoundationsStart here if you are still defining the model. This track covers what workflow automation actually is, how integrations fit into it, when automation is worth doing, how to map a workflow cleanly, and which use cases create leverage instead of chaos.
- APIs, Webhooks, and Integration BasicsThe technical core of modern automations: APIs, webhooks, authentication, retries, quotas, schemas, and error handling. This track is where non-technical operators stop feeling blocked and technical builders stop shipping brittle workflows.
- Zapier WorkflowsA practical track for teams standardizing on Zapier. Learn how Zaps are structured, how to use built-in tools like Formatter, Filters, Paths, and Webhooks, what task usage really means, and where Zapier is strong or weak compared with other platforms.