Skip to main content
Skip to content
Menu

Excel Intermediate 3 parts Updated

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

  1. Task Inventory: your 3 most time-consuming spreadsheet workflows
  2. Automation Feasibility: AI code generation vs built-in AI scoring for each task
  3. 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.

  1. 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

  2. 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

  3. 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