7 professional courses covering government workflows, daily productivity, AI wealth strategies, and more. Taught by Mary Johnson.
Click any card to jump to that course. Complete them in any order.
Real workflows for public sector professionals using AI responsibly
From scattered tasks to streamlined days—your AI productivity partner
A simple prompt framework for clear, accurate, and responsible results
Combine Microsoft Copilot and Anthropic Claude to create, monetize, and scale digital income streams
A strategic framework for finding where Copilot creates the most value in your organization
Connect the dots across apps to build seamless, end-to-end AI-powered workflows
Cut through the hype with real, practical AI techniques for everyday professionals
Real workflows for public sector professionals using AI responsibly
Discover three high-impact Microsoft 365 Copilot workflows designed specifically for government employees. Learn how to streamline constituent communication, automate report generation, and manage compliance documentation—all while maintaining security and data governance standards.
Microsoft 365 Copilot is an AI-powered assistant embedded within Microsoft 365 apps—Word, Excel, Outlook, Teams, PowerPoint, and more. For government employees, it offers the ability to draft documents faster, summarize lengthy reports, and analyze data without needing advanced technical skills.
Copilot uses large language models (LLMs) combined with your organization's Microsoft Graph data (emails, meetings, documents) to provide contextually relevant assistance. Importantly, Microsoft has designed Copilot to comply with enterprise security standards—your data is not used to train external AI models.
Step-by-step to access Copilot:
1. Open any Microsoft 365 app (Word, Outlook, Teams)
2. Look for the Copilot icon (sparkle icon) in the toolbar or sidebar
3. Click the icon to open the Copilot chat panel
4. Type your prompt or select a suggested action
5. Review the AI-generated output and edit as needed
Government use cases include: drafting policy memos, summarizing public comments, generating meeting minutes, and creating data summaries from Excel spreadsheets.
Before using Copilot, government employees must understand the data governance framework. Microsoft 365 Copilot is built on Microsoft's commercial cloud, which meets FedRAMP Moderate authorization requirements for many agencies.
Key security principles:
1. Data stays within your tenant—Copilot only accesses data you have permission to see
2. Responses are not stored in external AI training databases
3. Sensitive data labels (e.g., Confidential, Top Secret) are respected
4. Audit logs capture all Copilot interactions for compliance reviews
Best practices for government users:
- Never input classified or sensitive PII into Copilot prompts
- Always review AI-generated content before sending or publishing
- Follow your agency's AI use policy and acceptable use guidelines
- Report any unexpected or concerning outputs to your IT security team
Many agencies have deployed Microsoft Purview alongside Copilot to monitor and govern AI interactions. Check with your IT department about your agency's specific Copilot configuration.
One of the most time-consuming tasks for government staff is responding to constituent inquiries. Copilot in Outlook can draft professional, accurate responses in seconds.
Step-by-step workflow:
1. Open Outlook and select an incoming constituent email
2. Click the Copilot icon in the email toolbar
3. Select 'Draft with Copilot'
4. Enter your prompt: 'Draft a professional response to this constituent explaining our permit application process. Be clear, empathetic, and include a 3–5 business day response timeline.'
5. Review the drafted response
6. Edit for accuracy, add any agency-specific links or references
7. Add your signature and send
Pro Tips:
- Use the 'Coaching' feature: ask Copilot to 'make this more empathetic' or 'simplify the language for a general audience'
- Create a library of prompt templates for common constituent questions
- Always fact-check any policy details Copilot includes
Time savings: Staff report saving 15–30 minutes per complex constituent response when using Copilot.
When your agency collects constituent surveys or public comments, Copilot in Excel can analyze and summarize the data.
Step-by-step workflow:
1. Open your constituent feedback spreadsheet in Excel
2. Ensure data is in a formatted table (Insert > Table)
3. Click the Copilot icon in the Excel ribbon
4. Enter prompt: 'Summarize the top 5 themes from the feedback in column C. Show sentiment (positive/negative/neutral) and count of responses per theme.'
5. Copilot will generate a summary and may create a chart
6. Review the analysis and insert into your report
This workflow replaces hours of manual reading and categorization with a few minutes of AI-assisted analysis.
Government agencies produce dozens of reports—quarterly performance reports, budget summaries, program updates. Copilot in Word dramatically accelerates this process.
Step-by-step workflow:
1. Gather your source data: meeting notes, Excel summaries, prior reports
2. Open a new Word document
3. Click Copilot in the Draft with Copilot panel
4. Enter prompt: 'Create a quarterly performance report for our Housing Assistance Program. Include sections for: Executive Summary, Key Performance Indicators, Challenges Encountered, and Recommendations. Use a formal government tone.'
5. Copilot drafts the full structure with placeholder content
6. Replace placeholders with your real data
7. Use Copilot to 'Rewrite this paragraph to be more concise' or 'Add a transition sentence between these sections'
Powerful advanced technique: Reference existing documents. With Business Chat, you can say: 'Create a report using the data from [meeting notes file] and [Excel data file].' Copilot pulls from both sources.
After every government meeting—town halls, interagency coordination calls, department briefings—Copilot in Teams can generate instant, accurate meeting summaries.
Step-by-step workflow:
1. Start or join a Teams meeting
2. Enable Teams meeting transcription (required for Copilot recap)
3. Conduct your meeting as normal
4. At the end of the meeting, click Copilot in the meeting toolbar
5. Select 'Recap' to get: key discussion points, action items with owners, decisions made, and next steps
6. Export the recap to Word or OneNote
7. Share with attendees via email or Teams channel
Important: Participants should be informed that transcription and Copilot are active. Some agencies require disclosures in meeting invites.
Government compliance officers and legal staff review massive volumes of policy documents. Copilot can accelerate this dramatically.
Step-by-step workflow:
1. Open the policy document in Word
2. Open Copilot panel (right sidebar)
3. Ask: 'Summarize the key compliance requirements in this document in plain English'
4. Follow up: 'What are the deadlines mentioned in this document?'
5. Ask: 'Does this document reference any external regulations? If so, list them.'
6. Use the summaries to create a compliance checklist
7. Prompt: 'Create a 10-item compliance checklist based on the requirements in this document'
This workflow is especially powerful for reviewing Federal Register notices, OMB circulars, and agency-specific policy updates.
Standard Operating Procedures (SOPs) and compliance checklists are critical in government. Copilot helps create and update them efficiently.
Step-by-step workflow:
1. Open Word with Copilot
2. Provide context: 'We need an SOP for processing FOIA requests in a federal agency'
3. Prompt: 'Create a step-by-step Standard Operating Procedure for processing FOIA requests. Include: intake, review, redaction, response, and appeal stages. Use numbered steps and note legal timeframes.'
4. Add your agency-specific details and reference numbers
5. Have a supervisor review and approve
6. Format and publish per your agency's document standards
Remember: Always have legal/compliance staff review AI-generated policy documents before they are finalized or distributed.
Test your understanding of 3 Practical Microsoft 365 Copilot Workflows for Government
Q1: What Microsoft framework ensures Copilot only accesses data you have permission to see?
Q2: Which Copilot feature in Teams generates summaries, action items, and decisions after a meeting?
Q3: Before using Copilot in a government setting, what should you NEVER input into prompts?
Q4: How does Copilot in Outlook help with constituent communication?
Q5: What is the first step in using Copilot to analyze constituent feedback in Excel?
From scattered tasks to streamlined days—your AI productivity partner
Learn how to weave Microsoft Copilot into your everyday work routine. This practical course covers how to use Copilot across email, meetings, documents, and data to reclaim hours each week and focus on the work that truly matters.
The first step to using Copilot for productivity is identifying where you lose time each day. Most professionals waste time on: writing repetitive emails, sitting through unproductive meetings, searching for documents, and formatting reports manually.
Copilot addresses each of these:
- Email drafting & summarization → Copilot in Outlook
- Meeting recaps & action items → Copilot in Teams
- Document creation & editing → Copilot in Word
- Data analysis → Copilot in Excel
- Presentation creation → Copilot in PowerPoint
Your action plan for this lesson:
1. Spend 10 minutes listing your 5 most time-consuming daily tasks
2. For each task, identify which Microsoft 365 app you use
3. Map each task to a Copilot feature
4. Prioritize the top 2 tasks to tackle first with Copilot
Remember: Start small. Pick one Copilot feature to master this week before adding others.
The quality of your Copilot output depends entirely on the quality of your prompt. Think of prompting as giving clear instructions to a highly capable assistant.
The CRAFT Prompt Formula:
- C = Context (who you are, what situation you're in)
- R = Role (what role you want Copilot to play)
- A = Action (what you want Copilot to do)
- F = Format (how you want the output structured)
- T = Tone (formal, casual, empathetic, concise)
Examples:
Weak prompt: 'Write an email about the meeting'
Strong prompt: 'I'm a project manager. Draft a professional email to my team summarizing today's planning meeting. Include 3 key decisions made and 4 action items with owner names. Keep it under 200 words. Use a clear, motivating tone.'
Practice exercises:
1. Write a weak prompt, then rewrite it using CRAFT
2. Test both prompts in Copilot and compare outputs
3. Save your best-performing prompts in a personal prompt library (OneNote works great)
Email is one of the biggest productivity killers. Copilot in Outlook can help you get through your inbox up to 3x faster.
Key Copilot email features:
1. Email Summarization
Step-by-step:
- Open a long email thread
- Click Copilot icon
- Select 'Summarize'
- Read the 3–5 sentence summary instead of scrolling through 40 emails
2. Draft Responses
Step-by-step:
- Open an email you need to reply to
- Click 'Reply'
- Click Copilot icon → 'Draft with Copilot'
- Enter your desired message intent
- Select tone: Formal, Casual, Direct, or Empathetic
- Edit and send
3. Email Coaching
Step-by-step:
- After drafting an email, click Copilot → 'Coaching by Copilot'
- Copilot analyzes tone, clarity, and length
- Follow the suggestions to improve your message
Productivity goal: Aim to spend no more than 30 minutes on email in the morning using Copilot summarization and quick-draft features.
Meetings consume a massive portion of the workday. Copilot helps at every stage.
BEFORE the meeting:
1. Open Teams and find the meeting invite
2. Ask Copilot: 'Prepare me for my 2pm project review meeting. Summarize recent emails and documents related to Project Alpha.'
3. Copilot pulls relevant context from your M365 data
4. Review the briefing—arrive prepared in 5 minutes instead of 30
DURING the meeting:
1. Enable transcription when the meeting starts
2. If you miss something, ask Copilot: 'What did Sarah just say about the budget?'
3. Ask Copilot: 'Are there any open questions or disagreements so far?'
4. Ask: 'What decisions have been made in this meeting?'
AFTER the meeting:
1. Click Recap in Teams after the meeting ends
2. Review: Summary, Action Items, Speakers
3. Ask Copilot: 'Create follow-up tasks from this meeting and assign them to the correct team members'
4. Copy action items into your task manager (Microsoft To Do, Planner, etc.)
Time saved per meeting: 20–40 minutes on documentation and follow-up.
Whether you're writing a proposal, policy document, or status update, Copilot in Word can give you a strong first draft in minutes.
Step-by-step for first drafts:
1. Open Word → New Document
2. Click Copilot icon → 'Draft with Copilot'
3. Describe what you need: 'Write a one-page proposal for implementing a new employee wellness program. Include: problem statement, proposed solution, expected benefits, and budget range of $10,000–$25,000. Use formal business language.'
4. Review the draft (it won't be perfect—that's normal)
5. Edit and refine with follow-up Copilot prompts:
- 'Make the executive summary more compelling'
- 'Add a section on implementation timeline'
- 'Shorten the budget section to 3 bullet points'
Copilot as your editor:
- Highlight a paragraph → Ask Copilot to 'Rewrite this more concisely'
- Ask Copilot to 'Check this document for inconsistent tone'
- Ask 'Generate 5 alternative headlines for this document'
Goal: First drafts in under 10 minutes. Editing time cut by 50%.
Test your understanding of How To Use Copilot To Improve Daily Productivity
Q1: What does the 'C' stand for in the CRAFT prompt formula?
Q2: Which Copilot feature analyzes your email's tone, clarity, and length?
Q3: What must be enabled in Teams for Copilot to generate meeting recaps?
Q4: What is the recommended maximum time to spend on morning email using Copilot?
Q5: When should you start adding more Copilot features to your workflow?
A simple prompt framework for clear, accurate, and responsible results
Feeling overwhelmed by AI? This course takes you from confusion to confidence with Microsoft Copilot. You'll learn a simple, repeatable prompt framework that produces clear and accurate results every time—plus how to use Copilot responsibly so you stay in control.
If you've felt confused, overwhelmed, or even intimidated by AI tools like Microsoft Copilot, you are not alone. Most people feel this way at first—not because AI is too complicated, but because no one has shown them a clear, simple system for using it.
The three most common sources of AI confusion:
1. Not knowing what to ask (prompt paralysis)
2. Getting bad outputs and not knowing why
3. Worrying about using AI 'wrong' or irresponsibly
This course solves all three.
The mindset shift you need:
Think of Copilot not as a search engine (where you type keywords) but as a brilliant assistant who needs clear instructions. When you give a good assistant vague instructions, you get vague results. When you give specific, detailed instructions, you get excellent results.
Key truth: The AI isn't the problem. The prompt is where the magic—or the failure—happens.
Your first exercise:
1. Open Microsoft Copilot (in any M365 app or at copilot.microsoft.com)
2. Type this prompt: 'Explain what you can help me do in my daily work in 5 simple bullet points'
3. Read the response
4. Follow up: 'Which of these would help most with [your most common task]?'
Congratulations—you've already started your Copilot journey!
You don't need to understand the mathematics behind AI to use it well—just like you don't need to understand how a car engine works to drive. But a basic understanding helps you use Copilot more effectively.
How Copilot processes your request (simplified):
1. You type a prompt
2. Copilot reads your prompt AND your relevant M365 data (emails, files, calendar)
3. The AI model predicts the most helpful response based on patterns in billions of text examples
4. Copilot generates a response and displays it
5. You review, refine, and use the result
What Copilot is GREAT at:
- Drafting, rewriting, and summarizing text
- Analyzing and visualizing data
- Answering questions based on your documents
- Generating creative ideas and options
- Translating complex language into plain English
What Copilot is NOT great at:
- Knowing facts after its training cutoff date
- Accessing the internet in real-time (unless Bing is enabled)
- Reading your mind—it needs clear instructions
- Making final decisions—that's your job
Always remember: Copilot is a tool. You are the expert. Copilot assists; you decide.
The CLEAR Framework is your simple, repeatable system for writing Copilot prompts that get excellent results every time.
CLEAR stands for:
- C = Context: What's the background situation?
- L = Length: How long should the response be?
- E = Examples: Can you give an example of what you want?
- A = Audience: Who will read or use this output?
- R = Role: What role should Copilot play?
Let's build a prompt using CLEAR:
Scenario: You need to write a training reminder email to your department.
Without CLEAR: 'Write a training reminder email'
With CLEAR:
- Context: 'Our department has mandatory cybersecurity training due by Friday'
- Length: 'Keep the email under 150 words'
- Example: 'Similar to our usual internal communication style—professional but approachable'
- Audience: 'IT-savvy employees who are busy and dislike long emails'
- Role: 'Act as our department communications coordinator'
Full CLEAR prompt: 'Act as our department communications coordinator. Write a professional but approachable email reminder to busy IT-savvy employees about mandatory cybersecurity training due this Friday. Keep it under 150 words with a clear call-to-action. Use a similar tone to typical internal corporate communications.'
Result: A dramatically better, ready-to-use email draft.
The CLEAR framework works across any Copilot task. Let's practice with three common work scenarios.
Scenario 1: Summarizing a Long Report
CLEAR prompt: 'Act as a business analyst. Read this 20-page annual report and provide a 1-page executive summary. Focus on financial performance, key risks, and strategic priorities. The audience is senior leadership with limited time. Use bullet points for each section.'
Scenario 2: Preparing for a Difficult Conversation
CLEAR prompt: 'Act as an HR advisor. I need to have a performance conversation with a team member who has missed three deadlines. Help me structure a 15-minute conversation. Include: opening statement, key points to address, how to invite their perspective, and a closing that sets clear expectations. Audience: just me—this is my personal preparation guide. Keep it to one page.'
Scenario 3: Creating a Project Timeline
CLEAR prompt: 'Act as a project manager. Create a 6-week project timeline for launching a new employee onboarding program. Include weekly milestones, key deliverables, and responsible parties (HR, IT, Managers). Format as a table. Audience: department heads who will track progress.'
Practice: Apply CLEAR to your most common recurring work task this week.
One of the most important skills in using AI responsibly is knowing when and how to verify outputs. AI models can occasionally generate incorrect information—this is called a 'hallucination.' It's not intentional; it's a limitation of how AI works.
When to always verify:
- Statistics, numbers, and data
- Legal or regulatory information
- Medical or safety-critical content
- Specific dates, names, or quotes
- Any factual claim that would be embarrassing or harmful if wrong
How to verify:
1. Cross-reference with official sources (government websites, industry publications)
2. Ask Copilot to cite its sources: 'What sources are you drawing from for this information?'
3. Use Copilot's Bing integration to search current information
4. Have a subject-matter expert review high-stakes outputs
The Responsible Review Checklist:
☐ Is the information factually accurate?
☐ Is the tone appropriate for the audience?
☐ Does it represent your organization's values and policies?
☐ Has sensitive information been removed or protected?
☐ Would you be comfortable if your manager saw this output?
Golden rule: Never send, publish, or act on Copilot output without your own review. You are responsible for everything you send—regardless of whether AI helped write it.
Test your understanding of From Confused to Confident: Using Microsoft Copilot to Work Smarter Every Day
Q1: What does the 'L' in the CLEAR framework stand for?
Q2: What is an AI 'hallucination'?
Q3: According to the course, who is ultimately responsible for AI-generated content you send or publish?
Q4: What is the key mindset shift this course recommends for using Copilot?
Q5: What should you ALWAYS do before sending Copilot-generated content?
Combine Microsoft Copilot and Anthropic Claude to create, monetize, and scale digital income streams
Discover how combining Microsoft Copilot and Anthropic Claude creates an unstoppable AI productivity stack for solopreneurs and digital entrepreneurs. Learn how to use these two AI powerhouses to build courses, digital products, client services, and passive income streams that create lasting generational wealth.
Microsoft Copilot and Anthropic Claude are two of the most powerful AI tools available today—and they complement each other perfectly for digital entrepreneurs.
Microsoft Copilot excels at:
- Working within Microsoft 365 (Word, Excel, PowerPoint, Outlook, Teams)
- Accessing and synthesizing your business files and emails
- Creating polished business documents and presentations
- Analyzing spreadsheet data and generating charts
- Drafting professional communications
Anthropic Claude excels at:
- Long-form content creation (courses, ebooks, articles)
- Deep reasoning and nuanced writing
- Code generation for digital products
- Complex research and analysis
- Creative content (stories, scripts, marketing copy)
- Structured data output (JSON, tables, organized formats)
The Power Combo Strategy:
Use Claude to CREATE your content (course materials, ebooks, product copy) → Use Copilot to PACKAGE and DELIVER it (format in Word/PowerPoint, analyze sales in Excel, communicate with clients in Outlook)
This two-tool workflow dramatically multiplies your output without multiplying your hours.
Generational wealth in the digital economy comes from creating assets that earn while you sleep. Here are the top digital product categories you can build with Copilot + Claude:
1. Online Courses
Revenue potential: $97–$997+ per student
Claude creates: curriculum, lessons, quizzes, workbooks
Copilot formats: course slides, student guides, certificates
2. Ebooks and Guides
Revenue potential: $7–$47 per sale on Gumroad/Etsy/Amazon KDP
Claude creates: full manuscript, table of contents, chapter content
Copilot formats: professional Word document ready for KDP
3. Templates and Toolkits
Revenue potential: $17–$97 per bundle
Claude creates: content for templates, instructions, marketing copy
Copilot creates: Excel templates, Word templates, PowerPoint decks
4. Membership Communities
Revenue potential: $27–$97/month recurring
Claude creates: weekly content, prompts, tutorials
Copilot handles: member communications, reporting, organization
5. Consulting and Done-For-You Services
Revenue potential: $500–$5,000+ per project
Claude creates: proposals, strategies, content deliverables
Copilot handles: client presentations, project tracking, invoicing support
Key Insight: One product, created once with AI assistance, can sell indefinitely. That's the foundation of generational wealth.
Here is a step-by-step workflow to create a professional online course using both AI tools:
PHASE 1: Research and Outline (Claude)
1. Open Claude.ai
2. Prompt: 'I want to create a course called [Your Course Title] for [Target Audience]. Create a comprehensive 6-module curriculum with 3 lessons per module. Include module titles, lesson titles, and a 2-sentence description of each lesson.'
3. Review and refine the outline
4. Follow up: 'Now write a detailed lesson plan for Module 1, Lesson 1. Include: learning objectives, step-by-step content (800–1000 words), real-world example, and 3 reflection questions.'
PHASE 2: Content Development (Claude)
5. Repeat Lesson content creation for all lessons
6. Prompt Claude: 'Create a 10-question quiz for Module 1 with 4 answer choices each, correct answers, and brief explanations.'
7. Prompt: 'Write a 500-word introduction video script for this course. Make it engaging, establish credibility, and preview the key outcomes.'
PHASE 3: Formatting and Packaging (Copilot)
8. Paste content into Word → Use Copilot to 'Format this content with professional headings, callout boxes for key points, and consistent styling'
9. Open PowerPoint → Use Copilot to 'Create a slide deck from this lesson content with one key point per slide'
10. Use Copilot in Excel to create a student progress tracker
Time to complete a full course using this workflow: 3–7 days instead of 3–7 months.
Creating the product is only half the equation. You need the right platforms to monetize.
Platform Comparison:
ETSY (Digital Downloads)
- Best for: Templates, guides, printables, workbooks
- Fees: 6.5% transaction + $0.20 listing fee
- Audience: Millions of active buyers
- Copilot task: Use Excel to track Etsy sales and profit margins
GUMROAD
- Best for: Ebooks, courses, membership content
- Fees: 10% flat fee (lower with higher volume)
- Audience: Creator-focused buyers
- Claude task: Write your Gumroad product descriptions and email sequences
AMAZON KDP
- Best for: Print-on-demand books and ebooks (Kindle)
- Fees: Royalty split (35–70% depending on pricing)
- Audience: Massive global reach
- Copilot task: Format your Word manuscript to KDP specifications
YOUR OWN WEBSITE
- Best for: Courses, high-ticket offers, membership communities
- Fees: Platform hosting + payment processor fees only
- Audience: Your own email list and social followers
- Best tools: Teachable, Kajabi, ThriveCart
Monetization Strategy Stack:
1. Create core content with Claude
2. Package professionally with Copilot
3. List on Etsy/Gumroad for passive traffic
4. Build your email list to your own platform
5. Upsell to high-ticket coaching or membership
Once your first digital product is selling, it's time to scale. Here's the system:
The 3-Product Ladder:
1. Entry Product ($7–$27): Ebook, mini-guide, template bundle. Builds trust and grows your list.
2. Core Product ($97–$297): Full online course, coaching program, or comprehensive toolkit.
3. Premium Offer ($497–$2,000+): Done-for-you service, mastermind access, or VIP coaching.
Claude creates all three tiers of content. Copilot manages your business operations.
Content Multiplication Strategy:
- Create one core piece of content (e.g., a 10,000-word guide)
- Use Claude to repurpose it into: blog posts, social media content, email sequences, video scripts, podcast talking points, and a mini-course
- Use Copilot to format each version professionally
Step-by-step scaling workflow:
1. Week 1–2: Create and launch Entry Product on Etsy/Gumroad
2. Week 3–4: Use Copilot to analyze sales data, identify best-sellers
3. Month 2: Create Core Product using Claude content + Copilot formatting
4. Month 3: Launch to email list + promote on social media
5. Month 4+: Add Premium Offer for your most engaged customers
Generational wealth principle: Build systems, not just products. Every product you create with AI is an asset that works for your family's future.
Test your understanding of Copilot and Claude: The Powerhouse Tool Stack To Build Generational Wealth
Q1: According to the course, which AI tool is BEST for long-form content creation like courses and ebooks?
Q2: What is the first phase in the AI course creation workflow?
Q3: What platform is described as BEST for print-on-demand books with massive global reach?
Q4: In the 3-Product Ladder, what is the typical price range for a Core Product?
Q5: What does the course recommend using Copilot in Excel for in your business?
A strategic framework for finding where Copilot creates the most value in your organization
Most organizations underuse Copilot because they don't know where to start. This course gives you a proven framework to identify, prioritize, and implement the highest-impact Copilot use cases for your specific role, team, or organization—so you stop guessing and start seeing real results.
The best Copilot use cases always start with real pain. Before you think about features, think about frustrations.
The Pain Point Audit (step-by-step):
Step 1: Time Audit
1. For one week, track every task you complete
2. Note the time spent on each task
3. Categorize each as: Creative thinking, Relationship building, Data analysis, Writing/editing, Administrative, or Meetings
4. Highlight every task that feels repetitive, tedious, or manual
Step 2: Frustration Mapping
1. List your top 10 work frustrations
2. For each frustration, ask: 'Does this involve creating, editing, summarizing, or analyzing text or data?'
3. If yes: Copilot can likely help
4. If no: Copilot may not be the right solution
Step 3: Impact Scoring
For each potential use case, score 1–5 on:
- Time saved (5 = saves hours per week)
- Quality improvement (5 = dramatically better output)
- Frequency (5 = done daily)
- Ease of implementation (5 = can start today)
Use cases with total scores of 15+ are your highest priorities.
Common high-scoring use cases:
- Email drafting and response: 18–20 points
- Meeting summaries: 17–19 points
- Report first drafts: 16–18 points
- Data summarization: 15–17 points
Different roles have different high-impact Copilot use cases. Here are curated libraries by role:
HR PROFESSIONALS:
- Draft job descriptions from bullet points
- Summarize candidate interview notes
- Create onboarding documents and checklists
- Analyze employee survey data in Excel
- Draft policy documents and FAQs
FINANCE TEAMS:
- Summarize financial reports and flag anomalies
- Create narrative explanations of spreadsheet data
- Draft budget request justifications
- Generate variance analysis reports
- Prepare board presentation slides from data
MARKETING TEAMS:
- Draft campaign briefs and creative briefs
- Create social media content calendars
- Summarize competitor research
- Write A/B test copy variations
- Generate campaign performance reports
OPERATIONS MANAGERS:
- Create SOPs and process documents
- Summarize vendor proposals
- Draft project status reports
- Analyze KPI data in Excel
- Prepare training materials
Step-by-step to build your role-based use case library:
1. Download the use case template (in course resources)
2. List 10 potential use cases for your role
3. Score each using the Impact Scoring system
4. Select your top 3 to implement in the next 30 days
5. Document your results and share with your team
To build a business case for Copilot adoption (or to measure your own ROI), you need to calculate the real value.
The Copilot ROI Formula:
ROI = (Time Saved × Hourly Rate × Frequency) / Cost of Copilot License
Example calculation:
- Task: Writing weekly status reports
- Time before Copilot: 2 hours/week
- Time with Copilot: 30 minutes/week
- Time saved: 1.5 hours/week
- Employee hourly rate: $35/hour
- Weekly value: 1.5 × $35 = $52.50/week
- Annual value: $52.50 × 50 weeks = $2,625/year
- Copilot license cost: ~$360/year
- ROI: 629%
Step-by-step to calculate YOUR ROI:
1. Open Excel
2. List your top 5 Copilot use cases
3. For each, estimate: time before, time with Copilot, frequency per week
4. Add your approximate hourly rate
5. Use Copilot in Excel: 'Calculate the annual ROI for each use case using the formula: (Time Saved × Rate × 50 weeks) / 360'
6. Sort by highest ROI
7. Implement the top 3 use cases first
Pro tip: Track actual time savings for 30 days and compare to your estimates. Real data makes a compelling case for expanding Copilot to your whole team.
Once you've identified your highest-impact use cases, document them so you—and your team—can replicate success consistently.
The Use Case Playbook Template:
For each use case, document:
1. Use Case Name: (e.g., 'Weekly Status Report Generation')
2. M365 App: (e.g., Word + Teams)
3. Problem Solved: What pain point does this address?
4. Step-by-Step Process: Exact steps to complete the task with Copilot
5. Prompt Template: The exact prompt that works best
6. Time Before Copilot: Baseline measurement
7. Time With Copilot: Current measurement
8. Quality Notes: Any caveats, review steps, or limitations
9. Success Tips: What makes this use case work especially well?
Example playbook entry:
Use Case: Meeting Recap Generation
App: Microsoft Teams
Problem: Writing meeting minutes took 45–60 minutes after every meeting
Process: Enable transcription → Let Copilot run during meeting → Click Recap after meeting → Export to Word → Edit for accuracy
Prompt: 'Summarize this meeting. Include: key decisions made, action items with owners, open questions, and next steps. Format as a professional meeting minutes document.'
Time Before: 60 minutes
Time After: 10 minutes
Savings: 50 minutes per meeting
Scale your playbook:
1. Share with your immediate team
2. Host a 30-minute 'Copilot Lunch & Learn' to demo your top 3 use cases
3. Invite colleagues to contribute their own use cases
4. Build a shared OneNote or SharePoint page for your growing playbook
Test your understanding of Stop Guessing: How to Identify High-Impact Microsoft Copilot Use Cases
Q1: In the Impact Scoring system, what minimum total score indicates a high-priority use case?
Q2: What is the first step in the Pain Point Audit?
Q3: In the ROI formula, what does 'Time Saved × Hourly Rate × Frequency' calculate?
Q4: What does a Copilot Use Case Playbook entry include?
Q5: What is the recommended way to scale successful Copilot use cases to your team?
Connect the dots across apps to build seamless, end-to-end AI-powered workflows
Most Copilot users only use one app at a time. This course teaches you how to design connected, end-to-end workflows that flow across multiple Microsoft 365 apps—from data collection in Forms to analysis in Excel, to presentation in PowerPoint, to communication in Outlook and Teams.
An end-to-end Copilot workflow is a sequence of connected tasks across multiple Microsoft 365 apps where Copilot assists at each stage—creating a smooth, efficient process from start to finish.
Why single-app use falls short:
Most people use Copilot in isolation: draft an email here, summarize a document there. But the real power comes from chaining these capabilities into complete workflows.
Example: The Monthly Report Workflow
Without end-to-end design:
- Manually export Excel data → copy to Word → write report → make PowerPoint → email team → Takes 8+ hours
With end-to-end Copilot workflow:
- Excel: Copilot analyzes data and writes narrative summary (20 min)
- Word: Copilot drafts report using Excel summary (15 min)
- PowerPoint: Copilot creates deck from Word report (10 min)
- Outlook: Copilot drafts distribution email with report attached (5 min)
- Teams: Copilot summarizes report for quick team briefing (5 min)
- Total: 55 minutes instead of 8 hours
Workflow Design Principles:
1. Map your workflow from trigger to outcome
2. Identify every handoff between apps
3. Design a Copilot prompt for each stage
4. Test the full workflow before standardizing
5. Document the workflow in your Copilot Playbook
Before you can design a Copilot workflow, you need to map your current process. Here's how:
The FLOW Method:
F = Find the trigger (What starts the workflow?)
L = List every step (What happens next, and next, and next?)
O = Overlay Copilot (At which steps can Copilot help?)
W = Write your prompts (What will you say to Copilot at each step?)
Step-by-step workflow mapping exercise:
1. Choose a recurring workflow (e.g., weekly team report, client onboarding, budget review)
2. On paper or in Visio/Miro, draw each step as a box
3. Connect the boxes with arrows showing the sequence
4. Color-code steps: Green = Copilot can help, Red = Human-only required
5. For each green step, write a draft Copilot prompt
6. Estimate time before and after Copilot for each green step
7. Calculate total time savings
Example workflow map for 'New Employee Onboarding':
Trigger: New hire start date confirmed
→ HR creates welcome email (Copilot in Outlook: 5 min)
→ IT creates access checklist (Copilot in Word: 10 min)
→ Manager creates 30-day plan (Copilot in Word: 15 min)
→ First week schedule created (Copilot in Outlook: 5 min)
→ Training materials assembled (Copilot in SharePoint: 20 min)
→ Onboarding meeting scheduled (Copilot in Teams: 5 min)
Total with Copilot: 60 min | Total without: 4+ hours
Use Case: Preparing a comprehensive executive briefing from multiple data sources.
Step-by-step workflow:
Step 1 – Data Gathering (Excel)
1. Open your KPI spreadsheet
2. Click Copilot → 'Analyze this data and identify the 5 most significant trends or changes this month'
3. Copy the Copilot analysis text
Step 2 – Report Drafting (Word)
4. Open a new Word document
5. Prompt Copilot: 'Create an executive briefing document. Include: Executive Summary, Key Findings, Performance vs. Target, Notable Risks, and Recommended Actions. Use formal business language. Here is the data analysis: [paste Excel Copilot output]'
6. Edit for accuracy and add specific figures
Step 3 – Presentation Creation (PowerPoint)
7. Open PowerPoint
8. Prompt Copilot: 'Create a 10-slide executive briefing presentation from this Word document. Include one key message per slide. Use a clean, professional layout.'
9. Refine visuals and data labels
Step 4 – Distribution (Outlook + Teams)
10. Outlook: 'Draft an email to senior leadership sharing the attached briefing. Highlight 3 key takeaways. Keep it under 100 words.'
11. Teams: 'Summarize this briefing in 5 bullet points for our Teams channel post'
Total time with Copilot: ~90 minutes. Without Copilot: typically 6–8 hours.
Use Case: Managing a client project from proposal through delivery.
Step-by-step workflow:
Phase 1 – Proposal (Word + Copilot)
1. Prompt: 'Create a professional project proposal for [Client Name]. Project: [Project Description]. Include: Project Overview, Scope of Work, Deliverables, Timeline (8 weeks), Investment, and Terms. Use a confident, client-focused tone.'
2. Customize with your specific pricing and terms
3. Save as PDF for client delivery
Phase 2 – Kickoff Meeting (Teams + Copilot)
4. Enable transcription in the kickoff meeting
5. After meeting: Use Recap to generate meeting notes, decisions, and action items
6. Prompt: 'Convert these meeting notes into a formal kickoff summary document with assigned action items and due dates'
Phase 3 – Status Updates (Outlook + Copilot)
7. Weekly: Open your project notes
8. Prompt: 'Draft a client status update email. Progress this week: [your bullet points]. Keep it professional, positive, and under 200 words. Highlight completed milestones.'
Phase 4 – Project Delivery (Word + PowerPoint + Copilot)
9. Compile final deliverables
10. Prompt in PowerPoint: 'Create a project closeout presentation highlighting: goals achieved, key outcomes, lessons learned, and recommended next steps'
11. Prompt in Outlook: 'Draft a project completion email to the client expressing gratitude, summarizing outcomes, and inviting feedback'
Microsoft 365 Business Chat (formerly BizChat) is Copilot's most powerful feature—it can access data across ALL your M365 apps simultaneously.
What Business Chat can do:
- 'Catch me up on everything that happened with Project X this week' → Searches emails, chats, documents, and meetings
- 'What are my priorities for today based on my emails and calendar?' → Analyzes inbox and calendar together
- 'Create a summary of all documents related to our Q3 budget review' → Finds and synthesizes multiple files
Step-by-step for Business Chat:
1. Open Microsoft Teams
2. Click the Copilot icon at the top of the screen
3. This opens Business Chat—your cross-app Copilot
4. Type natural language queries that span multiple apps
5. Copilot retrieves and synthesizes information from across your M365 environment
Powerful Business Chat prompts:
- 'Summarize all emails and Teams messages from [Client Name] in the past two weeks'
- 'What meetings do I have next week and what preparation do I need based on related documents?'
- 'Find all documents I've worked on related to [Topic] and give me a brief overview of each'
- 'Who on my team has the most capacity this week based on their calendars?'
Business Chat transforms Copilot from a single-app assistant into a true organizational intelligence tool.
Test your understanding of Designing a High-Impact Copilot Workflow Across Microsoft 365
Q1: What does the 'F' stand for in the FLOW workflow mapping method?
Q2: How much time does the course estimate for the Executive Briefing Workflow using Copilot?
Q3: What makes Microsoft 365 Business Chat uniquely powerful compared to single-app Copilot?
Q4: In the color-coding system for workflow maps, what does GREEN indicate?
Q5: What is the LAST step in the Client Project Workflow?
Cut through the hype with real, practical AI techniques for everyday professionals
AI is everywhere—but most people still don't know how to use it effectively at work. This course cuts through the hype and gives you real, practical AI techniques using Microsoft Copilot and other AI tools to save time daily, produce better work, and finally feel in control of your AI tools.
Before we dive into how to use AI, let's get clear on what it actually is—and isn't.
What AI IS:
- A powerful pattern-recognition system trained on enormous amounts of text
- An assistant that can generate, summarize, analyze, and transform content
- A force multiplier for skilled professionals
- A tool that improves with better instructions
What AI IS NOT:
- A replacement for your expertise, judgment, or relationships
- A system that 'knows' things the way you do
- Always accurate—it can and does make mistakes
- A thinking machine—it predicts likely text, not 'thinks' in the human sense
The Realistic AI Time-Savings Chart:
- Email drafting: Save 15–25 min/day
- Meeting summaries: Save 30–60 min/day
- Report writing: Save 1–3 hours/week
- Data analysis: Save 2–4 hours/week
- Research and summaries: Save 1–2 hours/week
- Total potential savings: 5–10+ hours per week
Your AI Quick Start (do this today):
1. Choose ONE task from the list above
2. Open Copilot in the relevant M365 app
3. Try using AI for that ONE task
4. Note: how was the output? What would you change in your prompt?
5. Try again with an improved prompt
6. Measure your actual time savings
The goal: Save just 30 minutes today using AI. Build from there.
You don't need to use every AI tool. You need to use the RIGHT tool for each task.
AI Tool Decision Guide:
For Microsoft 365 work tasks:
→ Use Microsoft Copilot (integrated into your apps)
For deep research and long content creation:
→ Use Anthropic Claude (claude.ai)
For web search with AI answers:
→ Use Microsoft Copilot with Bing or Google's AI Overviews
For image creation:
→ Use Microsoft Designer (integrated with Copilot)
For code generation:
→ Use GitHub Copilot or Claude
For general questions and brainstorming:
→ Any major AI: Copilot, Claude, or ChatGPT
Step-by-step to build your personal AI toolkit:
1. List your top 5 work tasks
2. For each task, identify which tool from the guide above is best
3. Set up access to those tools (Copilot is in your M365 apps; Claude is at claude.ai)
4. Bookmark your primary tools
5. Create a simple 'AI Cheat Sheet' with your top tools and their best uses
Rule of thumb: Microsoft Copilot for anything already in your Microsoft 365 workflow. Claude for everything else requiring deep thinking or long-form content.
Most people give AI one prompt and accept whatever comes back. The professionals who get extraordinary results use iterative prompting—they treat AI like a conversation, not a one-shot command.
The Iterative Prompting Method (4 rounds):
Round 1: The Rough Draft
→ Give a clear prompt: 'Write a product description for a time management online course for busy professionals. Include key benefits and a call-to-action.'
→ Review: Is the structure right? Is the content on track?
Round 2: Direction Correction
→ 'Good start. Now make it more urgent and specific. Add statistics about time wasted at work. Make it feel like the reader absolutely needs this course.'
Round 3: Refinement
→ 'Shorten it by 30%. Remove any corporate-sounding phrases. Make every sentence earn its place.'
Round 4: Final Polish
→ 'Rewrite the opening hook. It needs to grab attention in the first 5 words. Give me 3 alternative opening lines to choose from.'
Result: A polished, compelling piece of writing that would have taken you an hour—completed in 10 minutes.
Key principles:
- Don't accept the first output—always iterate
- Give specific feedback, not just 'make it better'
- Each round should have one clear goal
- Stop when the output meets your standard
One of the most underused applications of AI at work is as a thinking partner for decisions. Copilot and Claude can help you think through options, anticipate risks, and make better choices.
Step-by-step AI decision support workflow:
For complex decisions:
1. Open Claude or Copilot
2. Describe your decision: 'I need to decide between two options for [situation]. Here are the details: [Option A], [Option B]. What are the pros and cons of each? What factors should I consider that I might be missing?'
3. Ask for steelman arguments: 'Make the strongest possible case for Option A. Now do the same for Option B.'
4. Ask about risks: 'What are the top 3 risks of choosing Option A? How could I mitigate each?'
5. Ask for a recommendation: 'Based on this analysis, if you were advising me, which option would you lean toward and why?'
6. Make YOUR decision with AI-enhanced perspective
For writing decisions:
- 'I've written two versions of this proposal opening. Which is more compelling and why?'
- 'Review this email. What is the likely emotional reaction of the recipient?'
For strategic decisions:
- 'What questions should I be asking before making this hiring decision?'
- 'What am I likely not considering about this market expansion plan?'
AI as a thinking partner doesn't replace your judgment—it sharpens it.
Change doesn't happen overnight. This 30-day plan helps you systematically build AI into your work routine so it becomes second nature.
Week 1: Awareness
Day 1–2: Complete this course and identify your top 3 use cases
Day 3–5: Try each use case once—don't worry about perfection
Day 6–7: Reflect: What worked? What didn't? What would you change?
Week 2: Practice
Day 8–10: Use AI for your #1 use case every day. Refine your prompt each time.
Day 11–12: Add your #2 use case to your daily workflow
Day 13–14: Measure time savings for both use cases
Week 3: Expansion
Day 15–17: Add your #3 use case
Day 18–19: Experiment with one new use case outside your original list
Day 20–21: Share what's working with a colleague
Week 4: Systemization
Day 22–24: Document your best prompts in a personal prompt library
Day 25–27: Create your personal Copilot Playbook
Day 28–30: Identify 3 new use cases for Month 2
Success metrics for Day 30:
☐ Using AI for at least 3 work tasks daily
☐ Have 10+ saved prompt templates
☐ Saving at least 1 hour per day
☐ Feel confident, not confused, when opening Copilot
Remember: The goal isn't to use AI for everything. It's to use AI for the right things—and do it well.
Test your understanding of AI at Work: How to Actually Use AI to Save Time, Work Smarter, and Get More Done
Q1: According to the course, how many hours per week could AI realistically save a professional who uses it consistently?
Q2: How many rounds are in the Iterative Prompting Method?
Q3: When should you use Anthropic Claude instead of Microsoft Copilot?
Q4: What is the goal for 'Week 1: Awareness' in the 30-Day AI Integration Plan?
Q5: When using AI for decision support, what does 'steelmanning' mean?