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.
=C2/SUM($C$2:$C$5) and formatted it as a percentage.
| Course | Children | Fees | Share |
|---|---|---|---|
| Art | 24 | 36,000 | 28.4% |
| Sport | 31 | 37,200 | 29.4% |
| Computers | 18 | 32,400 | 25.6% |
| Music | 15 | 21,000 | 16.6% |
- 1Open Copilot: the icon at the bottom right of Excel
- 2Ask in plain words: what, which table, which form
- 3Copilot plans, then edits the sheet while you watch
- 4Read the formula it wrote, not only the result
- 5Check it: shares add up to 100%; one row by hand
- ✓No Copilot? Ask the free Copilot on the web, paste, check