Skip to content
Edition NigeriaGlobal
Country

You are in the Nigeria edition. Type your country to switch.

Set up your 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.

Beginner10 min read5 steps

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

Up next

English