Lesson 4 of 5 · 6 min

Presentations and Spreadsheets

Plan a slide outline around one clear message, get Excel or Google Sheets formulas explained simply, and turn numbers into plain words.

In this lesson

  • Plan a short presentation as a story with one main message
  • Describe a table so AI writes and explains the right formula
  • Use AI to explain numbers while the spreadsheet does the maths

Slides: start with the story

A strong presentation is a short story with one clear point, not a pile of slides. Before you open any slide software, use your assistant to plan that story. Tell it who the audience is, how much time you have and the one thing people should remember.

Before: “Make a presentation about our results.”

After: “I have ten minutes to present last quarter’s results to the management team. Main message: sales grew, but costs grew faster, so we need to review two suppliers. Give me a six-slide outline with a title and three short bullet points per slide, plus one sentence of speaker notes for each.”

You can then build the slides yourself, or paste the outline into a tool that turns text into slides, such as Gamma or Canva. Either way, keep the words on each slide short. Ask the assistant: “Which slide has too much text? Make it shorter.” It can also play a difficult listener: “What three tough questions might managers ask after this talk?”

Spreadsheet formulas in plain words

Many people lose hours searching online for the right formula. An AI assistant can write formulas for Excel or Google Sheets and, just as importantly, explain them. Describe your table, not only the result you want:

“Column A has dates, column B has the region and column C has the sales amount. I want the total sales for the North region in cell F2. Write a formula for Google Sheets and explain each part simply.”

A typical answer is =SUMIF(B:B,”North”,C:C), with an explanation like this: look down column B, find every row that says North, and add up the matching amounts from column C.

If a formula shows an error, paste the formula, the exact error message and a short description of each column, then ask: “Why does this fail, and how do I fix it?” Always test a new formula on a few rows where you already know the correct answer. AI sometimes gets column letters wrong, and in many countries spreadsheets use a semicolon instead of a comma between the parts of a formula.

Explaining numbers to other people

Numbers only help when people understand them. Paste a small table, with confidential figures removed or rounded, and ask: “Explain what these numbers show in four simple sentences for a manager who has two minutes.” You can also ask for the main trend, the biggest change and one possible reason, clearly labelled as a guess rather than a fact.

Be careful at this step. AI can make calculation mistakes, especially with percentages and long tables. A good rule is to let the spreadsheet do the maths and let the AI do the explaining. If the assistant gives you a number it calculated, check it with a formula before you put it on a slide.

A quick routine to remember

  • Plan the story first, then build the slides.
  • Describe your columns when you ask for a formula.
  • Test every formula on rows you can check by hand.
  • Let the spreadsheet calculate and the AI explain.

With this routine, a task that used to take an afternoon, such as preparing a monthly update with a few charts and a short talk, can often be done in an hour, and the result is usually clearer for your audience too.

Practice

Copy this prompt into your usual chat assistant and swap each [BRACKETS] part for details of your own sheet. Describe your columns in words; you do not need to paste real data.

Prompt
I use [SPREADSHEET_APP]. My table looks like this: [TABLE_DESCRIPTION]. I want to [GOAL]. Write the formula I need, tell me which cell to put it in, and explain each part in simple words as if I have never used formulas. Then give me one quick way to test that the result is correct.
[SPREADSHEET_APP]
e.g. Excel, Google Sheets
[TABLE_DESCRIPTION]
e.g. column A is the order date, column B is the product, column C is the status (Paid or Unpaid), rows 2 to 200
[GOAL]
e.g. count how many orders are still unpaid
See an example result

Formula (put it in an empty cell, for example E2):
=COUNTIF(C2:C200,"Unpaid")

What each part means:
– COUNTIF counts the cells that match a rule.
– C2:C200 is the area to look at: the status column, from row 2 to row 200.
– "Unpaid" is the rule: only count cells that contain exactly the word Unpaid.

Quick test:
Click on column C and use the filter to show only "Unpaid". Look at the number of rows shown at the bottom of the screen. It should match the result in E2.

Note: if your spreadsheet uses a semicolon between parts, write =COUNTIF(C2:C200;"Unpaid").

What to notice: The explanation is short and links every part of the formula to your own columns, so you can change it later yourself. The test gives you a second way to reach the same answer, which is the best protection against a wrong formula.

Key takeaways

  • One main message makes a better presentation
  • Describe your columns to get the right formula
  • Spreadsheet calculates, AI explains, you check