AI for Spreadsheets: Formulas, Cleanup and Analysis
How to use AI with Excel and Google Sheets: writing and explaining formulas, cleaning messy data, summarising tables and checking results, with prompts to copy.
How to write better emails with AI: drafting, replying, fixing tone and summarising threads, with prompts and the privacy and accuracy checks that matter.

Email is where AI saves many people the most time. It can turn three scribbled bullet points into a polite reply, soften a message you wrote in frustration, shorten a rambling update and summarise a thread you’ve been copied into forty messages late. The trick is to use it as an editor and drafting partner, not an autopilot.
Many email apps now include AI writing and summary features, and you can also use a general chatbot by pasting in the text. For CVs and cover letters, see our guide to AI for job search.
A vague request produces a generic email. Tell the AI:
Our prompt engineering guide explains why this structure works.
Write a short email to [recipient, relationship].
Goal: [what I want them to do].
Include: [facts, dates, links].
Tone: friendly and professional. Under 150 words.
Use plain English and a clear subject line.
Here is an email I received. Draft a reply that answers
each question in order, confirms [decision], and asks
[question]. Keep it concise. Don't promise anything
I haven't mentioned.
Rewrite this email to sound calm and constructive rather
than annoyed. Keep all the facts and the request. Keep it
about the same length.
Summarise this email thread in five bullet points. Then list
decisions made, open questions, and who needs to do what.
For campaign and newsletter copy, see our prompt templates for marketing teams.
AI emails can sound oddly formal, over-enthusiastic or padded with phrases nobody uses in real life. To keep your voice:
Emails often contain personal data about you and others. In consumer tools, switch off training on your chats and remove unnecessary names, account numbers and addresses before pasting; our AI privacy settings guide shows how. At work, use the tools your employer approves.
The same tools that polish your emails make phishing emails more convincing, with fewer of the spelling mistakes people used to rely on. Be wary of urgent requests for payment, passwords or gift cards, check the sender’s real address and verify requests through a separate channel. Scammers also clone voices; see how to protect yourself from voice cloning.
Once you find prompts that work, save them. Keep a note with your best templates, a short description of your writing style and standard facts such as your address, opening hours or project details. Many chatbots let you store custom instructions, so every draft starts with your preferences. For emails you send often, such as meeting requests, polite reminders or invoice follow-ups, keep an edited AI draft as a template and adapt it rather than generating from scratch each time.
There’s no general rule that you must say an email was drafted with AI, but you are responsible for what you send. Some workplaces and professions have their own policies, so follow them.
Usually, if your employer allows it, you don’t share confidential information in unapproved tools and you check every email before sending.
Give examples of your own writing, ask for plain and direct language, and edit the draft so it sounds like you.
Many email apps offer summaries of threads or messages. Treat them as a quick guide and read the original for anything important.
Every article is edited by a human and checked against our editorial policy. Spotted a mistake? Tell us.
How to use AI with Excel and Google Sheets: writing and explaining formulas, cleaning messy data, summarising tables and checking results, with prompts to copy.
How to use AI to summarise PDFs, reports and contracts accurately: prompts, checking for missed or invented details, privacy settings and what to never upload.
How AI coding assistants work, from autocomplete to coding agents, what they do well, the security and quality risks, and habits for reliable code.