How to get real work out of Microsoft Copilot

Most businesses that try Copilot land in one of two camps. One group uses it a few times, gets a bland paragraph back, and decides it’s a toy. The other group gets hours back every week. In our experience the difference is rarely the license. It’s a handful of habits: how they ask, what they point Copilot at, and which jobs they hand it every day.

This guide covers those habits. Everything here works in the free Copilot Chat unless we say it needs a paid seat (a paid Copilot seat, Microsoft Copilot Business, for that person).

Why short prompts get weak answers

People type into Copilot the way they type into a search box: “marketing email.” A search engine can work with that. An AI assistant can’t. It doesn’t know who you are, who the email is for, what you’re selling or what a good result looks like to you. So it guesses, and the result reads like a guess.

Think of Copilot as a capable new hire on their first day. They can write, summarize and analyze well, but they know nothing about your business until you tell them or show them the files.

The four parts of a good prompt

Microsoft’s own guidance breaks a good prompt (the request you type) into four parts. Only the first is required, but each one you add means one less thing Copilot has to guess:

Here’s the difference in practice:

The second prompt takes a little longer to write. In our experience it saves several rounds of editing.

Give Copilot the right files

Copilot is only as good as what it’s working from. How you give it files and notes depends on your license:

• Free Copilot Chat: paste text or upload the file (Word, PDF, Excel, PowerPoint, images) right into the chat. In Outlook, Copilot Chat can also work with your own inbox and calendar.
• Paid seat: Copilot can search your email, meetings, chats and files for you. Name what you mean, such as “the Henderson proposal from March” or “my emails with Dana this week”, or type / in the chat box to pick a specific file, email or meeting.

Improve answers with follow-ups

Treat the first answer as a draft. The people who get the most out of Copilot reply to it the way they’d coach an assistant:

• “Shorter, and move the price to the first line.”
• “Too formal. These are homeowners, not procurement officers.”
• “Put that in a table with columns for customer, amount and days overdue.”
• “What did you assume that I didn’t tell you?”

For bigger jobs, flip it around and have Copilot ask you questions first:

When a task needs real reasoning, like comparing three vendor proposals, switch the response mode to Think deeper. It takes longer and is noticeably more careful.

Five daily routines, with prompts you can copy

Copilot pays off when you use it every day, not only when you remember it on a slow afternoon. These five cover most of an owner’s or office manager’s week. For more, see 23 Copilot prompts for small business.

1. Morning inbox catch-up (Outlook)

Works with Copilot Chat in Outlook, even on the free tier.

2. Meeting to action items (Teams, paid seat)

This only works if the Teams meeting was recorded or transcribed. For phone or in-person meetings, paste your notes or a transcript into Copilot Chat and use the same prompt.

3. Replies that sound like you

4. Spreadsheet questions in plain English (Excel)

With a paid seat, the Analyst agent (a ready-made Copilot assistant for data analysis) handles messier data and bigger questions than Copilot in Excel alone.

5. Notes into a finished document (Word)

Typing / to pick a file needs a paid seat. Without one, attach the template with the + button instead.

Set up your files so Copilot can find them

With a paid seat, Copilot searches your files, so its answers are only as good as those files are organized. A few hours of tidying up pays back quickly:

• Get files into OneDrive and SharePoint. Copilot can’t see Dropbox, Google Drive, a USB stick or the desktop of the office PC.
• Name files so a stranger could find them. “2026-03 Henderson kitchen estimate” beats “Estimate FINAL v3.”
• Retire old versions. If last year’s price list sits next to this year’s, Copilot may quote the wrong one. Archive what’s out of date.
• Fix who can open what. Copilot shows each person only the files they can already open. If those permissions are set right, that protects you. If the “Everyone” group can open the HR folder, Copilot will show HR files to everyone.

Check Copilot’s answers

Copilot can sound sure of itself and still be wrong. Microsoft’s own advice is to review and check what it gives you, and it’s good advice. A few rules we follow:

• Numbers, dates, names and prices: always check against the source. When an answer comes from your files, Copilot shows references to them. Click them to check.
• Anything legal, tax or safety-related: use Copilot to draft and research, and have the right person sign off.
• Anything going to a customer: read it once as the customer would.
• Same question, different answer: that’s normal. If the answer matters, ask Copilot to show its sources or explain how it got there.

Save what works, then turn it into an agent

When a prompt gets you a great result, save it. Keep a shared “prompt library” document in SharePoint with the prompts your team reuses, organized by job: quoting, customer replies, scheduling, reporting.

Once you notice that the same long prompt, pointed at the same files, is being used every day, that’s your sign to build an agent: a version of Copilot that already has your instructions and files built in. Then anyone on the team gets the same quality answer from a one-line question. That’s the next guide:How to build a Copilot agent for your business.

Ready for more than chat? The five levels of Copilot shows the next steps, from the paid seat to agents that do the work, and Copilot pricing shows what each costs.