Microsoft 365 Copilot Essentials & Foundations for Beginners

In this lecture, learners will discover the different ways an end user can access Microsoft 365 Copilot across Word, Excel, Outlook, Teams, and the Microsoft 365 web portal. You’ll learn where Copilot appears in each app, how to recognize Copilot-enabled features, and how to verify that your account has access. By the end, students will confidently know how to launch Copilot in their daily workflow without any technical steps or admin setup.

In this lecture, learners will walk through the exact steps to verify whether Copilot is enabled on their Microsoft 365 account. You’ll see a practical, real-time demo showing how to open Word, Excel, and other Office apps, navigate to the Account settings, and review the Product Information section to confirm license availability. By the end, students will know how to quickly diagnose Copilot access issues on their own without relying on IT support.

In this lecture, you’ll learn exactly how to use Microsoft 365 Copilot inside your everyday apps and how to write effective prompts that deliver the best results. We break down what a prompt is, how Copilot responds to your instructions, and how simple or detailed prompts can dramatically change the quality of the output you receive.

You’ll also discover the four essential ingredients of a high-quality prompt: your goal, the context, the sources Copilot should focus on, and your expectations for tone and style. Through a practical example, you’ll see how these elements come together to create clear, precise, and highly productive instructions.

Most importantly, you’ll learn that you don’t need to write perfect prompts. You can start with a short, simple request and refine it through natural conversation. By the end of this lecture, you’ll feel confident using Copilot across Microsoft 365 and crafting prompts that give you fast, accurate, and relevant results.

In this lecture, learners will discover the four essential components that make a Copilot prompt clear, powerful, and actionable. You’ll learn how to structure your instructions, add context, define expected outputs, and set constraints so Copilot delivers accurate results every time. By the end, students will understand how to transform simple requests into high-quality prompts that work consistently across Word, Excel, Outlook, SharePoint, and Teams.

In this lecture, learners will explore the Copilot Prompts Gallery and understand how to use ready-made prompts designed for Word, Excel, Outlook, and SharePoint. You’ll also learn how Copilot handles Web Search, when to enable or disable it, and how these settings influence the quality and scope of responses. By the end, students will feel confident navigating the gallery, choosing the right prompts, and controlling web-based AI behavior for accurate, secure results.

In this lecture, learners will see how Microsoft 365 Copilot can take a project’s raw inputs and automatically generate a polished Statement of Work using a Word template. You’ll watch a real-world workflow where Copilot reads project documents, applies the correct structure, and fills in all required sections based on the template’s format. By the end, students will understand how to use Copilot to accelerate SOW creation and produce professional, consistent documents in minutes.

In this lecture, learners will see how Microsoft 365 Copilot can transform multiple project files into a fully structured, professional Statement of Work. You’ll explore how Copilot reads your Word template, extracts key details from supporting documents, and automatically generates a complete SOW draft with clear sections and accurate context. By the end, students will understand how to streamline document creation and produce client-ready SOWs in just a few minutes using AI-driven automation.

In this lecture, learners will discover how Microsoft 365 Copilot can take outdated or poorly formatted legacy documents and rewrite them into clean, modern, and professionally structured versions. You’ll see how Copilot improves formatting, updates terminology, restructures content, and aligns documents with your organization’s latest writing standards. By the end, students will understand how to quickly transform old files into polished, consistent, and ready-to-use documents using AI assistance.

In this lecture, learners will see how Microsoft 365 Copilot can quickly analyze two different versions of a document stored in SharePoint and highlight exactly what has changed. You’ll learn how Copilot reviews v1 vs. v2, summarizes differences, identifies added or removed content, and presents a clear comparison without manually reading both files. By the end, students will understand how to use Copilot to streamline version control, speed up reviews, and ensure accuracy in collaborative document workflows.

In this lecture, learners will watch how Microsoft 365 Copilot can take multiple reference files stored in SharePoint and generate a completely new requirements document from scratch. You’ll see how Copilot gathers details across different documents, merges relevant information, and produces a structured, clear, and professional requirements draft. By the end, students will understand how to use Copilot to accelerate requirement creation and eliminate hours of manual document analysis.

In this lecture, learners will see how Microsoft 365 Copilot can instantly break down long, complex email threads into clear, actionable summaries. You’ll also learn how Copilot can draft professional replies, suggest responses based on context, and help you communicate faster without missing important details. By the end, students will understand how to use Copilot in Outlook to manage inbox overload, respond efficiently, and maintain high-quality communication in less time.

In this lecture, learners will explore how Microsoft Copilot enhances engagement inside Viva Engage by analyzing posts, extracting insights, and generating thoughtful responses. You’ll see how Copilot interprets tone, identifies key themes, and drafts replies that align with your communication style and organizational culture. By the end, students will understand how to use Copilot to participate more effectively in workplace discussions and maintain meaningful engagement with their communities.

In this lecture, learners will see how Microsoft 365 Copilot can take multiple documents stored in SharePoint—each containing different pieces of information—and merge them into one clean, unified, and professionally structured file. You’ll learn how Copilot analyzes each document, identifies overlapping content, and produces a consolidated version that removes manual copy-paste work entirely. By the end, students will understand how to streamline documentation workflows and create a single source of truth using Copilot’s AI-powered consolidation capabilities.

In this lecture, learners will get hands-on experience using Microsoft 365 Copilot in Excel to perform essential data-cleaning tasks. You’ll see how Copilot can quickly fix inconsistent formatting, correct capitalization issues, remove extra spaces, and calculate metrics such as average salaries with simple prompts. By the end, students will understand how to use Copilot to transform messy spreadsheets into clean, analysis-ready datasets in just a few clicks.

In this lecture, learners will see how Microsoft 365 Copilot helps clean up messy spreadsheet data by correcting formatting issues and removing unwanted extra spaces. You’ll watch a practical demo where Copilot identifies inconsistencies, standardizes text, and delivers clean, organized data with simple natural-language prompts. By the end, students will understand how to quickly improve data quality in Excel without using complex formulas or manual cleanup work.

In this lecture, learners will see how Microsoft 365 Copilot can quickly standardize inconsistent date formats within an Excel dataset. You’ll watch Copilot identify mixed date patterns, correct formatting issues, and convert everything into a clean, uniform structure ready for analysis. By the end, students will understand how to handle real-world data problems and rely on Copilot to transform unreliable date columns into accurate, professional-quality formats.