ChatGPT Prompts for Microsoft 365 Power Users
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 16 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.
Cross-App Workflows
4 promptsOutlook → Teams Handoff
1/16✨ What it does
ChatGPT plans when to move an email discussion into a Teams channel, how to post the link and context, who to tag, and what should stay in email. Move the next recurring, multi-person thread and leave one-to-one or sensitive mail in your Outlook.
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).
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/16✨ What it does
ChatGPT designs an Excel to SharePoint to Power BI pipeline, covering Excel format, list versus file storage, the connector, refresh, and who owns each step. Stand up a small test file and confirm the dashboard refreshes before you scale it.
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.
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/16✨ What it does
ChatGPT maps meeting notes in OneNote to flagged actions, Outlook Tasks, and completion back in OneNote, including tags, sync, and a weekly review. Flag one page of actions and check they appear in Tasks before you use it every week.
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.
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/16✨ What it does
ChatGPT designs a Forms to storage to Power BI path for surveys or intake, choosing Excel versus a SharePoint list, any Power Automate conditions, and the report. Submit a test response and confirm it shows on your dashboard.
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.
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.
Copilot Prompts
4 promptsCopilot in Word — Doc Creation
5/16✨ What it does
ChatGPT writes a detailed Copilot prompt to draft a Word document on [describe], with audience, length, tone, and structure so the draft is specific. Paste that prompt into Word Copilot, then edit the draft in your own voice.
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.
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/16✨ What it does
ChatGPT writes a Copilot prompt that turns a Word doc into PowerPoint, with source reference, slide count, structure, audience, and tone. Run it in PowerPoint Copilot and cut slides that do not earn a place in your deck.
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.
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/16✨ What it does
ChatGPT writes a focused Excel Copilot prompt for data [describe] and question [specific], aimed at useful analysis, formula ideas, and chart suggestions rather than a vague summary. Run it on a copy of the sheet and keep only the formulas you verified.
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.
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/16✨ What it does
ChatGPT writes an Outlook Copilot prompt from [describe], covering situation, recipient, intent, tone, and length for a routine draft. Generate the mail, then personalize the ask before you send.
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.
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 promptsTenant Health Audit
9/16✨ What it does
ChatGPT outlines a Microsoft 365 tenant health audit covering license use, inactive accounts, security score, compliance, Teams app sprawl, and unused SharePoint sites. Pull the admin reports and fix the highest-cost unused licenses in your tenant first.
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.
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/16✨ What it does
ChatGPT plans sensitivity labels for [org] with Public, Internal, Confidential, and Restricted, plus auto-classification, encryption, sharing controls, and training. Publish the labels in a test group before you turn on auto-classification.
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.
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/16✨ What it does
ChatGPT designs an M365 group provisioning process: who can create groups, naming, expiration for inactive groups, guest defaults, and a required owner. Turn on expiration and naming in the admin center after you name the owners.
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.
Pro tip: Default M365 = anyone creates groups + Teams = sprawl in 6 months. Restricted creation + governance = controlled. Most orgs over-permissive; reset.
License Optimization
12/16✨ What it does
ChatGPT analyzes license fit for [tenant], flagging E5 on light users, people using premium features without a license, Office versus M365 mix, and savings. Downgrade a known over-licensed account after you confirm they do not need the extra apps.
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.
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.
Productivity + Power Use
4 promptsDaily Workflow Optimization
13/16✨ What it does
ChatGPT optimizes your M365 daily workflow from [describe], with shortcuts, batching email, Search across M365, and automation ideas. Pick one change, such as two email blocks, and try it for a week yourself.
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.
Pro tip: Default M365 = constant app-switching. Optimized workflow = batched + automated + shortcut-driven. 30 min audit = hours saved monthly.
M365 Search Mastery
14/16✨ What it does
ChatGPT teaches M365 search syntax such as from:, hasAttachment:, and filetype:, plus Microsoft Search versus in-app search and filters. Run three real lookups with syntax and save the ones that work for you.
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.
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/16✨ What it does
ChatGPT plans M365 mobile setup: which apps to install, notification tuning, offline access, and PIN or biometric lock. Install only what you will use and silence the rest on your phone tonight.
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.
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/16✨ What it does
ChatGPT plans a Yammer or Viva Engage approach for [org], with community structure, engagement, leadership posts, content, metrics, and when Teams is the better place. Launch one community with a named owner and a first leadership post from you.
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.
Pro tip: Yammer (Viva Engage) = community + ideas + culture. Teams = work + projects. Mixing them = both fail. Distinct purposes = both succeed.
Free tool
Prompt Optimizer
Turn a rough idea into a structured, professional AI prompt.
Frequently Asked Questions
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.
7-day free trial. Cancel anytime.
Related guides