Tame
the Spreadsheet

Spreadsheets can feel like a foreign language — rows, columns, formulas, and functions that nobody explains.

In this Beacon, you'll use AI to do the tricky parts for you. No programming knowledge needed. No prior spreadsheet experience required.

By the end, you'll know how to:

• Ask AI to write a formula — and understand what it actually does
• Sort and filter data without guessing
• Fix errors with a little help from your AI assistant

A spreadsheet is just a big grid. Each box is called a cell. You can put words, numbers, or dates in a cell — and then ask the spreadsheet to do math or organize things for you.

The magic happens when you write a formula — a small instruction that tells the spreadsheet what to calculate.

The problem? Formulas have their own syntax. Even a tiny typo breaks them.

That's exactly where AI comes in.

You don't need to memorize formula syntax. Just describe what you want in plain English — and ask your AI chatbot to write it for you.

For example, imagine you have a list of expenses in column B, from row 2 to row 10. You want to add them all up.

You could ask:

"I have numbers in cells B2 to B10 in Google Sheets. Write me a formula that adds them all together."

Your AI chatbot will give you something like:

=SUM(B2:B10)

You just paste that into your spreadsheet. Done.

The AI didn't just give you the formula — it saved you from having to search for it, read documentation, or guess.

Here's a habit worth building: whenever AI gives you a formula, ask it to explain what it does.

Just say: "Can you explain what this formula does, step by step?"

This is how you go from copy-pasting to actually understanding. You don't need to memorize anything — but seeing the explanation once makes it stick.

AI is patient. It will never make you feel silly for asking.

Open Google Sheets (https://sheets.google.com) and create a new blank spreadsheet.

In column A, type these labels in cells A1 to A5:

Rent, Groceries, Transport, Internet, Coffee

In column B, type these amounts next to them (one per row):

850, 230, 60, 25, 40

You now have a simple monthly expense list.

Open your favorite AI chatbot — ChatGPT (chatgpt.com), Claude (claude.ai), or Gemini (gemini.google.com) — and paste in this ready-made prompt:

Copy the formula your AI chatbot gives you. Click on cell B6 in your spreadsheet and paste it in. Press Enter.

You should see the total: 1205

Now open a different AI chatbot — whichever one you didn't use in Step 2 — and try this prompt:

Paste the formula into cell B7.

You should see 850 — the highest single expense (Rent).

Notice anything? Both chatbots understood your request and gave you a working formula. That's the point — you're not locked into one tool.

Look at the formula your AI chatbot gave you — and notice how different it looks from what you typed in the cells above.

Yet it's doing exactly what you described in plain English.

The aha moment: you didn't write code. You described what you wanted — and the AI translated it. That's the whole skill.

What if the formula shows an error?

Don't panic — errors like #VALUE! or #REF! are common. Just copy the formula and the error message, and paste them into your AI chatbot. Say: "This formula isn't working. What's wrong?" It'll fix it for you.

Google Sheets vs Excel

The formulas are almost identical. If you use Excel, just mention it when you ask AI — it will adjust automatically.

You don't have to understand everything

It's completely fine to use a formula without fully understanding it. The important thing is that it works — and that you know who to ask when it doesn't.

You just used your AI chatbot to write and explain spreadsheet formulas — without touching a single manual or tutorial.

That's a genuinely useful skill. Spreadsheets will never feel quite as intimidating again.

Up next: Beacon 22 – Plan like a pro

You'll use AI to help you build a simple project plan — tasks, deadlines, and priorities — without any special software.