MS-4018: Draft, Analyze, Present Microsoft 365 Copilot

MS-4018: Microsoft 365 Copilot Productivity Labs

Work Smarter with AI in Microsoft 365

Take your productivity to the next level with Microsoft 365 Copilot—your AI-powered assistant across Word, PowerPoint, Excel, Teams, Outlook, and Chat. In this hands-on, instructor-led course, you'll complete guided labs that show you exactly how to automate everyday tasks, generate impactful content, and make data-driven decisions faster than ever.

What You’ll Learn:

Create polished documents and presentations with AI in Word and PowerPoint
Collaborate and communicate clearly using Copilot in Teams and Outlook
Analyze and visualize data instantly in Excel
Use Copilot Chat to research, draft, and prepare for meetings or interviews

Why Take This Course?
Whether you're a busy professional, team leader, or business decision-maker, this course helps you get real results with the tools you already use—faster, easier, and smarter.

Duration: 1 day
Skill Level: Intermediate (200–300 level)
Includes: AI-led instruction, interactive labs, and post-lab assessments
Format: Online with hands-on Copilot exercises

Get started today and discover what’s possible with Microsoft 365 Copilot.
Maximize your subscription. Minimize your effort.

Category: Business and Productivity
Level: Foundational
Time Estimate: 3h 0m
Price: $29.99 for 1 months of access
Lab Environment: Included

MS-4018: Draft, Analyze, Present Microsoft 365 Copilot Badge

Lessons in this Course

Lesson: Draft, Analyze, Present Microsoft 365 Copilot

In this course, you’ll complete five guided hands-on labs, each designed to demonstrate real-world applications of Microsoft 365 Copilot across different tools:

Build a Presentation with Copilot in PowerPoint
Learn how to generate a professional slide deck from a Word document, insert images, organize content, and apply branding using AI prompts.
Draft and Refine a Document with Copilot in Word
Use Copilot to draft a business report, rewrite paragraphs for clarity and tone, convert lists into tables, and summarize content effectively.
Collaborate with Your Team Using Copilot in Teams and Outlook
Improve team communication by rewriting messages with the right tone, drafting meeting invites, and scheduling with AI assistance.
Analyze Sales Data with Copilot in Excel
Explore sales trends, compare product performance, calculate totals, and uncover insights using charts and AI-driven summaries.
Boost Personal Productivity with Copilot Chat
Prepare for a job interview by researching a company and role, generating sample questions and answers, and compiling your notes into a reusable FAQ.

Each exercise is designed to stand alone, allowing learners to gain immediate, practical experience with AI-enhanced features in Microsoft 365.

Duration: 3 h 0 m

Exercises

Lab 1: Build a presentation from start to finish with Copilot in PowerPoint Imagine you're a marketing manager at a company called Contoso. Your team is preparing for an important client meeting where you need to present the company's strategy for a new Chai Tea product line to be sold in Latin America Your goal is to create a compelling presentation that highlights the product's features, benefits, and use cases, while ensuring it adheres to the company's branding standards. You've already developed a business plan for this product, and want to use that content when preparing for your meeting. You need to collaborate with your team and get the presentation reviewed by your manager before the meeting. By the end of this Lab, you'll be able to create a new presentation, based on a Word document, insert an image, edit text, organize the presentation, incorporate corporate branding standards, and send the draft presentation to your manager for review using Copilot in PowerPoint. Estimated Time: 30 minutes

Lab 2: Draft, improve, and share your document with Copilot in Word Imagine you're a project manager tasked with creating a comprehensive project report for your company's new Mystic Spice Premium Chai Tea. In this Lab, you use Microsoft Word to draft the report, (optionally) import notes from OneNote, and share the draft with your team via Microsoft Teams or Microsoft Outlook for feedback and collaboration. Estimated Time: 20 minutes

Lab 3: Manage collaboration from start to finish Imagine you're a manager at Contoso. Your team relies on effective communication to collaborate and achieve goals. You want to rally the team behind a new idea for the Contoso Connect product launch, and need to send a message to your team about how to incorporate this idea before the product launch deadline. Use Copilot to draft, rewrite, and adjust your message to ensure it's clear, concise, and professional. Estimated Time: 20 minutes

Lab 4: Boost your productivity with data-driven decisions with Copilot in Excel Imagine you're a sales manager at Contoso. Your primary responsibility is to analyze sales data and identify trends that can help improve the company's performance. In this hands-on Lab, you'll use Copilot in Excel to explore and analyze various aspects of the sales data for Contoso's Chai products. You'll start by getting an overview of the data and identifying key metrics. Next, you'll analyze sales trends, compare product sales, and calculate total sales. Additionally, you'll examine the relationship between social media engagement and chai sales, and identify any correlations between online searches and sales. Finally, you'll generate insights from your analysis and summarize the key findings. Estimated Time: 20 minutes

Lab 5: Ace your interview with Copilot Chat Imagine you're interviewing for position at Contoso, a mid-sized media-driven company. You've been communicating with the hiring manager via email. Now, you want to prepare for the interview, learn more about the team you'll be working with, and draft answers to potential questions that you may be asked. This Lab guides you through the steps to ensure you're well-prepared and confident. Estimated Time: 20 minutes