L191 · AI at work · 3 min
Excel formulas with AI
Describe what you want the cell to do in plain words, and a chatbot can write the formula and explain it line by line.
01 · The idea
Most people know what they want from a spreadsheet and get stuck on the syntax. "Add up sales for Hanoi in March" is easy to say and fiddly to type as a formula.
A chatbot is good at this translation. Tell it which columns hold what, which row the data starts on, and what result you expect. It will usually suggest a formula such as SUMIFS or XLOOKUP and explain each part.
Always test the formula on a few rows where you already know the answer. Formulas can fail without any warning: a wrong range or a stray space in a name gives a number that looks fine and is wrong.
Ask for the explanation as well as the formula. After a few weeks you will start writing simple ones yourself, and you will spot the AI's mistakes faster.
02 · Think of it like this
It is like asking a colleague who knows Excel well. You explain the goal, they type the formula, and you check the answer against a total you already trust.
03 · Do it now
04 · Quick check
Words in this lesson
See also
L175AI at work · 3 min
Branching scenarios for training
A branching scenario is a short story where each choice leads to a different next scene, and AI makes these quick to draft for staff or student training.
L209AI at work · 3 min
A bilingual CV
Write your CV once with strong facts, then use AI to make a natural version in the second language and check the job titles carefully.
L157AI at work · 2 min
Making slides with AI
AI can turn your notes into a first slide deck in minutes, and your job is to bring the message, the real numbers and the cuts.
L225AI at work · 3 min
Writing a decision memo
A one-page decision memo states the question, the options, the trade-offs and your recommendation, so others can decide quickly.