Skip to content
Humanopia
Practical Guides

AI for spreadsheets: formulas, cleanup and charts

Let AI write the formula. Then check it.

vinznsk · Jul 31, 2026 · 2 min read

Save prompts that work well. Over time you will build a small library you can reuse, which is where most of the time savings come from.

The quality of the answer depends on the quality of the question. Tell the assistant who the result is for, what format you want and what it should avoid.

Step 2: Give the AI good context

Once you are comfortable, try connecting the assistant to the tools you already use, such as your documents, calendar or spreadsheets. Start with read-only access.

  • A free or paid account with one assistant
  • A real task, not a test question
  • A source you trust to check facts
  • Twenty minutes without interruptions
  • A place to save prompts that work

Step 4: Refine and repeat

In our testing, the biggest gains came from first drafts, summaries and reformatting. The smallest came from tasks that need fresh judgement or deep expertise.

  1. Describe the goal in one sentence
  2. Add context: audience, format and length
  3. Ask for a first draft
  4. Check facts and tone
  5. Ask for specific changes
  6. Save the prompt for next time

Treat the assistant like a talented intern: fast, eager, and in need of clear instructions and a careful review.

Humanopia testing notes

Measure the result honestly. Note how long the task took before and after. If AI does not save time or improve quality, it is fine to stop using it for that task.

Next steps

Keep anything sensitive out of your prompts unless you have checked the privacy settings of the tool, and your organisation allows it.

If the first answer is not right, do not start over. Tell the assistant what to change, one thing at a time. Small corrections work better than long new instructions.

At a glance

QuestionShort answer
Who is affected?Most everyday users, gradually
Does it cost more?Not for now
What should I do?Try it on a low-stakes task first

Step 1: Set a clear goal

You do not need to be technical to follow this guide. You need a free account with one of the major assistants, a real task you want to get done, and about twenty minutes.

Start with a task you already understand well. That way you can tell quickly whether the AI is helping or just producing confident-sounding text.

Stay ahead without
living inside the feed.

Get our weekly newsletter with the most important AI news, practical guides and thought-provoking essays, curated for curious, forward-thinking people.

Weekly, not daily Curated and practical No spam, ever