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 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