How to get real work out of Microsoft Copilot

Most small 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. 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.

Why most people stall

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, because it doesn’t know who you are, who the email is for, what you’re selling or what a good result looks like for you. So it guesses, and a guess 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-part prompt

Microsoft’s own guidance breaks a good prompt into four parts. Only the first is required, but each one you add removes a guess:

Here’s the difference in practice:

The second prompt takes 45 seconds longer to write and usually saves three rounds of editing.

Point it at the right material

Copilot is only as good as what it’s working from. How you hand it material 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.

Treat it as a conversation

The first answer is 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 let Copilot interview you 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 it’s part of the routine, not something you remember on a slow afternoon. These five cover most of an owner’s or office manager’s week.

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)

The meeting has to be 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 handles messier data and bigger questions than Copilot in Excel alone.

5. Notes into a finished document (Word)

Set up your files so Copilot can find them

With a paid seat, the quality of Copilot’s answers depends heavily on the state of your files. A few hours of housekeeping 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 permissions. Copilot shows each person only what they can already open. That protects you if permissions are right, and exposes you if the “Everyone” group can open the HR folder.

Check its work

Copilot can be confidently wrong. Microsoft’s own advice is to review and verify what it gives you, and it’s good advice. A few rules we follow:

• Numbers, dates, names and prices: always check against the source. Copilot shows references for answers from your files; click them.
• 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 it to show its sources or reasoning.

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 the instructions and the files built in, so 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.