
Download the lesson files used in this course and build along step-by-step.
Open Microsoft 365 apps from Windows start or the Microsoft 365 website, with Copilot built in. Use search or the app launcher to access PowerPoint, Excel, OneDrive, and Whiteboard.
Learn to summarize long texts with Copilot 365, using a web link or copy-paste input to generate concise overviews. Transform outputs into five frequently asked questions with answers for prep.
Tailor explanations with Copilot 365 chat to your level, like explaining quantum computing for a ten-year-old, and learn by editing a new chat.
Activate GPT-5 in Copilot 365 by entering a favorite prompt and selecting a country like India, then receive reasoning-powered news summaries with sentiment analysis.
In this lesson, we introduce Scheduled Prompts in Microsoft 365 Copilot, a feature that lets you automate recurring AI-generated content like personalized news updates.
During this lesson, you will learn how to:
Create a structured news prompt with topics, summaries, sentiment analysis, and sources
Schedule prompts to run automatically on a daily, weekly, or monthly basis
Customize timing, frequency, and duration of scheduled prompts
Manage scheduled prompts, including editing, running manually, or deleting them
This helps you stay consistently up to date with relevant information by turning Copilot into your own automated news assistant.
When you write prompts manually, you often spend time guessing the right words, fixing mistakes, and testing different versions before you get a good result. With the Prompt Optimizer, this work is automated: the tool analyzes your draft prompt, removes contradictions, adds missing details, and formats it according to best practices.
Most importantly, the Prompt Optimizer is entirely free. Even though OpenAI developed it, the optimized prompts can be used in ChatGPT and other AI assistants such as Copilot 365.
In other words, instead of trial and error prompting, you get a clean and professional prompt in seconds, ready to generate better and more consistent outputs. This saves time, reduces frustration, and helps beginners create expert-level prompts without years of practice.
Create a donut chart of the total price in euro by currency and inspect orders by currency with a pivot table, showing dynamic updates as the Excel book changes.
The =COPILOT() function is a new AI-powered feature in Excel that lets you write natural-language prompts directly in a formula. It uses Microsoft Copilot to generate text, summaries, or insights based on your instructions and optional cell data. For example, =COPILOT("Summarize these comments", A2:A10) will analyze and summarize the text in those cells. The function can return single or multiple results, and updates automatically when the referenced data changes.
Note: =COPILOT() is a brand-new feature currently available in preview for users on the Microsoft 365 Insider “Frontier” channel.
Explains how to use the XL Copilot function to split an unstructured address into street, city, and postal code, and demonstrates creating reliable name extraction formulas for structured data.
Learn to use Copilot in Teams to generate meeting notes and action items, identify who spoke, access web content, and pull project updates from files and references.
Learn to draft and edit email replies with Copilot 365 by prompting, selecting from multiple versions, and refining with concise edits, context-aware feedback, and final paragraph additions.
Reference internal documents in the Microsoft cloud by adding a file as context and generating a document that combines the content with your text, avoiding blank pages.
Explore how the copilot sidebar creates quick summaries, uses follow-up prompts, and highlights sources in long documents, with examples like handwashing technique.
Open PowerPoint, launch Copilot, and create a new presentation from templates or my company template, then prompt topics like tulips to generate slides and add speaker notes.
Learn how to translate a presentation across multiple languages with Copilot 365, instantly converting slides to German, Danish, or other languages while keeping the original English version.
Automate PowerPoint tasks with VBA by creating a macro that replaces placeholders across slides, using Copilot 365 chat to generate and run the code.
Configure and customize a Microsoft Copilot 365 HR agent for the Common Sense Bank, set logo, name, and instructions, attach SharePoint knowledge, and test vacation and parental leave prompts.
Master dynamic notebooks by linking references that update as documents change; add references, upload or link files, and configure copilot instructions for analyzing workplace trends.
Explore all the details of Microsoft Copilot 365 through a comprehensive series of informative videos. Each tutorial offers a step-by-step walkthrough of its powerful AI features. Learn how to handle emails more efficiently in Outlook, create engaging presentations in PowerPoint, and tackle complex formulas in Excel. You'll also learn to efficiently search and summarize internal documents using the Copilot 365 chat feature.
The course is designed for active learning, letting you apply new skills in real-time scenarios. Whether writing documents, managing data, or leading teams, this course equips you with the practical skills to effectively use Microsoft Copilot 365 in any professional environment.
Complete this course and understand how to utilize Microsoft 365 Copilot across various applications. Here's what you'll achieve:
Master Copilot Chat: You'll learn to use Microsoft 365 Copilot Chat, similar to ChatGPT, to interact with and extract information from your company's internal documents, boosting efficiency and data handling.
Enhanced Email Management: Gain skills in using Copilot in Outlook to quickly craft responsive and intelligent emails, helping manage your communications more effectively.
Advanced Excel Techniques: Develop your ability to use Copilot to create complex formulas and analyze data, allowing for deeper insights and better decision-making.
Dynamic Presentations: Learn how to use Copilot in PowerPoint to design engaging and impactful presentations that capture attention and convey your message.
Efficient Document Drafting: Understand how to leverage Copilot in Word to produce professional and time-efficient documents.
Streamlined Team Coordination: Utilize Copilot in Teams to enhance collaboration and streamline communication within your team.
Organized Note-Taking: Discover how to integrate Copilot in OneNote for better note management and information retrieval during meetings or projects.
Improved Data Collection: Learn to use Copilot in Forms for smarter survey creation.
Creative Whiteboard Sessions: Master Copilot in Whiteboard to facilitate more effective brainstorming and strategy sessions.
Each module is crafted to help you harness the full potential of Microsoft 365 Copilot, transform your work with AI-powered tools, and ensure your proficiency in maximizing productivity within your professional environment.
This course is designed for anyone eager to enhance their efficiency and mastery of digital tools in the workplace. It is particularly well-suited for:
Business Professionals: If you work in management, operations, or customer service, Microsoft 365 Copilot's automation and AI features can help you manage your daily tasks and communications more effectively.
Entrepreneurs and Small Business Owners: Use Microsoft 365 Copilot to streamline your business processes, from email management to data handling, freeing up more time to focus on business growth.
Students and Academics: Improve your research and study efficiency by mastering advanced data management and note-taking capabilities.
IT Professionals: Gain skills to support and implement Microsoft 365 Copilot within your organization, boosting productivity and technological adaptability.
This course is ideal for anyone using AI to make their work more accessible and productive. No prior experience with Microsoft 365 Copilot is required, making it an excellent choice for individuals at all levels of technical proficiency.