Prompt Library

ChatGPT Prompts for Microsoft 365 Power Users

20 copy-paste prompts

20 copy-paste ChatGPT prompts for Microsoft 365: cross-app workflows, Copilot integration prompts, governance, productivity hacks, and the admin tactics that protect tenant health.

In short: This page contains 20 copy-paste ready prompts, organized into 4 categories with a description and pro tip for each. The first 5 prompts are free instantly, no signup needed. Hand-curated and tested by the AI Academy team.

By Louis Corneloup · Founder, Techpresso
Last updated ·Hand-curated & tested by the AI Academy team

Cross-App Workflows

4 prompts

Outlook → Teams Handoff

1/20

Workflow for moving email discussion to Teams channel. Output: when to move (recurring topic, multiple participants, file collaboration needed), how (post link, summarize context, tag attendees), what stays in email (1:1, sensitive, external).

Plans Outlook-to-Teams handoffs.

💡

Pro tip: Email threads with 5+ replies = should be in Teams. Email = 1:1 + external + ephemeral. Teams = topical + persistent + searchable. Pattern matters.

Excel + Power BI + SharePoint

2/20

Build pipeline: Excel data → SharePoint → Power BI dashboard. Output: Excel format requirements, SharePoint list vs file storage, Power BI connector, refresh strategy, who owns each step. End-to-end.

Builds Excel-SharePoint-PowerBI pipelines.

💡

Pro tip: Common pattern: Excel data entered locally → dashboard for management. Pipeline automates the link. Each step easy; orchestration is the value.

OneNote + Outlook + Tasks

3/20

Capture meeting notes in OneNote → flag action items → sync to Outlook Tasks → mark complete back in OneNote. Output: tagging convention, sync setup, completion workflow, weekly review. Built-in but underused.

Builds note-task chain.

💡

Pro tip: OneNote-Outlook-Tasks integration built into Microsoft 365. Most don't use. Setup once = action items captured + tracked + completed = closure.

Forms → Excel/SharePoint List → Power BI

4/20

Form responses → automated dashboard. Output: Form design, response storage (Excel vs SharePoint List), Power Automate flow if conditional, Power BI report on responses. Pattern for surveys, feedback, intake.

Forms-to-dashboard pipeline.

💡

Pro tip: Form responses sitting in default storage = unused data. Dashboard layer = visibility for stakeholders. Same data, transformed value.

Prompts get you started. Tutorials level you up.

A growing library of 300+ hands-on AI tutorials. New tutorials added every week.

Start 7-Day Free Trial

Copilot Prompts

4 prompts

Copilot in Word — Doc Creation

5/20

Copilot prompt to draft document in Word. Topic: [describe]. Output: detailed prompt with context, audience, length, tone, structure. Specific prompt = quality draft. Generic prompt = generic draft.

Crafts Copilot prompts for Word.

💡

Pro tip: Copilot in Word draft quality = prompt quality. "Write document about X" = generic. "Write 3-page proposal for [audience] addressing [problem] in [tone] structured as [outline]" = quality output.

Copilot in PowerPoint — Slides from Doc

6/20

Copilot prompt to generate PowerPoint from existing Word doc. Output: prompt referencing source doc, slide count target, deck structure, audience, tone. Saves hours converting doc to deck.

Crafts Copilot deck-from-doc prompts.

💡

Pro tip: Word doc → PPT manual conversion = hours. Copilot conversion = minutes (with cleanup). Specific prompt directs structure; generic = bad PPT.

Copilot in Excel — Analysis

7/20

Copilot prompt for Excel data analysis. Data: [describe]. Question: [specific]. Output: prompt that gets useful analysis (not generic summary), formula suggestions, visualizations recommended. Excel Copilot strong with focused prompts.

Crafts Excel Copilot prompts.

💡

Pro tip: Excel Copilot needs specific question. "Analyze this data" = vague summary. "Show top 3 customers by revenue with trend vs prior year" = specific actionable output.

Copilot in Outlook — Email Draft

8/20

Copilot prompt for Outlook email draft. Context: [describe]. Output: prompt structure (situation, recipient, intent, tone, length). Saves drafting time on routine emails. Personalize after generation.

Crafts Outlook Copilot prompts.

💡

Pro tip: Copilot drafts Outlook email = good first pass. Always edit for voice + accuracy before sending. Pure-AI emails detected + lower trust. Hybrid wins.

Governance + Admin

4 prompts

Tenant Health Audit

9/20

Audit Microsoft 365 tenant health. Output: license utilization, inactive accounts, security score, compliance status, app sprawl in Teams, SharePoint sites inactive. Quarterly audit = sustainable tenant.

Audits M365 tenant health.

💡

Pro tip: Tenant health drifts toward chaos without active management. Quarterly audit catches issues early. Most admins react to incidents; the audit prevents them.

Sensitivity Label Strategy

10/20

Sensitivity label strategy for [org]. Output: label hierarchy (Public, Internal, Confidential, Restricted), auto-classification rules, encryption settings, sharing controls, training plan. Labels = data protection at scale.

Plans sensitivity labels.

💡

Pro tip: Labels enforce data protection at file level. Without labels = data leakage risk. With labels = encryption + access controls follow file. Underused but powerful.

Group Provisioning Process

11/20

M365 group provisioning process. Output: who can create (limited to avoid sprawl), naming convention, expiration policy (auto-delete inactive), guest access defaults, owner requirement. Group sprawl = most common M365 problem.

Designs group provisioning.

💡

Pro tip: Default M365 = anyone creates groups + Teams = sprawl in 6 months. Restricted creation + governance = controlled. Most orgs over-permissive; reset.

License Optimization

12/20

License optimization for [tenant]. Output: license type-by-user analysis, over-licensed users (E5 for occasional users), under-licensed (using premium features without license), Office vs M365 mix, savings potential. License cost optimization = real money.

Optimizes M365 licenses.

💡

Pro tip: License audits often find 10-30% over-licensing. E5 vs E3 for users not using E5 features = waste. Annual audit = real $ savings.

Like these prompts? There are full tutorials behind them.

Learn the workflows, not just the prompts. 300+ easy-to-follow tutorials inside AI Academy — and growing every week.

Try AI Academy Free

Productivity + Power Use

4 prompts

Daily Workflow Optimization

13/20

Optimize my M365 daily workflow. Current: [describe]. Output: suggested keyboard shortcuts, app-switching reduction (do email in 2 batches), Search across M365, automation candidates. Daily workflow = compounded across years.

Optimizes daily M365 workflows.

💡

Pro tip: Default M365 = constant app-switching. Optimized workflow = batched + automated + shortcut-driven. 30 min audit = hours saved monthly.

M365 Search Mastery

14/20

Master M365 search across apps. Output: search syntax (from:, hasAttachment:, filetype:), Microsoft Search vs in-app search, scope refinement, advanced filters. Most users don't know syntax.

Masters M365 search.

💡

Pro tip: Search across M365 powerful but underused. Find files in OneDrive + emails in Outlook + Teams messages from one search. Most users navigate; search faster.

Mobile M365 Setup

15/20

Optimize M365 mobile app setup. Output: which apps install (Outlook, Teams, OneDrive, Word, Excel, PowerPoint, OneNote, Authenticator), notification tuning per app, offline access setup, security (PIN, biometric). Mobile = real productivity multiplier.

Sets up M365 mobile.

💡

Pro tip: M365 mobile underused. Most users use Outlook only. Full setup = work productively from phone (review docs, approve, quick edits). Travel + transit time reclaimed.

Yammer / Viva Engage Strategy

16/20

Yammer/Viva Engage strategy for [org]. Output: community structure, engagement program, leadership participation, content strategy, success metrics, Teams vs Viva Engage decision (different purposes). Most Yammer = ghost town.

Plans Viva Engage strategy.

💡

Pro tip: Yammer (Viva Engage) = community + ideas + culture. Teams = work + projects. Mixing them = both fail. Distinct purposes = both succeed.

Frequently Asked Questions

Depends on user. Heavy Office users = high ROI ($30/user/mo, often saves 30+ min/day). Light users = poor ROI. Pilot with 50 users + measure before org-wide. Don't blanket roll out.
M365 (subscription) = always latest, cloud features, mobile included. Office perpetual = one-time but no cloud, no mobile, falls behind. Most orgs on M365; perpetual fading.
Group provisioning controls, naming conventions, expiration policies, ownership requirements, regular audits. Default M365 = sprawl in 12 months. Governance from day 1.
Power Automate (automation), Lists (better than Excel for many cases), Whiteboard (collaboration), Stream (video), Sway (interactive presentations), Bookings (scheduling). Underused gold.
M365: enterprise standard, Office apps, deeper features, more complex. Google: simpler, real-time collab, web-first. Most enterprises = M365; tech startups + Gmail-native = Google. Lock-in real either direction.

Prompts are the starting line. Tutorials are the finish.

A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.

Start 7-Day Free TrialExplore AI for Business

7-day free trial. Cancel anytime.

Browse All Prompt Collections

Popular prompt collections

AI Photo Editing PromptsChatGPT Jailbreak PromptBest ChatGPT PromptsFunny Hinge PromptsChatGPT Caricature Prompts