Draft a spreadsheet formula in plain language
Works with ChatGPT · Claude · Copilot
Describe what you want and get the right spreadsheet formula.
The problem
People know the result they want but not the formula syntax.
What this skill does
AI turns a plain-language goal into a formula with an explanation.
When to use it
- Use when you're stuck writing a spreadsheet formula.
Juni’s tip
Juni says: understand the formula once and you'll reuse it forever.
The prompt
Try it live
Fill in the blanks — your ready-to-use prompt builds as you type.
Weak vs. better
write me a formula
I want to [goal] using columns [list]. Give the formula for Excel/Google Sheets, explain each part in plain language, and note one common error to avoid. Tell me which cell to put it in.
Why this works
Explaining each part of the formula means you can adapt it next time, not just paste it.
Practice task
Describe a calculation you need and get the formula plus explanation.
Self-check
- Gives a working formula for your tool
- Explains each part in plain language
- Notes a common mistake to avoid
Common mistakes to avoid
- Pasting a formula with no explanation
- Ignoring which tool (Excel vs Sheets)
- Not saying where the formula goes
You’re learning fast. Create a free account to continue your path.
Save your skills, keep your prompts, and continue building your AI skills one step at a time.
