← Back to portfolio
AI Skills · Software Adoption

Copilot in Excel: Prompt It,
Then Prove It

An organization wanted staff using Copilot in Excel. The real risk wasn't getting an answer; it was trusting a wrong one. I designed a 6-lesson course where every skill ends with a check, then prototyped it in two Articulate formats so the client could compare before development.

AI Literacy Simulated Practice Knowledge Checks Articulate Rise Articulate Storyline Rapid Prototyping AI Authoring
Role Instructional Designer: learning design, practice activities, assessment, prototypes
Audience Staff who build budgets and reports in Excel
Format 6 lessons, prototyped as a Rise course (about 50 min) and a Storyline course (about 35 min)
Tools Claude and Claude Code (rapid prototypes), Articulate Rise 360 and Storyline 360 (build)
01

The Challenge

Copilot can write a formula or summarize a table in seconds. In a budget or a shared report, a confident wrong answer costs more than the time Copilot saves.

The Ask

Teach staff to use Copilot in Excel for formulas, data cleanup, analysis, and charts.

The Real Goal

Build a verification habit: prompt it, then prove it, every time, before a result is shared.

02

Two Prototypes, One Course

Before building anything in Articulate, I prototyped the same six lessons in both formats. The client could click through each one and choose the experience that fit their learners, before any development time was spent.

Articulate Rise prototype
  • Scrolling lessons with a course menu
  • Select-a-prompt practice in a sample workbook
  • Maria's scenarios and a find-the-mistake check
  • Wrap-up with a 10-question final (80% to pass)
  • About 50 minutes
Open the Rise prototype →
Articulate Storyline prototype
  • Slide-based with a seek bar and menu
  • Type or select prompts in a simulated Copilot pane
  • Drag-and-drop sorting and a hotspot tour
  • Knowledge check at the end of every lesson
  • About 35 minutes
Open the Storyline prototype →

A Third Take: AI Authoring Experiment

I also rebuilt the course in Mindsmith, an AI course-authoring tool, starting from my own outline, to test how far an AI authoring tool can take a well-designed course. The result is an 8-section lesson with a timed "one-minute decision" scenario, tabs comparing Copilot's chat, plan, and edit modes, and a closing activity where learners write the prompt and the verify check they'll use this week.

Try the Mindsmith version The same course, generated with AI from my outline and refined in Mindsmith.
→
03

Design Decisions

Learners practice the judgment, not just the prompts. Both formats share these decisions.

◎

One method, repeated

"Prove it" checks follow the practice in both versions, such as reading the formula Copilot wrote in the formula bar or checking one row by hand.

Why: Repeating one habit in different tasks is what makes it automatic.
◎

Practice in a simulated workbook

Every example uses one fictional budget workbook. Learners run a prompt and see exactly what Copilot adds or changes.

Why: Safe practice with no license, no real data, and no risk of breaking a file.
◎

Make choices, not just clicks

Rise learners find the mistake in a plausible Copilot answer. Storyline learners match prompts to tasks, choose the right chart, and sort strong prompts from weak ones.

Why: Choosing between options builds the judgment that a prompt list alone can't.
◎

Decide how much Copilot can change

Learners choose which Copilot mode fits each task, through Maria's scenarios in Rise and a matching activity in Storyline, then review a plan before a multi-step build.

Why: Matching control to risk is the judgment call the job actually requires.
04

Course Map

The same six lessons in both formats, each with hands-on practice and a knowledge check. The Rise version adds a wrap-up and final assessment.

Lesson 1

Prompt for Formulas

Tour the workspace, write and explain formulas, and troubleshoot errors.

Lesson 2

Organize Your Data

Highlight, sort, filter, format, and clean data with prompts.

Lesson 3

Analyze Your Data

Ask questions of the data, then refine the answer with follow-up questions.

Lesson 4

Visualize Your Results

Choose the right chart, then build charts for reports.

Lesson 5

Build Multi-Step Workbooks

Choose between chat, plan, and edit modes, then practice a multi-step build.

Lesson 6

Copilot in Excel Best Practices

Five habits that keep results accurate and data secure, then key takeaways.

05

Explore the Prototypes

The Rise and Storyline versions are rapid prototypes for client review before development in Articulate, built with Claude Code for a fictional company, Acme Financial. The Mindsmith version is my AI authoring experiment.

Rise prototype Scroll through the lessons, try the sample workbook prompts, and help Maria choose the right Copilot mode.
→
Storyline prototype Type prompts in the simulated Copilot pane, answer each Prove it question, and drag tasks to the right mode.
→
Mindsmith version An AI-authored take on the course: make the one-minute decision, compare Copilot's modes, and write your first prompt.
→

AI use disclosure

I designed the course, the practice activities, and the assessment, and reviewed every lesson. I used AI (Claude and Claude Code) as a build partner to turn the design into two clickable prototypes, one styled like Rise and one like Storyline, for client review. Separately, I tested Mindsmith, an AI course-authoring tool, by generating a version of the course from my outline and refining it.

Rolling out AI tools to your team?

I'd love to help your people use them well, and know when to double-check.

Let's talk