Learn how AI can help you write Excel or Google Sheets formulas, clean messy columns, and turn raw data into simple insights.
Includes practical lessons, exercises, and a clear next step after you enroll.
About this course
Curriculum
Lessons are listed in order. Each one has a goal, a walkthrough, practice, and a short check before you continue.
- 01What to automate versus what to keep as a formulaUse AI for messy text and planning; keep numbers in the sheet.
- 02Cleaning and classifying columnsTurn messy text columns into categories you can filter.
- 03Drafting formulas and checking themAsk for a formula, then test it on known rows.
- 04Explaining errors and circular referencesPaste the error and the formula, not the whole workbook.
- 05A repeatable weekly sheet workflowSame steps every week: import, clean, check, summarize.
- 06When to leave the spreadsheetKnow when the job belongs in a script, a database, or a proper app.
- 07Workshop: a complete pass on a real taskCombine the earlier lessons into one working example you can keep.
- 08Quality bar, common mistakes, and a 30-day planLock in a checklist so the skill survives after the course ends.