
Identify spreadsheets worth automating
You'll have a written brief (1 page) listing 2-3 recurring spreadsheet tasks in your work and for each, a short explanation of whether AI code generation or traditional spreadsheet AI makes sense, wit
What you'll make
Spreadsheet Automation Assessment
- Task Inventory: your 3 most time-consuming spreadsheet workflows
- Automation Feasibility: AI code generation vs built-in AI scoring for each task
- Implementation Pathway: specific next steps for your top-ranked task
Write each task description with time spent per week and specific pain points you'd want automation to solve
The 3 parts
Each part ends with a check you can see.
Test Your Tasks Against AI
Take your actual recurring spreadsheet work and test what AI can handle today versus what requires your judgment
Done when
You have 3-5 specific spreadsheet tasks tested against AI capabilities with documented results showing what worked, what failed, and why
Score AI Automation Potential
Evaluate each tested task against built-in spreadsheet AI vs code generation capabilities
Done when
You have scored your top 5 tasks on a 1-5 scale for both Excel Copilot-style features and AI code generation, with reasoning for each score
Design Your Automation Path
Create a concrete 30-day plan to automate your highest-scoring spreadsheet task
Done when
You have a week-by-week implementation plan for your top task including specific tools, success metrics, and fallback options
Capstone: you put together your Spreadsheet Automation Assessment.
Where this helps
An elective: a single lesson that sits outside rtwo's job certificates and doesn't count toward one.
About this lesson
What you'll be able to do
- Have a ranked list of your top 3 spreadsheet tasks with automation feasibility scored 1-5
- Know when to use AI code generation vs built-in spreadsheet AI features for each task
- Have documented next steps for automating your highest-scoring task within 30 days
Who it's for
- Anyone who spends 2+ hours per week on repetitive spreadsheet work
- People who've wondered if AI could replace their manual Excel/Google Sheets tasks
- Knowledge workers who want to identify which spreadsheet automation pays off first
What it won't cover
- Actually building the automation (this identifies what's worth building)
- Setting up enterprise AI integrations or IT approvals
- Advanced VBA or Apps Script programming
Skills you'll practise
- Task complexity assessment
- Automation cost-benefit analysis
- AI capability mapping
- Implementation pathway planning