Virtuelle Group | AI Workshop Series
Master Copilot
Prompting in 60 Minutes
Prompting in 60 Minutes
Hands-on exercises across every Copilot surface: CoWork, M365 Chat, Word, Excel, PowerPoint, Copilot Pages, and the Prompt Gallery. Every prompt is real-world and ready to use today.
7
Modules
21
Exercises
75
Minutes
40+
Advanced Prompts
Be Specific
Include role context, output format, tone, length, and audience. Vague prompts return vague outputs. Treat Copilot like a talented new hire who needs a proper brief.
Iterate Freely
Your first output is a draft, not the final answer. Use follow-ups like "make section 2 more assertive", "cut by 30%", or "restructure this as an executive briefing".
Verify Outputs
Copilot accelerates your work, but it does not replace your professional judgement. Always review, fact-check, and edit before any output goes to a client or leadership.
Provide Context
Reference your actual files, meetings, and emails using the / key. The richer the context, the more accurate and relevant the output. Never prompt in a vacuum.
Chain Across Surfaces
The real productivity gain is cross-surface workflows: summarise in Chat, draft in Word, visualise in PowerPoint, analyse in Excel, all in one connected flow.
Share What Works
Great prompts are team assets. Save winners to the Prompt Gallery and publish Skills in CoWork so the whole organisation benefits from your discoveries.
10 min
1
Turn Any Document into a Ready-to-Send Update
CoWork
ScenarioA report, assessment, or case file has just been updated. You need to pull out the key details and send a professional update to a stakeholder. This normally takes 20 to 30 minutes. CoWork does it in under 5.
Steps
- 1Open Copilot CoWork from the taskbar and confirm it is in Agentic mode so it can read files and draft communications.
- 2Tell CoWork which file to use: either drag it into the CoWork window, or type "Use the file on my desktop named [filename]."
- 3Paste the prompt below, adjusting the bracketed fields to match your document and stakeholder. CoWork will read the file, extract the relevant details, and write the update.
- 4Review the draft output and click approve before CoWork saves or sends anything.
Try This Prompt
Copy
Read this document and extract the following information: the subject or case reference, the current status, any key dates or deadlines, outstanding actions required, and the next scheduled milestone or review. Then draft a professional update email to [stakeholder name or role] summarising where things stand, what is expected of them in the next two weeks, and the next key date to be aware of. Keep the email factual, clear, and under 200 words. Show me the draft before doing anything with it. Do not send without my approval.
Why this matters: Anyone who regularly reads documents and then writes update communications can use this pattern daily. CoWork does the reading and drafting. You spend 30 seconds reviewing instead of 30 minutes writing from scratch.
Marked complete
2
Build a Reusable Skill for Your Most Repeated Task
CoWork
ScenarioEvery team has tasks they do the same way, every week. A status report, a client brief, a meeting summary, a handover note. Instead of writing these from scratch each time, you can build a CoWork Skill and run it with a single command.
Steps
- 1In CoWork, click the Skills tab and select Create new skill.
- 2Give your skill a name that reflects what it does, for example: "Weekly Status Report" or "New Client Brief".
- 3Paste the skill definition prompt below as the instruction set. Customise the output structure to match your team's standard format.
- 4Save and test it: "Run the [Skill Name] skill for [project or client name]." Then share it to your team's Skills library.
Skill Definition: Weekly Status Report
Copy
When I trigger this skill with a project or team name, do the following in order. First, search my Teams messages, emails, and shared files from the last 7 days for any updates related to that project or team. Second, identify what was completed, what is still in progress, any blockers, and what is coming up next week. Third, draft a concise status update using this structure: RAG Status (Red, Amber, or Green with one sentence of justification), Summary (two sentences maximum), Completed This Week (bullet list), In Progress (bullet list), Blockers (bullet list, note the owner next to each item), Priorities Next Week (bullet list). Output the result as a plain-text email ready to send to the project sponsor. Keep it under 300 words.
Why this matters: A Skill is a saved, reusable workflow. Once your team has it, anyone can run it with one command. The output is consistent, structured, and on-brand every time. Skills shared across a team library are one of the fastest ways to lift the floor on quality across the whole organisation.
Marked complete
3
Chain a Multi-Step Workflow End to End
CoWork
ScenarioEnd of month. You need to pull together a reporting summary, prepare a leadership update, and notify key stakeholders. These are three separate tasks that each take real time. CoWork can run them in sequence with a single prompt, stopping for your review between each step.
Steps
- 1Open CoWork and reference the relevant reports or data files using the / key or by dragging files into the CoWork window.
- 2Paste the multi-step prompt below. It will work through three tasks in order, pausing for your approval at each stage.
- 3Approve each output before CoWork proceeds, or correct it and move on. You are in control at every step.
Multi-Step Prompt
Copy
I need to complete our end-of-month reporting process. Work through the following steps in order and pause for my approval before starting each new step. Step 1: Search my OneDrive, shared files, and emails from the last 30 days for performance data, activity reports, and operational updates related to [your team, department, or project name]. Compile the key figures and outcomes into a structured table with columns for: area or program name, key metric or volume, result versus target, and any notable highlights or issues. Step 2: Using that table, write a concise leadership update. Lead with the overall performance story in two sentences, then cover what went well, what needs attention, and any resource or decision needs. Keep it under one page, plain language, no jargon. Step 3: Draft a short team communication sharing a positive achievement from the month. Three short paragraphs. Acknowledge the team's contribution and connect it to organisational purpose. Show me each output for approval before moving to the next step.
Key principle: Always include "pause for my approval before starting the next step" in any multi-step CoWork prompt that touches files or communications. You stay in control. CoWork removes the manual effort between each step, not the human judgement.
Marked complete
8 min
1
Catch Up Fast: Your Morning Briefing in Seconds
M365 Chat
ScenarioIt is Monday morning. You have 70 unread emails, missed Teams threads, and a full calendar. Instead of spending 45 minutes triaging your inbox, ask Copilot Chat to prioritise everything and tell you exactly what needs your attention first.
Steps
- 1Open M365 Copilot Chat at microsoft365.com or within Teams. Make sure Work mode is selected (not Web).
- 2Paste the prompt below and hit Enter. Copilot reads across your emails, chats, and calendar automatically.
- 3Follow up with: "Draft a response to the most urgent item." Watch it pull the full context and write a ready-to-send reply.
Try This Prompt
Copy
It is the start of my working week. Give me a structured catch-up across my emails, Teams messages, and calendar from the past three days. Organise it into four sections. First, Needs my response today: list the sender, the topic, and a one-line summary for each item. Second, Decisions or commitments made while I was away: anything agreed in meetings or threads I was included in. Third, Upcoming deadlines this week: pulled from my calendar and any emails with specific dates mentioned. Fourth, Anything else I should know: notable updates from my team or key contacts. For each item, tell me where to find it so I can go there directly.
The shift this creates: Most people spend 30 to 45 minutes every morning triaging their inbox. This prompt does it in under a minute, and the output is prioritised, not just chronological. Try it every day for a week and you will not go back.
Marked complete
2
Find Anything, Fast: Search Across All Your Work Data
M365 Chat
ScenarioA colleague or stakeholder asks about something discussed six months ago. You know it happened, but was it in an email, a Teams chat, a meeting, or a document? With Copilot Chat, it does not matter. One prompt searches across all of them simultaneously.
Steps
- 1In Copilot Chat with Work mode active, try either prompt below. Adapt the topic and timeframe to something real from your team.
- 2Notice that Copilot cites the source for each piece of information. You can click through to verify or share the original item directly.
- 3Follow up with: "Summarise this as a one-paragraph briefing I can share with my manager."
Prompt A: Research a Topic
Copy
Find all discussions, decisions, and documents related to [topic, for example: the new IT system rollout / the updated pricing model / the Q3 reporting process] from the past six months. Summarise what was decided, who was involved, and what the current position is. Tell me where each piece of information came from so I can go back to the source if needed.
Prompt B: Prepare for a Meeting
Copy
What has been discussed or agreed with [person name or team] over the last three months? I need a timeline of our main interactions, any commitments made on either side, and any items that are still unresolved. I have a meeting with them this week and want to go in well prepared.
Pro tip: Use the / key in your prompt to reference a specific file by name. Copilot will answer questions about its contents directly, without you needing to open and read through it yourself.
Marked complete
3
Write Better Communications, Faster
M365 Chat
ScenarioYou need to send an important communication, whether that is a project update, a change announcement, a client response, or a message to leadership. The words and tone matter. Copilot Chat helps you get it right quickly.
Steps
- 1Pick either prompt below and fill in the bracketed details with something real and relevant to your work right now.
- 2Review the output, then practise iterating: try "Shorten it by a third", "Make the tone more direct", or "Add a clear call to action at the end."
- 3Notice how quickly you reach a final draft. What normally takes 30 to 60 minutes of writing and rewording takes 2 to 3 minutes with Copilot.
Prompt A: Stakeholder or Leadership Update
Copy
Write a professional update email to [recipient name or role, for example: the executive team / a key client / the project steering group] about [describe the update in two sentences]. The recipient is results-focused and prefers brevity. Lead with the key outcome or decision needed. Provide supporting context in no more than four bullet points. Close with a clear next step. Keep the total email under 200 words. Professional tone, plain language, Australian English.
Prompt B: Change Announcement or Sensitive Communication
Copy
Draft a communication to [audience, for example: all staff / our customers / a specific team] announcing [describe the change in two to three sentences]. The audience may have concerns or questions, so the tone should be clear, honest, and reassuring without being dismissive. Explain what is changing, why it is happening, what it means for them specifically, and what they should do if they have questions. Use plain language with no acronyms or technical jargon. Keep it to one page. Include a clear contact point at the end.
The prompting technique: Describing the recipient, their communication preferences, the required tone, and hard constraints like word count and language level produces a first draft that is genuinely usable. That is the difference between a vague prompt and a specific one.
Marked complete
10 min
1
Draft a Structured Business Document from a Complex Brief
Word
ScenarioYou need to write a business case for a technology investment. Rather than starting blank, you'll give Copilot a fully structured brief so it can produce a document that's already 80% ready.
Steps
- 1Open a new Word document and click Copilot in the ribbon (or press Alt + I).
- 2Paste the prompt below, filling in the bracketed fields with your actual scenario.
- 3Click Generate and review. Then follow up: "Strengthen the ROI section with a cost-benefit table using these numbers: [your figures]."
Advanced Prompt
Copy
Write a professional business case document for the following investment: [Describe the initiative in 2-3 sentences]. The audience is our executive leadership team. They are commercially focused, risk-aware, and need to justify board-level spend. Structure the document with these sections: Executive Summary (150 words max), Problem Statement and Current State, Proposed Solution and Scope, Strategic Alignment (connect to our growth and efficiency objectives), Financial Summary including estimated cost, expected ROI, and payback period, Key Risks and Mitigations (use a 3-column table: Risk | Likelihood | Mitigation), Implementation Approach (phased timeline), Recommendation and Decision Required. Use formal Australian English. Avoid all filler phrases. Every section should be substantive, with no placeholder content.
Marked complete
2
Audience Transformation: One Document, Three Versions
Word
ScenarioYou have a technical implementation report that needs to go to three different audiences: the IT team, the business steering committee, and front-line staff. One source document, three distinct outputs.
Steps
- 1Open the source document (or use the Word document you generated in Exercise 1).
- 2Open Copilot and run each version prompt separately, saving each output as a new document.
Version A: Executive Summary
Copy
Rewrite this document as a 1-page executive summary for our steering committee. They want outcomes, risks, and financial impact, not technical detail. Use plain language, no acronyms unless defined, and lead with the business value. Format as: Headline outcome (1 sentence), Key achievements (3 bullets), Risks remaining (2 bullets), Decision required (1 sentence). Maximum 300 words.
Version B: Staff Communication
Copy
Now rewrite the same document as a friendly, reassuring all-staff communication. The audience is non-technical employees who may be worried about what this change means for their day-to-day work. Explain what's changing, what's staying the same, what they need to do differently, and where to get help. Use plain conversational language. Include a FAQ section with the 4 most likely questions staff would ask, with direct answers. Warm but professional tone.
Marked complete
3
Cross-Reference & Gap Analysis Between Two Documents
Word
ScenarioA client has sent their requirements document. You want to compare it against your proposed solution document and find the gaps before they do.
Advanced Prompt
Copy
I have two documents open. The first is the client's requirements document /[Requirements Doc] and the second is our proposed solution /[Solution Doc]. Perform a structured gap analysis: (1) List every client requirement and indicate whether our solution fully addresses it, partially addresses it, or does not address it. Use a table with columns: Requirement | Our Coverage | Gap or Risk, (2) Identify the 3 highest-risk gaps where the client may push back during review, (3) For each high-risk gap, suggest a response strategy: either how we can close the gap, or how to reframe it as out of scope with justification, (4) Note any commitments in the requirements document that would require additional cost or effort not currently in our proposal.
Trainer note: Cross-referencing two documents is one of the highest-value Word Copilot use cases. Use the / key to reference both documents by name in your prompt. Copilot will read both simultaneously.
Marked complete
10 min
1
Pattern Detection & Anomaly Investigation
Excel
ScenarioYou have a large dataset such as expenses, a sales pipeline, or ticket data, and you need to quickly understand what's normal, what's unusual, and what warrants immediate attention.
Steps
- 1Open your data in Excel and ensure it's formatted as a Table (Ctrl+T).
- 2Open Copilot from the Home ribbon.
- 3Run the anomaly detection prompt, then follow up with the drill-down prompt.
Advanced Prompt
Copy
Analyse this dataset and perform a full anomaly and pattern detection sweep. Identify: (1) Any values that are statistical outliers (more than 2 standard deviations from the mean for their column), (2) Any categories or segments that are trending in the wrong direction compared to the rest of the dataset, (3) Any correlations between columns that are unexpected or worth investigating, (4) The single most important insight in this data that a manager would want to act on immediately. For each finding, explain what you found, why it's significant, and what the likely cause might be. Rank findings by business impact.
Copy
Drill into the anomaly you identified in [column/segment name]. Add a new column called "Anomaly Flag" that marks each row as High / Medium / Normal based on how far it deviates from expected range. Then highlight all High rows in red and add a summary row at the bottom showing the count and total value of flagged items.
Marked complete
2
What-If Scenario Modelling
Excel
ScenarioYou need to model three different pricing or resourcing scenarios before a leadership meeting. Instead of building separate tabs manually, Copilot can generate the whole model from a brief.
Advanced Prompt
Copy
Using the data in this spreadsheet as the baseline, build a 3-scenario model with columns for Conservative (10% below current assumptions), Base Case (current), and Optimistic (15% above current assumptions). For each scenario calculate: total revenue, total cost, gross margin, gross margin percentage, and break-even point. Add a summary comparison table at the top of the sheet with conditional formatting: green where gross margin exceeds 30%, amber between 20–30%, red below 20%. Label all assumptions clearly so a reviewer can see what was changed in each scenario.
Trainer note: Always specify the conditional formatting thresholds and output structure explicitly. Copilot follows structured instructions far more accurately than vague requests like "make it look nice".
Marked complete
3
Build an Executive Dashboard from Raw Data
Excel
Advanced Prompt
Copy
Create a new sheet called "Executive Dashboard" and build a single-page summary view of this data. The dashboard should contain: (1) A KPI summary row showing the 4 most important metrics from this data as large, clearly labelled numbers with comparison to prior period and an up/down arrow indicator, (2) A bar chart of [key metric] by [dimension, e.g. region, team, product] sorted highest to lowest, (3) A trend line chart showing the last 6 periods, (4) A "Top 5 and Bottom 5" table showing best and worst performing rows by [metric]. Lock the dashboard sheet so it cannot be accidentally edited. Add a "Last Updated" cell that references today's date automatically.
Marked complete
10 min
1
Create a Narrative-Led Deck from Source Documents
PowerPoint
ScenarioYou have a Word strategy document and an Excel data file. You need a board presentation in 90 minutes. The advanced prompt below tells Copilot exactly how to structure the narrative, not just convert bullets to slides.
Steps
- 1Open PowerPoint and click Copilot in the ribbon.
- 2Use the "Create presentation about" field and reference your source documents using the / key.
- 3Paste the full prompt below to give Copilot complete structural direction.
Advanced Prompt
Copy
Create a 12-slide executive presentation using the content from /[Strategy Doc] and /[Data File]. The audience is our board of directors. They want strategic clarity, financial rigour, and a clear ask. Structure the presentation using the Situation-Complication-Resolution narrative framework: Slides 1–2: Set the scene: current position and market context; Slides 3–4: The complication: the problem or opportunity that demands action; Slides 5–8: The resolution: our proposed strategy, the data that supports it, and the financial case; Slide 9: Risks and how we mitigate them; Slide 10: Implementation roadmap (visual timeline); Slide 11: What we need from the board (specific decision or resource); Slide 12: Appendix index. Each slide should have a headline that is a complete sentence making an argument, not just a label. No slide should have more than 5 bullet points. Where data is available from the Excel file, include a chart or table on the relevant slide.
Trainer note: "Headline as a complete argument sentence" is a McKinsey consulting technique. Forcing Copilot to write slide headlines this way ensures each slide communicates one clear idea. This is what separates a great deck from a mediocre one.
Marked complete
2
Redesign a Slide for Maximum Clarity
PowerPoint
ScenarioYou've inherited a text-heavy slide that's impossible to read in a live presentation. Use Copilot to diagnose the problem and redesign it, based on communication best practice rather than aesthetics alone.
Advanced Prompt
Copy
Review slide [slide number] in this presentation and diagnose its communication problems. Be specific about what makes it hard to read or understand quickly. Then redesign it using these principles: (1) One key idea per slide, (2) Headline that states the conclusion, not the topic, (3) Replace any list of more than 4 items with a visual framework, matrix, or grouped structure, (4) If there is numerical data on the slide, suggest the most appropriate chart type and explain why, (5) Speaker notes for the redesigned slide - 4–5 sentences the presenter can use verbatim. Show me the before and after side by side if possible.
Copy
Review the entire presentation for narrative flow. Give me a slide-by-slide story audit: for each slide, rate the narrative strength as Strong / Weak / Broken and explain why. Then identify the 2 biggest gaps in the story, places where an audience member would lose the thread, and suggest how to bridge them with a new transition slide or restructured content.
Marked complete
3
Pre-Meeting Deck Analysis & Q&A Preparation
PowerPoint
Advanced Prompt
Copy
I'm about to present this deck to [describe the audience, e.g. a sceptical CFO, a technical review panel, a new client]. Analyse the presentation and: (1) Identify the 5 most likely objections or challenges this specific audience would raise, ordered from most to least likely, (2) For each objection, write a 2–3 sentence response that acknowledges their concern and redirects to a strength of our position, (3) Flag any slide where the data or claim could be challenged and suggest a stronger evidence source or more defensible framing, (4) Identify the moment in the presentation where I'm most likely to lose the audience's attention and suggest what to do at that point to re-engage them.
Trainer note: This "red team your own deck" technique is one of the most underused Copilot prompting patterns. Running it before every major presentation will make you significantly more prepared than the room expects.
Marked complete
8 min
1
Create a Living Team Intelligence Page
Pages
ScenarioYour team is working across a complex account or project. Instead of scattered emails and meeting notes, you'll create a Copilot Page that becomes the single living reference document, continuously updated by the team and the AI.
Steps
- 1In Copilot Chat, run the prompt below to generate the structured content.
- 2When the response appears, click Edit in Pages. This creates an editable, shareable document.
- 3Within the Page, prompt Copilot again: "Add a section for open risks with a 3-column table: Risk | Owner | Status."
- 4Share the page link with your team. They can view, co-edit, and prompt Copilot within the same page.
Advanced Prompt (run in M365 Chat first)
Copy
Create a comprehensive account intelligence brief for [Client / Project Name] that will serve as our team's living reference document. Pull from all emails, Teams chats, meeting recordings, and files related to this account from the last 90 days. Structure it as: (1) Account Snapshot: who they are, key contacts with roles, and the nature of our engagement; (2) Current State of the Relationship: recent interactions, tone, any tensions or positives worth noting; (3) Active Workstreams: what we are currently delivering and current status; (4) Commitments and Obligations: things we've promised, with dates; (5) Strategic Opportunities: upsell, expansion, or partnership angles identified in conversations; (6) Upcoming Touchpoints: meetings, renewals, or deadlines in the next 60 days. Format with clear section headers so it can be directly saved as a Page and shared with the account team.
Marked complete
2
Synthesise Multiple Sources into a Decision-Ready Brief
Pages
ScenarioLeadership needs a decision paper by end of day, synthesising input from four separate streams: a consultant's report, stakeholder feedback emails, a financial model, and last week's workshop notes. This normally takes hours.
Advanced Prompt
Copy
I need to produce a decision paper by synthesising four sources: /[Consultant Report], /[Stakeholder Feedback Emails - reference thread or folder], /[Financial Model], and /[Workshop Notes]. Produce a structured decision brief with the following sections: (1) The Decision - state clearly what leadership must decide and by when; (2) What We Heard - synthesise stakeholder views, noting where there is consensus and where there is disagreement; (3) Financial Implications - pull the key numbers from the financial model and frame them in terms of cost of action versus cost of inaction; (4) Expert View - summarise the consultant's recommendations objectively; (5) Options Considered - list each option with its key trade-offs in a table (Option | Benefits | Risks | Financial Impact); (6) Recommended Path - state a clear recommendation with your reasoning; (7) What Approval Means - what will happen in the first 30 days if leadership approves today. Flag any conflicting information between the sources and where judgement is needed.
Marked complete
3
Build Your Team's Prompt Gallery - Live
Prompt Gallery
ScenarioA prompting culture requires infrastructure. Today you'll contribute to your team's shared Prompt Gallery - saving your best prompt from this workshop and creating a prompt template your team can use immediately.
Steps
- 1In Copilot Chat, click View prompts to open the Prompt Gallery. Browse by category and try one new prompt from the Gallery that's relevant to your role.
- 2Choose your single best prompt from today's session. Click the bookmark icon to save it to your personal Gallery.
- 3If your organisation has a shared Gallery, submit your prompt there with a clear title and one-sentence description of when to use it.
- 4Run the meta-prompt below to generate 5 additional role-specific prompts for your Gallery.
Meta-Prompt - Generate Your Own Prompt Library
Copy
I am a [your role] at a [describe your organisation or industry]. My most common tasks include [list 3-4 regular tasks]. Generate 5 high-quality Copilot prompts I can save to my Prompt Gallery that will help me with these tasks. For each prompt: (1) Give it a short memorable title (5 words max), (2) Write the full prompt - make it advanced, specific, and structured so the output requires minimal editing, (3) Include a one-sentence description of when to use it. Format each entry clearly so I can copy it directly into my Gallery. Prioritise prompts where specificity in the input will produce dramatically better output quality.
Copy
Review the 5 prompts you just created and score each one against these four criteria: Specificity (does it constrain the output meaningfully?), Reusability (can it be used weekly with minor edits?), Output Quality (does the structure of the prompt force a high-quality response?), and Time Saving (does it replace something that would take 20+ minutes manually?). Give each prompt a score out of 10 and recommend which 3 I should prioritise saving to my team's shared Gallery first.
Trainer note: The meta-prompt technique - using Copilot to design better prompts for Copilot - is the multiplier play. Teams that invest 30 minutes per month in prompt library maintenance see compounding returns as every team member starts from a higher baseline.
Marked complete
15 min
What is Copilot Studio?
Copilot Studio is Microsoft's low-code platform for building custom AI agents. An agent is an AI assistant you configure with a specific purpose, personality, knowledge base, and set of actions. Unlike general Copilot features you've used today, an agent is purpose-built: it knows exactly what it's for, what it can access, and what it should do when someone asks it something. Once built, you publish it once and it runs 24/7 across Teams, web chat, SharePoint, or wherever your users are.
1
Create Your First Agent and Define Its Purpose
Copilot Studio
ScenarioYour team spends time answering the same questions every week: leave policy, IT request process, onboarding steps, expense approvals. You are going to build an AI agent that handles these questions automatically, 24 hours a day, so your team can focus on higher-value work.
Steps
- 1Go to copilotstudio.microsoft.com and sign in with your Microsoft 365 account.
- 2Click Create in the left nav, then New agent. You will see an AI-powered setup assistant. Skip it for now and click Skip to configure.
- 3Give your agent a name (e.g. "HR Assistant" or "Team FAQ Bot"), a description, and paste the instructions below into the Instructions field.
- 4Click Save, then click Test your agent in the top right. Ask it a question and watch it respond using only its instructions.
- 5Iterate: go back to Instructions and refine. Notice how changing the instructions changes the response immediately in the test panel.
Agent Instructions (paste into the Instructions field)
Copy
You are an internal HR and workplace FAQ assistant for our organisation. Your role is to help staff quickly find accurate answers to common workplace questions so they do not need to email HR or wait for a response.
Your tone is friendly, clear, and professional. You give direct, practical answers. You do not waffle or add unnecessary caveats.
Topics you can help with include: leave entitlements and how to apply, expense submission process and approval, flexible work arrangements, IT access requests and new starter setup, performance review timelines, employee benefits and perks, and how to raise a workplace concern.
When you do not know the answer to a specific question, say so clearly and direct the person to the right contact rather than guessing. Never make up a policy or procedure.
Always end your response with: "Is there anything else I can help you with today?"
Key concept: The Instructions field is the agent's brain. It defines personality, scope, tone, and guardrails. A well-written instruction set is the single biggest factor in agent quality. Treat it like a detailed job description for a new employee.
Marked complete
2
Connect Your Agent to a Knowledge Source
Copilot Studio
ScenarioAn agent with only instructions is limited to what you hard-coded. A truly useful agent reads your actual documents: policy manuals, process guides, FAQs, SharePoint pages. You are going to connect your agent to a real knowledge source so it can answer questions from your own content.
Steps
- 1In your agent, click the Knowledge tab in the left panel.
- 2Click Add knowledge. You will see options: Files (upload a PDF or Word doc), SharePoint (connect a site or library), Dataverse, or a Public website URL.
- 3Choose one of the following based on what is available to you:
Option A: Upload one of today's demo Word documents (e.g. a policy document or report) as a File source.
Option B: Paste a public website URL your organisation uses (e.g. your intranet or public FAQ page).
Option C: Connect a SharePoint library if your tenant has one configured. - 4Once indexed (takes 1-3 minutes), go to Test your agent and ask a question that can only be answered from the document or site you just connected. Watch the agent cite its source in the response.
- 5Try the advanced test prompts below. Notice how the agent grounds its responses in your actual content rather than making things up.
Test Prompts for the Agent (type in the Test panel)
Copy
Based on the documents you have access to, what are the three most important things I need to know about [the topic of your uploaded document]? Summarise each point in one sentence and tell me where in the document you found it.
Copy
A new team member is asking about [specific topic from your document]. What should I tell them? Give me a plain-language explanation in 3 bullet points, based only on what is in our documents.
Key concept: This is called Retrieval Augmented Generation (RAG). The agent searches your documents first, finds the relevant passages, and uses them to compose its answer. It will cite the source so users can verify. The agent will not hallucinate content that is not in your documents - this is what makes it safe to deploy for real use cases.
How It Works: Agent + Knowledge Source
User asks a question
→
Agent searches knowledge
→
Retrieves relevant content
→
Composes grounded answer
Marked complete
3
Add an Action, Configure Topics, and Publish to Teams
Copilot Studio
ScenarioYour agent can now answer questions. But the most powerful agents also do things: submit a form, trigger a Power Automate flow, escalate to a human, or send a notification. In this exercise you will add a guided conversation topic, connect an action, and publish your agent so real users can access it in Microsoft Teams.
Part A: Add a Guided Topic
- 1In your agent, click the Topics tab. Topics are scripted conversation flows that trigger when a user says something specific.
- 2Click Add a topic then Create from description. In the prompt field, type the topic description below and let Copilot Studio generate the conversation flow automatically.
- 3Review the generated topic flow, adjust the questions or responses to match your organisation's process, then click Save.
Topic Description Prompt (for "Create from description")
Copy
Create a topic that triggers when a user wants to submit a leave request or check their leave balance. The topic should: (1) Ask whether they want to check their balance or submit a new request, (2) If checking balance, explain how to find their leave balance in the HR system and provide a link, (3) If submitting a request, collect the type of leave, start date, end date, and whether they have spoken to their manager, then confirm the details back to the user and tell them next steps, (4) End with an offer to help with anything else.
Part B: Connect a Power Automate Action
- 1Click the Actions tab in your agent. Click Add an action.
- 2Choose Power Automate flow. You will see any existing flows in your tenant. If you have access to one (e.g. a leave request flow, a ticket creation flow, or a notification flow), select it and connect it.
- 3If no flows exist yet, click Create a new flow and Copilot Studio will open Power Automate with the agent connection pre-configured. Build a simple flow that sends an email or creates a Teams message when called by the agent.
- 4Return to the Topics tab and connect your new action to the leave request topic so it fires when the user completes the request form.
Part C: Publish to Microsoft Teams
- 1Click Publish in the top right of Copilot Studio. This makes your agent available for deployment. Publishing takes about 1-2 minutes.
- 2Click Go to channels (or Settings then Channels). Select Microsoft Teams.
- 3Click Add to Teams. Your agent will appear as a bot in Teams that users can message directly. Share the Teams install link with your team or submit it to your IT admin for deployment via the Teams App Catalog.
- 4Open Microsoft Teams, find your agent in the Apps or Chat section, and test it end-to-end by asking it a question and triggering the leave request topic.
Advanced Copilot Studio Prompt: Agent Scope Definition
Copy
I want to build a Copilot Studio agent for our organisation. Help me define the scope by answering these questions based on the following context: [describe your team or organisation in 2-3 sentences]. What are the 5 most common questions or tasks this agent should handle? What knowledge sources would it need access to? What actions should it be able to trigger? What guardrails should it have to prevent it from answering things it should not? Format this as a ready-to-paste agent instruction set and a list of recommended topics and knowledge sources to configure.
Common Agent Use Cases by Department
HR and People
Leave requests, policy lookups, onboarding checklists, payroll queries, performance review FAQs
IT Support
Password resets, software access requests, hardware issue triage, VPN setup, ticket status checks
Finance
Expense policy lookups, approval status, budget code queries, invoice submission, PO process
Customer Service
Product FAQs, order tracking, returns and refunds, escalation routing, service status updates
Sales and BD
Product specs, pricing lookups, proposal templates, CRM record updates, meeting prep briefings
Compliance and Risk
Policy lookups, regulatory FAQs, incident reporting, audit checklists, mandatory training reminders
What makes an agent enterprise-ready: Good instructions define scope tightly. Good knowledge sources are accurate and up to date. Good topics handle the most common specific workflows. Good actions reduce manual steps. The best agents do all four. Start simple, measure what users actually ask, and iterate. An agent you can publish and improve is worth more than a perfect one that never ships.
Marked complete
Workshop Complete.
You've covered advanced prompting techniques across every Copilot surface. The difference between average and exceptional Copilot users is prompt engineering discipline - and you now have it.
Daily Catch-Up Habit
Replace morning email-scrolling with the structured re-entry brief prompt every day. Use it religiously for 2 weeks.
Build Your Prompt Library
Add 3 prompts to your Gallery this week. Aim for one prompt per major task category in your role.
Give CoWork a Real Task
This week, give CoWork one genuine multi-step autonomous task with approval gates. Note where it excels and where it needs correction.
Start a Copilot Page
Convert your next meeting debrief or project brief into a Copilot Page. Share it as the team's living reference document - not an email.
Red-Team Your Next Deck
Before every major presentation, run the "objection preparation" prompt in PowerPoint. Walk into every room more prepared than expected.
Stay Secure
Only use your company's Microsoft 365 Copilot tools. Never paste sensitive, client, or confidential data into personal AI tools outside your M365 tenant.