10-15 Minute Lesson Script
Introduction (2 minutes)
Welcome to Lesson 5—the final lesson of Phase 1! You’ve come so far in just five weeks. You’ve learned how to talk to AI, craft powerful prompts, iterate like a pro, and compare different AI tools to find what works for you.
Now it’s time to meet an AI tool that’s a little different from the ones you’ve used so far: Microsoft Copilot.
Here’s what makes Copilot special: instead of being a separate website you visit, Copilot lives inside the Microsoft tools you might already use—Word, Excel, Outlook, PowerPoint, and more. It’s like having an AI assistant built right into your workspace.
If you use Microsoft products for work, personal projects, or organizing your life, this lesson is going to be a game-changer. Even if you don’t use Microsoft tools regularly, understanding how AI can integrate directly into the software you use will help you see the bigger picture of where AI is heading.
By the end of this lesson, you’ll know how to use Copilot to work faster and smarter in the Microsoft apps you already know.
Let’s dive in!
What Is Microsoft Copilot? (3 minutes)
Microsoft Copilot is AI assistance built directly into Microsoft 365 apps. Think of it as having ChatGPT’s helpful capabilities, but instead of switching between windows and copy-pasting, the AI is right there in your document, spreadsheet, or email.
There are actually two versions of Copilot you should know about:
1. Microsoft Copilot (Free/Web Version)
This is available at copilot.microsoft.com. It works like ChatGPT or Claude—you ask questions, it responds. It’s powered by technology similar to ChatGPT but includes web search capabilities like Gemini.
2. Microsoft 365 Copilot (Integrated Version)
This is the premium version that’s built into Word, Excel, PowerPoint, Outlook, and Teams. This requires a Microsoft 365 subscription plus an additional Copilot license. This is the powerful version we’ll focus on today.
Why does this matter?
Traditional AI tools require you to:
- Write something in Word
- Copy it
- Go to ChatGPT or Claude
- Ask for improvements
- Copy the response back
- Paste it into Word
With Copilot in Word, you just:
- Highlight your text
- Ask Copilot to improve it
- Done—it happens right in the document
It’s the same helpful AI, but without the copy-paste dance.
Copilot in Word: Your Writing Assistant (3 minutes)
Let’s start with Word, since most people use it for writing documents, letters, and reports.
What Copilot can do in Word:
Draft entire documents from a prompt:
You can tell Copilot: “Write a 2-page proposal for a community garden project” and it will generate a full draft right in your document. You can then edit, refine, and personalize it.
Rewrite and improve your text:
Highlight any paragraph and ask Copilot to:
- Make it more professional
- Make it more casual
- Make it shorter
- Make it more persuasive
- Simplify the language
Summarize long documents:
Have a 20-page report you need to understand quickly? Ask Copilot to summarize the key points in bullet form.
Generate ideas and outlines:
Starting a document but not sure how to organize it? Ask Copilot to create an outline based on your topic.
Real-world example:
Imagine you’re writing an email newsletter in Word. You’ve written the first draft, but it feels too stiff.
Old way:
Copy the text, open ChatGPT, ask it to rewrite in a friendlier tone, copy the response, paste it back.
With Copilot:
Highlight the text, click Copilot, type “Make this more conversational and warm,” press Enter. Done in 10 seconds.
Copilot in Excel: Your Data Helper (3 minutes)
Excel can be intimidating if you’re not a spreadsheet expert. Copilot makes it dramatically easier.
What Copilot can do in Excel:
Analyze your data and create insights:
You can ask: “What are the trends in this sales data?” and Copilot will analyze the numbers and tell you what it sees.
Create formulas for you:
Instead of trying to remember Excel formula syntax, just describe what you want: “Calculate the average of column B” or “Show me which rows have values over 100.”
Generate charts and visualizations:
Tell Copilot: “Create a chart showing monthly expenses” and it will suggest and create appropriate visualizations.
Clean and organize data:
Ask Copilot to: “Remove duplicate rows” or “Sort this by date, newest first.”
Real-world example:
You’re tracking expenses for a volunteer organization in Excel. You want to know which category you’re spending the most on.
Old way:
Struggle with formulas, maybe give up and add it manually, or search YouTube for “how to sum categories in Excel.”
With Copilot:
Click Copilot and type: “Which category has the highest total?” Copilot analyzes your data and tells you the answer in plain English, plus shows you how it calculated it.
Copilot in Outlook: Your Email Assistant (2 minutes)
Email can eat up so much time. Copilot in Outlook helps you get through your inbox faster.
What Copilot can do in Outlook:
Draft emails from brief instructions:
Tell Copilot: “Write a polite email declining a meeting invitation for next Tuesday” and it creates a professional draft you can personalize.
Summarize long email threads:
Got a conversation with 15 replies? Ask Copilot: “Summarize this thread” and it will give you the key points and action items.
Adjust tone:
Wrote an email but it sounds too harsh? Tell Copilot to make it friendlier. Too casual? Ask for a more professional version.
Suggest replies:
Copilot can read an email and suggest appropriate responses based on context.
Real-world example:
Someone sent you a long, detailed email about a project. You need to respond but you’re short on time.
With Copilot:
Click “Summarize” to see the key points, then click “Draft reply” and tell Copilot: “Say yes to the project, ask about the timeline, and thank them for the detailed explanation.” Edit the draft Copilot creates, and send.
Time saved: 10 minutes.
Copilot in PowerPoint: Your Presentation Partner (2 minutes)
Creating presentations from scratch can be time-consuming. Copilot speeds up the process significantly.
What Copilot can do in PowerPoint:
Create entire presentations from a prompt:
Tell Copilot your topic and how many slides you need, and it will generate a complete presentation with text, suggested layouts, and design.
Add slides based on content:
Tell Copilot: “Add a slide about project benefits” and it creates an appropriate slide with content.
Summarize existing presentations:
Need to understand a presentation someone sent you? Ask Copilot to summarize the key points.
Improve design and layout:
Copilot can suggest better layouts, improve visual hierarchy, and make slides more professional-looking.
Real-world example:
You need to create a 10-slide presentation about your hobby for a club meeting.
Old way:
Spend 2 hours creating slides from scratch, searching for images, formatting everything.
With Copilot:
Tell Copilot: “Create a 10-slide presentation about watercolor painting for beginners, including history, basic techniques, and materials needed.” Copilot generates the full presentation in minutes. You spend 30 minutes personalizing it with your own photos and experiences.
Time saved: 90 minutes.
How to Get Started with Copilot (2 minutes)
If you want to try the free web version:
Just go to copilot.microsoft.com and start asking questions. It works like ChatGPT but includes web search. No subscription needed.
If you want Copilot in your Microsoft apps:
You’ll need:
- A Microsoft 365 subscription (Personal, Family, or Business)
- The Copilot add-on (additional monthly cost)
Is it worth the cost?
That depends on how much you use Microsoft tools:
You might love it if you:
- Spend significant time in Word, Excel, or Outlook daily
- Write a lot of documents, emails, or reports
- Work with data or spreadsheets regularly
- Create presentations frequently
- Value time-saving tools for work or personal projects
You might skip it if you:
- Rarely use Microsoft Office apps
- Prefer Google Workspace (Docs, Sheets)
- Are happy using free AI tools separately
- Don’t want another monthly subscription
Many people start with the free web version to test if they like Microsoft’s AI approach before investing in the full integrated version.
The Big Picture: Integrated AI (1 minute)
Here’s what’s important to understand: Microsoft Copilot represents where AI is heading—integration directly into the tools we already use.
This same pattern is happening everywhere:
- Google has AI in Google Docs and Sheets
- Canva has AI design tools built in
- Adobe has AI in Photoshop
- Many apps are adding AI features
The future isn’t about switching to a separate AI tool for every task. It’s about AI being woven into your existing workflow, helping you work faster without changing how you work.
Microsoft Copilot is one of the most developed examples of this trend, but it’s just the beginning.
Wrapping Up (1 minute)
Congratulations! You’ve completed Phase 1 of your AI learning journey. You now understand:
- How to communicate with AI effectively
- How to craft powerful prompts and iterate
- The differences between major AI tools
- How AI can integrate into your existing software
You’ve built a strong foundation. In Phase 2, we’re going to get visual—exploring AI tools that help you create images, graphics, and visual content.
But first, take a moment to celebrate. Five weeks ago, AI might have felt mysterious or intimidating. Now you have real skills and practical knowledge. That’s incredible progress!
See you in Phase 2!
3-5 Key Takeaways
- Microsoft Copilot brings AI directly into your workspace – Instead of switching between apps and copy-pasting, Copilot works inside Word, Excel, Outlook, and PowerPoint, making your workflow faster and smoother.
- Copilot does different things in different apps – In Word it helps with writing and editing, in Excel it helps with data analysis and formulas, in Outlook it manages emails, and in PowerPoint it creates presentations. Understanding what each version does helps you use it effectively.
- There’s a free version and a premium version – The web version (copilot.microsoft.com) is free and works like ChatGPT with web search. The integrated version in Microsoft 365 apps requires a subscription but offers seamless workflow integration.
- Integrated AI is the future – Microsoft Copilot represents a bigger trend: AI being built directly into the tools we already use rather than existing as separate services. This pattern is spreading across many platforms and applications.
- The value depends on your usage – If you spend significant time in Microsoft apps, Copilot can save hours per week. If you rarely use these tools or prefer alternatives like Google Workspace, the free AI tools you’ve already learned might be sufficient.
2-3 Practical Examples/Case Studies
Example 1: Barbara’s Volunteer Newsletter
Background: Barbara, 64, manages communications for her local library’s volunteer group. Every month she writes a newsletter in Word, creates a summary email in Outlook, and maintains an Excel spreadsheet of volunteer hours.
Her old process (without Copilot):
- Spend 2 hours writing newsletter in Word
- Copy sections to ChatGPT to improve tone
- Paste back, format, repeat
- Copy newsletter content to Outlook
- Rewrite it to work as an email
- Manually calculate volunteer hours in Excel
- Total time: 4-5 hours
Her new process (with Copilot):
In Word:
- Started with bullet points of what to include
- Asked Copilot: “Turn these notes into a friendly 2-page newsletter for library volunteers, warm and appreciative tone”
- Copilot generated full draft
- Made personal edits and added specific volunteer names
- Time: 45 minutes
In Outlook:
- Asked Copilot: “Create an email version of this newsletter, keeping it under 300 words, highlight the upcoming book sale”
- Copilot adapted the content perfectly
- Time: 5 minutes
In Excel:
- Asked Copilot: “Calculate total hours by volunteer and identify top 5 contributors this month”
- Got instant answer with a summary table
- Time: 2 minutes
Total new time: About 1 hour
Key lesson: Barbara saved 3-4 hours per month by using Copilot’s integrated features instead of switching between tools. The subscription pays for itself in time saved.
Example 2: James’s Small Business Reports
Background: James, 55, runs a small landscaping business and needs to send monthly reports to a few commercial clients.
His challenge: He’s good at landscaping, not great at writing professional reports. He’d been using ChatGPT but found the copy-paste workflow frustrating.
His Copilot workflow:
Step 1 – Gather notes: Types rough notes in Word: “Completed fall cleanup at Johnson property. Trimmed 12 trees. Planted 40 bulbs. Repaired irrigation zone 3. Invoice $2,400.”
Step 2 – Transform notes: Asks Copilot: “Turn these notes into a professional client update email. Polite and confident tone. Include a thank you.”
Copilot creates: “Dear Mr. Johnson, I’m pleased to update you on the fall maintenance completed at your property this week…” [full professional email]
Step 3 – Adjust if needed: “Make it slightly more casual—we’ve worked together for 5 years”
Step 4 – Create invoice summary: In Excel, asks Copilot: “Create an invoice summary showing services and costs”
Total time: 15 minutes instead of an hour of struggling
The result: James’s clients have commented on how professional his communications have become. He’s more confident sending reports, and he’s saved hours every month.
Key lesson: For someone who’s not a natural writer, having AI assistance built directly into Word and Excel removes the friction and embarrassment of struggling with professional communication.
Example 3: Rita’s Presentation Rescue
Background: Rita, 59, volunteers with a community garden project. She was asked to present to the city council about expanding the program—with only 48 hours’ notice.
Her panic moment: She’d never created a formal presentation before and had no idea where to start.
How Copilot saved her:
In PowerPoint, she told Copilot: “Create a 12-slide presentation about our community garden program. Include: what we do, impact on the neighborhood, volunteer participation, why we need expansion, and what we’re asking for. Professional but warm tone.”
Copilot generated:
- A complete presentation structure
- Slide titles and content for all 12 slides
- Suggested layouts
- Professional design
Rita then:
- Added her own photos of the garden
- Modified numbers to match their actual data
- Personalized the stories about specific volunteers
- Ran it by Copilot one more time: “Make the ‘asking for support’ slide more persuasive but not pushy”
Total time: 3 hours (including gathering photos and data)
Without Copilot: Rita estimates it would have taken her 2 full days and probably would have looked much less professional.
The outcome: The city council approved the expansion request. One council member specifically mentioned how clear and well-organized the presentation was.
Key lesson: Copilot doesn’t replace your expertise and personal touch—it handles the structure and formatting so you can focus on adding the meaningful content only you can provide. For high-stakes situations with tight deadlines, this is invaluable.
1 Hands-On Activity
Activity: “The Copilot Test Drive”
Time needed: 30-40 minutes
Objective: Experience Microsoft Copilot’s capabilities hands-on by testing it with real tasks you’d actually use.
Note: This activity offers options based on what access you have. Don’t worry if you can’t do everything—just do what you can with what’s available to you.
Part 1: Set Up (5 minutes)
Option A – If you have Microsoft 365 with Copilot:
Great! You can test everything.
Option B – If you have Microsoft 365 but not Copilot:
You can still follow along conceptually, and you can test the free web version.
Option C – If you don’t have Microsoft 365:
Go to copilot.microsoft.com (free) and you can still test the conversational AI features with web search.
For this activity, we’ll provide tasks for all scenarios.
Part 2: Test Writing Assistance (10 minutes)
If you have Copilot in Word:
- Open a new Word document
- Click the Copilot icon
- Try this prompt: “Write a 200-word friendly email to my book club suggesting we read [pick any book] next month. Explain why it’s a good choice.”
- Watch Copilot generate the draft
- Now try: “Make this more enthusiastic” or “Make this shorter”
- Notice how easy it is to iterate right in the document
If you’re using the free web version:
- Go to copilot.microsoft.com
- Ask the same prompts above
- Notice that you’d need to copy-paste the results into Word
- This shows you the difference between integrated AI and standalone AI
Reflection question:
How much time would integrated AI save you if you write documents, emails, or reports regularly?
Part 3: Test Data/Organization Help (10 minutes)
If you have Copilot in Excel:
- Open Excel and create a simple list (or use an existing spreadsheet)
- Example: Make a list of expenses with columns for Date, Category, Amount
- Add 10-15 sample entries
- Click Copilot and ask: “What’s the total amount spent on [category]?”
- Ask: “Which category has the highest spending?”
- Ask: “Create a summary showing totals by category”
If you’re using the free web version or don’t have Excel:
Create a simple list in a note or document, then ask Copilot: “I have these expenses: [list them]. Calculate the total for each category and tell me where I’m spending most.”
See how Copilot can help organize information even without being in Excel.
Reflection question:
What data or information in your life could benefit from this kind of quick analysis?
Part 4: Test Email/Communication Help (10 minutes)
For everyone (any version):
Think of a real email or message you need to send (or have recently sent). Test Copilot’s ability to help:
Scenario A – Drafting:
“Write an email to [recipient] about [topic]. Tone should be [professional/friendly/apologetic]. Include [specific points to mention].”
Scenario B – Improving:
Paste an email you’ve written and ask: “Make this more [concise/professional/warm/clear].”
Scenario C – Responding:
Paste an email someone sent you and ask: “Draft a polite response saying [your key message].”
Try all three scenarios and notice:
- How accurate were the drafts?
- How much editing did you need to do?
- Did Copilot capture the right tone?
- How much time did this save compared to writing from scratch?
Part 5: Compare Integrated vs. Standalone (5 minutes)
If you have integrated Copilot:
Think about your workflow today. List 3 tasks where having AI built directly into your apps would save you time.
If you’re using the free version:
Imagine how your workflow would change if AI was integrated into your most-used apps instead of requiring you to switch windows and copy-paste.
For everyone – Reflection questions:
- What’s the biggest advantage of integrated AI (Copilot in apps)?
Likely answer: Faster workflow, no copy-pasting, context awareness - What’s the biggest advantage of standalone AI (ChatGPT, Claude)?
Likely answer: Free, platform-independent, can use anywhere - For your specific needs, which approach is more valuable?
- Is the Copilot subscription worth it for you?
Consider:- How often you use Microsoft apps
- How much time you could save
- Whether the cost matches the value
Part 6: Create Your Decision Framework (5 minutes)
Based on your testing, create a simple personal guide:
I will use Microsoft Copilot for:
- [List specific tasks]
- Example: “Writing monthly reports in Word”
I will stick with free AI tools (ChatGPT/Claude/Gemini) for:
- [List specific tasks]
- Example: “Quick brainstorming when I’m not at my computer”
My action plan:
- Keep using free tools—they work great for my needs
- Try Copilot web version regularly to see if I want more
- Invest in Copilot subscription because I use Office apps daily
- Wait and revisit this decision in [timeframe]
3 Quiz Questions with Answers
Question 1
What is the main difference between Microsoft Copilot and AI tools like ChatGPT or Claude?
A) Copilot is more powerful and can do more things
B) Copilot is integrated directly into Microsoft apps like Word and Excel
C) Copilot is always free while others cost money
D) Copilot only works on Windows computers
Answer: B – Copilot is integrated directly into Microsoft apps like Word and Excel
Explanation: The key difference isn’t power or cost—it’s integration. Microsoft Copilot (the premium version) works inside Word, Excel, Outlook, and PowerPoint, eliminating the need to switch between apps and copy-paste content. This makes workflows faster and smoother. ChatGPT, Claude, and Gemini are standalone tools that require you to leave your work to use them. Both approaches have value depending on your needs and workflow.
Question 2
Which scenario would benefit MOST from Microsoft 365 Copilot rather than free AI tools?
A) Occasionally asking questions about random topics
B) Writing and editing multiple documents daily in Microsoft Word for work
C) Having casual conversations with AI for fun
D) Trying AI for the first time to see if you like it
Answer: B – Writing and editing multiple documents daily in Microsoft Word for work
Explanation: Copilot’s value is highest when you regularly use Microsoft apps for important, frequent tasks. If you’re writing documents daily in Word, the integrated assistance saves significant time compared to copying content to ChatGPT and back. For occasional questions, casual conversations, or first-time experimentation, free standalone tools are more practical and cost-effective. The subscription cost makes sense when the time savings are substantial and consistent.
Question 3
If you don’t have a Microsoft 365 subscription with Copilot, what’s the best way to experience Microsoft’s AI?
A) You can’t use any Microsoft AI without paying
B) Use the free web version at copilot.microsoft.com
C) Microsoft AI doesn’t exist in free form
D) Buy the most expensive subscription immediately
Answer: B – Use the free web version at copilot.microsoft.com
Explanation: Microsoft offers a free web-based version of Copilot at copilot.microsoft.com that works like ChatGPT but includes web search capabilities. This lets you test Microsoft’s AI approach without any subscription. While it doesn’t integrate into Office apps like the premium version, it’s a great way to see if you like Microsoft’s AI style before investing in the full subscription. Always start with free options to test before committing to paid tools.