Lesson 1 of 7
Talk to your spreadsheet
6 min read
You know what you want — the total of a column, the biggest number, the average. But you can't remember the formula. What if you could just say it out loud?
Describe the result, not the formula
A formula is just an instruction to the spreadsheet: add these up, find the biggest, pull out the year. The hard part was always the exact syntax — the =, the brackets, the cell names. AI flips that around. You describe the result you want in plain English, and it writes the formula into the cell for you. You read the answer; it handles the punctuation.
You don't need to memorise =SUM or =AVERAGE. Say what you want from the column, and AI writes the formula that gets it.
It explains as well as writes
The same trick works in reverse. Land on a cell full of =VLOOKUP(...) that someone else wrote and can't tell what it does? Ask AI to explain it in plain words. So formulas stop being a wall of syntax — you can write them by describing, and read them by asking.
AI writes the formula; you still own the result. Glance at the cells it points to — a formula that sums the wrong range looks just as confident as a right one.
The shape of it
- —Describe the result you want; AI writes the spreadsheet formula for you.
- —It works both ways — write a formula from words, or explain one back in words.
- —You skip the syntax, not the sanity check — glance at the range it used.
You've got a column of monthly costs and want the total, but can't recall the formula. What's the fastest way with AI?
Continue in the app
Take the whole AI for Spreadsheets course — tracked
Get your personalized path, progress and streaks in the app — this lesson and every next one, in order.