Country
You are in the Nigeria edition. Type your country to switch.
Nigeria
Loading every country…
No country matches. Check the spelling, or choose "Any country" for the Global edition.
Your learning profile
AI for work: productivity, workflows and judgement · Lesson 5 of 10
Spreadsheets and analysis help
Assistants can write and explain spreadsheet formulas if you describe the sheet clearly. This lesson shows how to describe your layout in a prompt, how to test a formula on rows you can check by hand, and a worked sales sheet where the totals and percentages add up.
This lesson is complete in writing. A video for it is on its way.
What you will learn
- By the end you can describe a spreadsheet's layout in a prompt so the formula you get fits your sheet.
- You can ask for a plain explanation of any formula before you use it.
- You can test a formula on rows you can check by hand.
- You can check that totals and percentages in a summary reconcile.
- You can use spot checks to catch common spreadsheet errors.
Key terms in this lesson
- Spot check
- A quick manual check of a few items, chosen deliberately, to catch errors in a larger output such as a spreadsheet column or a long list.
- Missing value
- A blank in a dataset where a figure should be. It is not the same as zero.
- Step 1: Describe the sheet before you ask, not started
- Step 2: Ask for the explanation, not just the answer, not started
- Step 3: Test on rows you can check by hand, not started
- Step 4: Worked example: a sales summary that adds up, not started
- Step 5: Spot checks for any analysis, not started
About 8 min of reading
Step 1 of 5
Describe the sheet before you ask
Opening this step…
Step 2 of 5
Ask for the explanation, not just the answer
This step opens when you finish the one above.
Step 3 of 5
Test on rows you can check by hand
This step opens when you finish the one above.
Step 4 of 5
Worked example: a sales summary that adds up
This step opens when you finish the one above.
Step 5 of 5
Spot checks for any analysis
This step opens when you finish the one above.
Key takeaways
The key takeaways open when you finish every step.
Lesson quiz
5 questions. You need 85% to pass.
The quiz opens when you finish every step.
Read first
Stockertim Learn is education. It explains how investing works and never recommends buying or selling anything.
Popular this week: Basics: BeginnerStock market: Intermediate