Using AI for everyday work: emails, documents, and spreadsheets
Using AI for everyday work pays off on tasks you do often and can check quickly: drafting emails, summarizing documents and long threads, building spreadsheet formulas, and keeping a project’s files and instructions in one place. The assistants built into Gmail, Outlook, Excel, and Google Sheets handle much of this where you already work, and as of November 10, 2026, every company behind them asks you to check the results.
Getting everyday work done with AI
The quickest gains from AI in a small business come from tasks you repeat every day and can check in a minute or two. This guide is part of putting AI to work in a small team and covers six of them, from writing a prompt to checking the answer, based on the companies’ help pages read on November 10, 2026. Google’s guide to writing effective prompts sums up the spirit of all of them: the output is a draft, and the final version is yours.
The pattern is the same whatever the tool. Give the assistant the facts it cannot know, tell it what the result should look like, read what comes back, and correct it. The US Small Business Administration advises having another person review what free AI tools produce, and Canada’s Cyber Centre asks you to verify AI content before acting on it.
Which task, which tool, which check
| Task | Start here | Check before using |
|---|---|---|
| Draft or reply to an email | Help me write in Gmail, Copilot in Outlook | Facts it added, promises, tone |
| Catch up on a long thread | AI Overview in Gmail, Summary by Copilot in Outlook | One citation for each point you act on |
| Summarize a PDF or a report | A chat with the file attached; a notebook such as Gemini Notebook for several files | Numbers, dates, and names against the original |
| Formulas, cleanup, a monthly table | Copilot in Excel, Gemini in Google Sheets, or an add-in | Three rows by hand and one total rebuilt |
| Repeated work on the same files | A project in ChatGPT, Claude, or Perplexity | Who can open it |
| Facts or figures for a report | An assistant with web search and citations | Every source, opened |
This table is our recommendation. It follows one rule: start with the tool built into the software you already use, and keep a check that takes less time than doing the task yourself. Where checking would take longer, as with a final legal answer or a figure you will quote in public, the AI is a starting point for your own research, not a shortcut.
What changed in 2026
Several habits from 2025 no longer work as they did:
- Excel lost its AI formula. Microsoft retired the COPILOT function on September 14, 2026; workbooks that used it show #NAME? when they recalculate.
- Copilot in Excel edits by default. What Microsoft first called Agent Mode is now the default edit mode, with a plan mode if you want to approve the steps first.
- Custom GPTs and Gems are ending. OpenAI no longer lets personal accounts create GPTs and retires them on December 11, 2026; Google’s Gems on personal accounts become read-only on November 17, 2026 and are removed on December 17.
- Copilot, Gemini, ChatGPT, and Claude all work inside spreadsheets, ChatGPT’s add-in even on its free plan, with limited use.
The prompt does most of the work
The four companies publish different frameworks but agree on the core: a task with a verb, context, a format, and a second message to correct course. Our page on writing prompts that work compares their advice and gives a template to copy.
Emails that still sound like you
Gmail’s Help me write is free on personal accounts only in the US; in the UK, Canada, and Australia, it needs a paid plan. See drafting emails with AI for what each mailbox offers and five ways to keep your own voice.
Summaries you can rely on
Attaching a file, using a notebook limited to your sources, and the summary built into your mailbox each suit a different job, and Microsoft warns that Copilot may read only the start of a long document. See summarizing PDFs and long documents.
Spreadsheets without broken formulas
Copilot, Gemini, ChatGPT, and Claude all work inside Excel or Google Sheets, on different plans and with different limits. Our page on AI in Excel and Google Sheets sets them side by side, with a five-step routine before you trust a formula.
Projects, GPTs, and the December deadline
If your team relies on a custom GPT or a Gem, now is the time to move it. See projects, custom GPTs, and what replaces them, with a checklist for the move.
Checking the answers
AI assistants state wrong facts as calmly as right ones, and courts and tribunals in four countries have already dealt with the results, including a Canadian tribunal that held an airline responsible for its chatbot. The method fits in three habits: give the assistant your documents, ask for a source for each claim and open it, and redo the figures and references from the original. Our page on catching AI mistakes and hallucinations explains why errors happen and gives eight steps to check.
Beyond everyday tasks
The same habits carry over to taking notes with AI and to letting AI handle routine tasks, the next steps in this series. The other guides cover choosing an AI assistant, comparing AI plans and prices, and the rules for using AI at work.