50+ Best Prompts for Microsoft 365 Copilot

50+ Best Prompts for Microsoft 365 Copilot

Copy-paste these prompts to save hours every week. Organized by app — Excel, Outlook, Teams, Word, PowerPoint, OneNote, SharePoint, and Loop.

You already have Copilot. The question is whether you're using it right.

Most people type one or two vague prompts, get mediocre results, and assume Copilot isn't that useful. The truth is Copilot is only as good as the prompt you give it. A well-structured prompt returns something you can use instantly. A lazy prompt returns something you'll rewrite anyway.

This library covers every major Microsoft 365 Copilot app. Each prompt is battle-tested — I use these myself in real meetings, real spreadsheets, and real deadlines. Copy, paste, and watch the time disappear.

Jump to a section:

Excel: Data Analysis in Seconds

Excel

Highlight the key trends in this data. What's going up, going down, and what needs attention?

Excel

Create a column chart showing monthly sales by region for the last 12 months. Use the data in columns A through D.

Excel

Explain what this formula does and suggest a simpler alternative.

Excel

Highlight all rows where revenue is below target and the variance is greater than 10%.

Excel

Forecast next quarter's numbers based on the last 6 months of data using a linear trend.

Excel

Give me a text summary of this table — what are the top 3 takeaways someone should know?

Excel

Clean this data: remove duplicates, fix date formats, and highlight any missing values.

Excel

Create a pivot table summary of this dataset grouped by department with average, min, and max values.

Outlook: Write Better Emails, Faster

Outlook

Draft a follow-up email to [name] about the proposal I sent last week. Polite, not pushy. Offer to hop on a call if they have questions.

Outlook

Write a meeting request for a project kickoff with 6 people. Include an agenda: introductions, scope review, timeline, next steps. Suggest 90 minutes.

Outlook

Politely decline this sponsorship request but keep the door open for future opportunities. Thank them for reaching out.

Outlook

Write a brief status update to my manager about project X. We're on track, completed the audit, starting implementation next week.

Outlook

Write an introduction email connecting [person A] with [person B]. They'd benefit from knowing each other's work. Keep it warm and professional.

Outlook

Write a gentle reminder to [name] about the deliverable due last Friday. Assume they're busy, not slacking. Offer help if stuck.

Outlook

Coach this email: does the tone match the relationship? Is it too direct? Suggest alternatives for any harsh phrasing.

Outlook

Summarize this email thread into 3 bullet points with the key decisions, open questions, and next steps.

Word: Documents That Write Themselves

Word

Write a project proposal for migrating our CRM to Salesforce. Include: executive summary, current challenges, proposed solution, budget estimate, and timeline.

Word

Summarize this 30-page contract into bullet points I can discuss with legal. Key terms, obligations, deadlines, and risks.

Word

Rewrite this paragraph to sound more confident and concise. Remove passive voice and filler words.

Word

Generate a table of contents for a 50-page technical specification document with chapters and subsections.

Word

Write a performance review that's honest but constructive. Focus on growth areas while acknowledging strengths.

Word

Create an FAQ section from this document. Identify the 7 most common questions a reader would have and answer them clearly.

Word

Compare these two documents and highlight the key differences in approach, recommendations, and budget.

Word

Take this rough draft and expand each section with relevant research points, examples, and supporting data. Keep the tone professional.

Teams: Never Miss a Meeting Detail

Teams

Summarize this meeting. List key decisions, action items with owners, and open questions.

Teams

What did I miss? Give me a 30-second recap of everything discussed in the last 20 minutes.

Teams

List all action items mentioned in this meeting with the person responsible and the deadline they agreed to.

Teams

Draft a follow-up email from this meeting recap. Include the decisions made and action items owners agreed to.

Teams

Summarize the chat history from the last 24 hours in the #general channel. Group by topic.

Teams

Create a table of pros and cons from the discussion we just had about switching vendors.

Teams

What concerns were raised about the budget in this meeting? List them and note who raised each one.

PowerPoint: Decks That Sell

PowerPoint

Create a 5-slide deck summarizing Q3 sales performance. Include: overview, top performers, areas for improvement, and recommendations.

PowerPoint

Suggest better charts and visuals for this data-heavy slide. I want something that tells a story, not just numbers.

PowerPoint

Write speaker notes for this slide. Sound confident, not scripted. Include a transition from the previous slide.

PowerPoint

Structure this presentation like a board briefing. Lead with the decision needed, support with 3 data points, end with the ask.

PowerPoint

Summarize this Word document into a 3-slide executive summary deck with key takeaways and recommendations.

PowerPoint

Design a title slide for this presentation. Theme: innovation and growth. Clean, modern, minimal.

PowerPoint

Reduce this 15-slide deck to 7 slides without losing the core narrative. Merge related content.

OneNote: Your AI Second Brain

OneNote

Organize these meeting notes into clear sections: Summary, Key Points, Action Items, and Follow-ups.

OneNote

Extract all dates, deadlines, and action items from this page and put them into a timeline.

OneNote

Find every mention of 'budget' across my last 10 notes and compile them into a single summary.

OneNote

Distill 6 months of scattered project notes into a one-page executive brief with status, risks, and next steps.

OneNote

Create a study guide from these lecture notes with flashcard-style questions and answers.

OneNote

Summarize everything I know about [competitor/topic] based on all my notes across all notebooks.

SharePoint: Find Everything Instantly

SharePoint

Find the latest Q3 financial report with budget breakdown. Show me the direct link and a summary.

SharePoint

Summarize the top 5 documents in the Compliance library. Give me title, author, last modified, and key takeaways.

SharePoint

List all documents tagged with 'Q2 Review' across all sites. Group by site and show last modified date.

SharePoint

Find all documents about the new data privacy policy that were updated this year. Compare versions.

SharePoint

Compare these two proposals and highlight the key differences in scope, pricing, and timeline.

SharePoint

Create a project workspace for the marketing campaign with a document library, task list, and calendar.

Loop: Real-Time Collaboration

Loop

Summarize this workspace for the stakeholder meeting. Include status, blockers, and next milestones.

Loop

Write a project brief for the beta launch. Include scope, key dates, team roles, and success criteria.

Loop

Generate 10 ideas for improving customer onboarding. Format them as a voting table so the team can prioritize.

Loop

Create action items from this meeting notes page with owners, deadlines, and status tags.

Loop

Draft an agenda for next week's sprint review. Include timeboxed slots for each team to present.

Bonus: Cross-App Workflows

These prompts span multiple M365 apps. They're advanced but save the most time.

Cross-App

Find the key decisions from last week's Teams meeting, write a summary in Word, and email it to the stakeholders.

Cross-App

Pull the Q4 numbers from this Excel sheet, create a chart in PowerPoint, and add speaker notes explaining the trends.

Cross-App

Take my OneNotes from the last 3 client meetings and compile a project status document in Word with a summary for each.

Cross-App

Find the approved budget document in SharePoint, extract the key numbers into Excel, and highlight any departments over their allocation.

Cross-App

Create a Loop workspace for the new project, add a task list, attach the relevant SharePoint documents, and draft a kickoff email in Outlook.

How to Use These Prompts

  1. Copy the prompt you need
  2. Paste it into the Copilot dialog in the relevant app (Excel, Outlook, Teams, Word, etc.)
  3. Replace anything in [brackets] with your actual names, dates, or numbers
  4. Review the output — Copilot is a starting point, not the final word
  5. Tweak and save your favorites. Over time you'll build a personal library of go-to prompts

Get the PDF Version

Want this as a printable cheat sheet? Drop your email below and I'll send you the complete PDF — organized by app, ready to print and keep on your desk.

Get the Free Prompt Library PDF

Related Articles