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 guide14 min
Image prompt basics for designers
Just ordering your prompt as subject, style, composition and light makes a difference. Here's how to write prompts that multiply your concepts fast.
BeginnerDesignersMarketers
How-to guide12 min
Draft A/B ad copy with AI
Give it the product, audience and channel, and you'll have copy from several different angles in minutes.
BeginnerMarketers
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
Define and test three customer personas
Turn a summary of your reviews, support tickets and surveys into three personas with AI, separate evidence from assumptions, and test the assumptions before you spend money on them.
BeginnerMarketers
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
How-to guide12 min
Make a mood board in ten minutes
Turn a short brief into visual keywords, nine images in one consistent style and a five-color palette, then lay them out as a one-page mood board.
BeginnerDesignersMarketers
How-to guide14 min
Your first LLM API call: from key to response
Using the Claude API as the example: keep your API key safe, send a first request from Python, and read the answer, the stop reason and the token usage.
BeginnerDevelopers