Microsoft 365 Copilot Multi-Department & Multi-Industry Lab Workbook

Mock training data only. Verify Copilot outputs, sources, and calculations before use.

A GitHub Pages edition with one Markdown file per lab and appendix.

Start here

Section Description
Workbook overview What the workbook covers and who it’s for
How to use this workbook Learning paths, tracks, and the full lab index
Sample data inventory The 14 mock files and what each is for

Labs

Lab Title Department / Industry Primary app Level Time
00 Configure your workspace and guardrails All OneDrive, Chat 100 10 min
01 Multi-file reasoning and prompt engineering HR / cross-function Copilot Chat 200 25 min
02 Contract review summary and dual-audience rewrite Legal / Technology Word 200 30 min
03 Quarterly business review briefing Marketing / Retail PowerPoint 200 25 min
04 Customer escalation communications Customer Service / Financial Outlook 200 35 min
05 Budget variance analysis Finance / Manufacturing Excel 300 35 min
06 Sales pipeline analytics Sales / Technology Excel 300 35 min
07 Cross-functional project meeting Operations / cross-function Teams 200 30 min
08 Deep data analysis with the Analyst agent Customer Service / Retail Analyst agent 300 35 min
09 Multi-source business investigation Strategy / cross-function Researcher agent 300 35 min
10 Researcher vs Analyst vs Chat: tool selection challenge All Copilot, agents 200 20 min
11 Build a knowledge agent with Agent Builder HR + Customer Service Agent Builder 200 30 min
12 Advanced agent: grounding, structured output, refusal design Finance / Compliance Agent Builder 300 35 min
13 Agent evaluation and red-team testing Security / governance Agent Builder, Studio 300 40 min

Capstone

Lab Title Department / Industry Primary app Level Time
Cap Cross-department leadership briefing pack All Word, Excel, PPT, Agents 200 45 min

Appendices

Appendix Title
A Department and industry prompt patterns
B Industry considerations
C Instructor debrief questions
D Safety, data handling, and responsible AI
E Skills self-assessment rubric

Download sample data

Students can grab the mock files they need from the Sample data inventory, or download everything at once:

Updating

Edit files in docs/, commit, and push. GitHub Pages can publish directly from the /docs folder.