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 (8 prompts)
- Outlook (8 prompts)
- Word (8 prompts)
- Teams (7 prompts)
- PowerPoint (7 prompts)
- OneNote (6 prompts)
- SharePoint (6 prompts)
- Loop (5 prompts)
- Bonus: Cross-App Workflows (5 prompts)
Excel: Data Analysis in Seconds
Highlight the key trends in this data. What's going up, going down, and what needs attention?
Create a column chart showing monthly sales by region for the last 12 months. Use the data in columns A through D.
Explain what this formula does and suggest a simpler alternative.
Highlight all rows where revenue is below target and the variance is greater than 10%.
Forecast next quarter's numbers based on the last 6 months of data using a linear trend.
Give me a text summary of this table — what are the top 3 takeaways someone should know?
Clean this data: remove duplicates, fix date formats, and highlight any missing values.
Create a pivot table summary of this dataset grouped by department with average, min, and max values.
Outlook: Write Better Emails, Faster
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.
Write a meeting request for a project kickoff with 6 people. Include an agenda: introductions, scope review, timeline, next steps. Suggest 90 minutes.
Politely decline this sponsorship request but keep the door open for future opportunities. Thank them for reaching out.
Write a brief status update to my manager about project X. We're on track, completed the audit, starting implementation next week.
Write an introduction email connecting [person A] with [person B]. They'd benefit from knowing each other's work. Keep it warm and professional.
Write a gentle reminder to [name] about the deliverable due last Friday. Assume they're busy, not slacking. Offer help if stuck.
Coach this email: does the tone match the relationship? Is it too direct? Suggest alternatives for any harsh phrasing.
Summarize this email thread into 3 bullet points with the key decisions, open questions, and next steps.
Word: Documents That Write Themselves
Write a project proposal for migrating our CRM to Salesforce. Include: executive summary, current challenges, proposed solution, budget estimate, and timeline.
Summarize this 30-page contract into bullet points I can discuss with legal. Key terms, obligations, deadlines, and risks.
Rewrite this paragraph to sound more confident and concise. Remove passive voice and filler words.
Generate a table of contents for a 50-page technical specification document with chapters and subsections.
Write a performance review that's honest but constructive. Focus on growth areas while acknowledging strengths.
Create an FAQ section from this document. Identify the 7 most common questions a reader would have and answer them clearly.
Compare these two documents and highlight the key differences in approach, recommendations, and budget.
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
Summarize this meeting. List key decisions, action items with owners, and open questions.
What did I miss? Give me a 30-second recap of everything discussed in the last 20 minutes.
List all action items mentioned in this meeting with the person responsible and the deadline they agreed to.
Draft a follow-up email from this meeting recap. Include the decisions made and action items owners agreed to.
Summarize the chat history from the last 24 hours in the #general channel. Group by topic.
Create a table of pros and cons from the discussion we just had about switching vendors.
What concerns were raised about the budget in this meeting? List them and note who raised each one.
PowerPoint: Decks That Sell
Create a 5-slide deck summarizing Q3 sales performance. Include: overview, top performers, areas for improvement, and recommendations.
Suggest better charts and visuals for this data-heavy slide. I want something that tells a story, not just numbers.
Write speaker notes for this slide. Sound confident, not scripted. Include a transition from the previous slide.
Structure this presentation like a board briefing. Lead with the decision needed, support with 3 data points, end with the ask.
Summarize this Word document into a 3-slide executive summary deck with key takeaways and recommendations.
Design a title slide for this presentation. Theme: innovation and growth. Clean, modern, minimal.
Reduce this 15-slide deck to 7 slides without losing the core narrative. Merge related content.
OneNote: Your AI Second Brain
Organize these meeting notes into clear sections: Summary, Key Points, Action Items, and Follow-ups.
Extract all dates, deadlines, and action items from this page and put them into a timeline.
Find every mention of 'budget' across my last 10 notes and compile them into a single summary.
Distill 6 months of scattered project notes into a one-page executive brief with status, risks, and next steps.
Create a study guide from these lecture notes with flashcard-style questions and answers.
Summarize everything I know about [competitor/topic] based on all my notes across all notebooks.
SharePoint: Find Everything Instantly
Find the latest Q3 financial report with budget breakdown. Show me the direct link and a summary.
Summarize the top 5 documents in the Compliance library. Give me title, author, last modified, and key takeaways.
List all documents tagged with 'Q2 Review' across all sites. Group by site and show last modified date.
Find all documents about the new data privacy policy that were updated this year. Compare versions.
Compare these two proposals and highlight the key differences in scope, pricing, and timeline.
Create a project workspace for the marketing campaign with a document library, task list, and calendar.
Loop: Real-Time Collaboration
Summarize this workspace for the stakeholder meeting. Include status, blockers, and next milestones.
Write a project brief for the beta launch. Include scope, key dates, team roles, and success criteria.
Generate 10 ideas for improving customer onboarding. Format them as a voting table so the team can prioritize.
Create action items from this meeting notes page with owners, deadlines, and status tags.
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.
Find the key decisions from last week's Teams meeting, write a summary in Word, and email it to the stakeholders.
Pull the Q4 numbers from this Excel sheet, create a chart in PowerPoint, and add speaker notes explaining the trends.
Take my OneNotes from the last 3 client meetings and compile a project status document in Word with a summary for each.
Find the approved budget document in SharePoint, extract the key numbers into Excel, and highlight any departments over their allocation.
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
- Copy the prompt you need
- Paste it into the Copilot dialog in the relevant app (Excel, Outlook, Teams, Word, etc.)
- Replace anything in [brackets] with your actual names, dates, or numbers
- Review the output — Copilot is a starting point, not the final word
- 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 PDFRelated Articles
- Excel Copilot: AI Analysis in Seconds
- Outlook Copilot: Write Professional Emails in 60 Seconds
- Teams Copilot: Never Take Meeting Notes Again
- Word: Write Documents 10x Faster
- PowerPoint Copilot: AI Decks in Minutes
- OneNote: Your AI Second Brain
- SharePoint: Find Everything Instantly
- Loop: Real-Time Collaboration Reimagined