Microsoft

Enhance collaboration and communication across your organization with AI-powered Teams prompts.

Analyze the following Teams meeting transcript and provide a concise executive summary including: key decisions made, action items with owners, risks identified, and next steps. Format the output as a structured document with clear sections.\n\nMeeting Transcript:\n[PASTE TRANSCRIPT HERE]\n\nProvide a professional summary suitable for distribution to stakeholders who missed the meeting.

Create a professional, engaging announcement for our Microsoft Teams channel about the following update:\n\nUpdate Details: [PROVIDE DETAILS]\n\nTone: [PROFESSIONAL/CASUAL/URGENT]\n\nInclude:\n- A compelling headline\n- Context about why this matters\n- Key details and timeline\n- Call to action\n- Links to relevant resources\n\nFormat for Teams channel posting with appropriate emojis and formatting.

I need to address a team conflict situation. Generate a structured communication plan for resolving this using Copilot for Teams:\n\nSituation: [DESCRIBE CONFLICT]\nParties Involved: [LIST TEAM MEMBERS]\nObjective: [DESIRED OUTCOME]\n\nProvide:\n- Initial one-on-one conversation frameworks\n- Group discussion agenda\n- Documentation template\n- Follow-up check-in schedule\n\nEnsure the approach maintains psychological safety and team cohesion.

Transform raw data into actionable insights with AI-powered Excel analysis and reporting.

I have sales data in Excel with columns for: Date, Sales Rep, Product, Revenue, Region, and Deal Stage.\n\nUsing Copilot in Excel, create:\n1. A pivot table analyzing revenue by rep and region\n2. A trend analysis showing Q1-Q3 performance\n3. Identify top 5 performing reps and their key products\n4. Flag underperforming regions with percentage variance from target\n5. Generate recommendations for performance improvement\n\nProvide formulas I can use and explain the insights clearly.

Generate an automated budget variance analysis for our department expenses. I have:\n\n- Budget by Category (columns: Category, Budgeted Amount, Actual Spent, Variance %)\n- Monthly breakdown data\n\nCreate:\n1. Variance analysis with conditional formatting (red for over-budget)\n2. Month-over-month spending trends\n3. Department comparison analysis\n4. Forecast for remaining budget\n5. Executive summary with recommendations\n\nStructure this for presentation to finance leadership.

Analyze our customer data to understand behavior patterns:\n\nData includes: Customer ID, Signup Date, Purchase Amount, Purchase Frequency, Last Purchase Date, Churn Status\n\nUsing Copilot:\n1. Segment customers into cohorts by signup month\n2. Calculate retention rates by cohort\n3. Analyze spending patterns and lifetime value\n4. Identify high-risk churn cohorts\n5. Generate actionable retention recommendations\n\nFormat results for presentation to marketing and product teams.

Build intelligent dashboards with AI assistance to drive data-driven decision making.

I need to build a Power BI dashboard for tracking our key business metrics. Our KPIs are:\n\n- Monthly Recurring Revenue (MRR)\n- Customer Acquisition Cost (CAC)\n- Churn Rate\n- Net Revenue Retention\n- Support Ticket Resolution Time\n\nUsing Copilot in Power BI, help me:\n1. Design the dashboard layout\n2. Create visualizations for each KPI\n3. Add drill-down capabilities by region/team\n4. Set up alerts for metrics below threshold\n5. Create a narrative summary using AI insights\n\nTarget audience: Executive leadership.

Set up predictive analytics in Power BI using our historical data:\n\nData: Monthly revenue, seasonality patterns, marketing spend, customer acquisition, product launches\n\nImplement:\n1. Revenue forecasting model for next 12 months\n2. Confidence intervals and error margins\n3. Driver analysis showing what impacts revenue most\n4. Scenario planning (best case/worst case/realistic)\n5. Automated anomaly detection\n\nExplain model assumptions and limitations for stakeholders.

Create a Power BI customer health dashboard that tracks account health metrics:\n\nMetrics: Usage frequency, feature adoption rate, support ticket volume, NPS score, renewal risk\n\nDesign:\n1. Heat map showing all accounts with health status\n2. Drill-down by customer segment and size\n3. Early warning system for at-risk accounts\n4. Recommended actions by Copilot AI\n5. Comparative benchmarking against similar accounts\n\nIntegrate with our CRM system for real-time updates.

Master email productivity and communication with AI-powered Outlook prompts.

Draft a professional executive briefing email on behalf of our department:\n\nSubject Matter: [TOPIC]\nKey Points to Convey: [LIST 3-5 POINTS]\nTarget Recipient: [TITLE/ROLE]\nActionable Items: [WHAT YOU NEED FROM THEM]\nTimeline: [URGENCY]\n\nRequirements:\n- Concise (2-3 paragraphs max)\n- Professional but approachable tone\n- Clear call to action\n- Formatted for easy scanning\n- Include relevant data points\n\nGenerate 3 versions and choose the best fit.

I received a lengthy email thread with multiple participants and context switches. Using Copilot:\n\n1. Extract the main topic and sub-topics\n2. Identify who said what and their positions\n3. List agreed-upon decisions\n4. Highlight unresolved items\n5. Create an action items list with owners\n6. Generate a brief response acknowledging key points\n\n[PASTE EMAIL THREAD]\n\nFormat the summary for quick scanning and provide a template response.

Craft a strategic client relationship email with multiple objectives:\n\nClient Name: [NAME]\nObjectives: [LIST GOALS - e.g., upsell, strengthen relationship, gather feedback]\nCurrent Status: [CONTEXT]\nProposed Value: [WHAT YOU'RE OFFERING]\n\nGenerate:\n1. Personalized opening that references shared history\n2. Business value proposition tailored to their situation\n3. Specific proposal or request\n4. Social proof or success stories\n5. Clear next steps\n\nTone should be warm, professional, and value-focused.

Leverage Microsoft Graph API and advanced automation for enterprise-wide intelligence.

Design a Microsoft Graph integration that connects:\n\nData Sources: Teams chat, Calendar events, SharePoint documents, OneDrive activity\nObjective: Build a unified team productivity view\n\nUsing Copilot, create:\n1. API calls needed to fetch relevant data\n2. Data transformation and aggregation logic\n3. Insights to extract (collaboration patterns, content creation, communication volume)\n4. Privacy and compliance safeguards\n5. Dashboard/report design for insights\n6. Automation schedule and refresh strategy\n\nTarget: Enable managers to understand team dynamics and bottlenecks.

Set up a comprehensive compliance framework using Microsoft 365 capabilities:\n\nRequirements: Data retention, eDiscovery, audit logging, regulatory standards (GDPR/CCPA)\n\nImplement:\n1. Retention policies by content type (email, Teams, SharePoint)\n2. Retention labels and auto-apply rules\n3. eDiscovery workflow documentation\n4. Audit log configuration and monitoring\n5. Compliance reports and automated alerts\n6. Training content for team members\n\nEnsure documented alignment with legal and privacy teams.

Build an automation suite using Power Automate and Microsoft Graph:\n\nWorkflows Needed:\n1. New employee onboarding (provision accounts, teams, access)\n2. Document approval routing (multi-level, parallel, conditional)\n3. Escalation management for high-priority items\n4. Data sync between systems (CRM, ERP, SharePoint)\n5. Scheduled reporting (daily, weekly, monthly)\n\nFor each workflow, provide:\n- Trigger conditions\n- Decision logic and conditions\n- Integration points\n- Error handling and retry logic\n- Monitoring and logging strategy