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 guide17 min
Getting good results from AI coding assistants
Give context, work in small steps, verify with tests — a workflow that makes AI-written code something you can trust.
PracticalDevelopers
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
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 guide14 min
Find insights in campaign results
Do the maths in your spreadsheet and the interpreting with AI. Turn campaign results into insights written as observation, hypothesis and how to check, then pick your next experiment.
PracticalMarketers
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
Keep a character or product consistent across scenes
Pin down what must never change in a character sheet, then use a fixed block and reference images to keep the same look in every scene.
PracticalDesignersMarketers
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
How-to guide15 min
Get structured (JSON) output from an LLM
Instead of asking for JSON and hoping, define the shape as a schema and get responses your code can use directly. Worked through with a customer-message classifier.
PracticalDevelopers
How-to guide15 min
Cut API costs with prompt caching
Cache the long instructions and documents you resend with every request, and their input cost drops sharply. Using a support bot built on a manual, here's how to place the cache point and check that it works.
PracticalDevelopers
How-to guide18 min
A minimal RAG chatbot with ten documents
Build a Python chatbot that searches ten internal policy documents with embeddings and answers only from what it finds, then test search and answers separately and fix what breaks.
PracticalDevelopers