Free demo · Microsoft Excel · Lesson 9 · Copilot AI

Ask Copilot for a formula, then check it

Describe what you need in plain words and Copilot writes the formula into your sheet. Your job is the important one: make sure the numbers are right.

CopilotAllow editing
In the Fees table, add a column that shows each course's share of the total fees as a percentage
Reading the table Fees · planning 2 steps
I added Share in column D with =C2/SUM($C$2:$C$5) and formatted it as a percentage.
CourseChildrenFeesShare
Art2436,00028.4%
Sport3137,20029.4%
Computers1832,40025.6%
Music1521,00016.6%
UndoExplain the formula
Describe what you'd like to do, or type / to add a fileAuto➤
  1. 1Open Copilot: the icon at the bottom right of Excel
  2. 2Ask in plain words: what, which table, which form
  3. 3Copilot plans, then edits the sheet while you watch
  4. 4Read the formula it wrote, not only the result
  5. 5Check it: shares add up to 100%; one row by hand
  6. ✓No Copilot? Ask the free Copilot on the web, paste, check
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

Copilot is Microsoft's AI assistant. In Excel for Microsoft 365 the Copilot icon in the bottom-right corner opens a chat pane where you describe what you need in plain words: a formula column, formatting, a chart, a PivotTable or an answer about the data. In Allow editing mode Copilot makes a step-by-step plan and changes the workbook while you watch; Plan mode shows the plan first, and Chat only answers without changing anything. Copilot inside Excel needs a Microsoft 365 Copilot licence or a Microsoft 365 Personal, Family or Premium subscription; Office 2024 does not include it, so the course always shows a free route: ask the free Copilot on the web, paste the formula into your sheet and test it. AI can be confidently wrong, which is why every level of the full course teaches the same habit: read the formula, check one row by hand, and never hand in a number you did not verify. The full course goes on to cleaning messy lists, lookups and PivotTables by asking, month-end reports and macros written with AI, each with a Copilot lab assignment.

Key points

  • Ask in plain words: what you want, which table, which form
  • Read the formula Copilot wrote, then check one row by hand
  • No Copilot licence? The free route works too