Microsoft 365 Copilot Workshop

Prompts, reference notes, and sample datasets for the 2-day Microsoft 365 Copilot workshop.

Participant book: download the whole workshop as one PDF, with every topic’s notes and prompts, to read offline or print.


Program Flow

Microsoft Copilot Training Journey


How to Use This Site

Each topic has a Notes page covering the concepts and a Prompts page with copy-paste prompts you can use during and after the session.

To copy a prompt: open the prompts file, find the prompt you want, and click the copy icon on the top right of the code block.

Download: all workshop files (ZIP). Save the ZIP, then right-click it and choose Extract All before you open any file.


Workshop Scenario

Throughout this workshop you work on one connected project from start to finish.

You are creating an AI Usage Guide for your department.

This guide will explain how your team should use AI tools responsibly and effectively. Each topic moves the project one step forward:

Stage What happens
Research Use Copilot Chat to research AI best practices, regulations, and department-specific use cases
Draft Move your research into Copilot Pages and build the first draft of your guide
Refine Open the draft in Word and reformat it as a formal management proposal
Submit Email the proposal to your supervisor for approval using Copilot in Outlook
Present Turn the approved document into a team presentation using Copilot in PowerPoint
Survey Build a knowledge quiz and feedback survey using Copilot in Forms
Analyse Use Copilot in Excel to analyse the quiz results and surface insights
Launch Run the launch meeting in Teams, with Copilot capturing questions, decisions and follow-ups
Automate Build a simple weekly check-in agent in Copilot Studio to keep the feedback loop running

Topics

# Topic Notes What you will do
01 Copilot Fundamentals Prompts Check your license, tour the interface, run your first prompt, personalise Copilot, verify sources, compare models, save prompts, and ground answers in your own files
02 Prompt Engineering Prompts Learn the GCSE framework, practice writing better prompts, and understand how to iterate on responses
03 Copilot Chat Prompts Research AI best practices and Malaysian regulations using Web grounding, then switch to Work mode to reference your own documents
04 Copilot Pages Prompts Turn your research into a structured first draft, refine it section by section, and add a Mermaid decision flowchart
05 Copilot in Word Prompts Reformat your draft as a formal management proposal, strengthen key sections, and create a cover summary page
06 Copilot in Outlook Prompts Email the proposal for approval, follow up, respond to feedback, tidy your inbox with rules, schedule the launch meeting, and announce the approved guideline to your team
07 Copilot in PowerPoint Prompts Generate a team presentation from your Word document, improve slides, add speaker notes, and create custom images using the Create feature
08 Copilot in Forms Prompts Build a knowledge quiz from your AI Usage Guide PDF and a feedback survey, then export the results to Excel
09 Copilot in Excel Prompts Analyse quiz results, add calculated columns, identify weak areas by department, and use Python in Excel to generate charts
10 Copilot in Teams Prompts Run the launch meeting for your guide with Copilot and Facilitator, use the recap to follow up, and catch up on busy chats
11 Copilot Studio Intro Prompts Build a simple weekly check-in agent that asks your team one question about the AI guideline and collects their response

Sample Data

The file AI_Guideline_Survey_Responses.xlsx in the Excel folder contains 100 simulated quiz responses across 8 departments for use in Topic 09. You do not need real responses to complete the Excel exercises.

The file Data_Privacy_AI_Acceptable_Use_Policy.pdf in the Copilot Chat folder is a fictional company policy document used in Topic 03 to practise Work mode grounding.


Last updated: May 2026 | Trainer: Asraf