How-to guide12 min
Write spreadsheet formulas with AI: describe it, get the formula
You don't need to know function names. Describe your table and the result you want, and a chat assistant writes the formula.
BeginnerOffice workersMarketers
Learn
Practical AI guides and plain-language explainers. Filter by role and level.
All guides
Type
Role
Level
How-to guide10 min
Five principles for better prompts
Role, context, task, format and an example — five things that noticeably change what AI gives back.
BeginnerBeginnersOffice workersMarketers
How-to guide8 min
Using AI at work safely: personal data and confidential information
What not to paste into AI, how to swap in fake values when you must, and what to check before you start.
BeginnerOffice workersBeginners
How-to guide9 min
Get a three-line summary of a long report
Tell the assistant who will read it and what shape the three lines should take, and a long report comes back as a summary you can pass straight on. This guide also shows how to check its figures against the original.
BeginnerOffice workersBeginners
How-to guide10 min
Write work emails in the right tone: requests, apologies, refusals
Tell the assistant who you're writing to, what you need, by when and in what tone, and it drafts an email that fits. Worked examples for requests, apologies and refusals, plus what to check before you send.
BeginnerOffice workersBeginners
How-to guide10 min
Turn meeting notes into action items
Get meeting notes sorted into decisions, open items and action items, without the assistant guessing owners or deadlines, and confirmed by the people who were there.
BeginnerOffice workers
How-to guide12 min
Let AI do the totals instead of a pivot table
You don't need to know the PivotTable menus: describe the rows, columns and values, and the assistant writes the formula. The numbers come from the sheet or from code, never from the chat, and you check them against the source.
PracticalOffice workersMarketers
How-to guide12 min
AI drafts, people finish: a blog workflow
A blog workflow where AI handles the outline and first draft, and people handle the plan, the fact-checking, the real experience and the final check.
BeginnerMarketersOffice workers