Skip to content
Edition NigeriaGlobal
Country: Mexico

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

The Americas

Set up your profile

You are learning in the Mexico edition, with examples in pesos and from Mexico.

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