Office 365 & Microsoft Copilot
Saving Time — Everyday Productivity Training
01Training Overview
- Duration
- 1 Day
- Training Hours
- 09:30 – 16:30
- Maximum Participants
- 20 Participants
- Hands-on Ratio
- 80% Hands-on / 20% Theory
- Certificate
- Participants will receive an IBA Consultancy Certificate of Participation at the end of the training.
- Format
- Online, On-site or Hybrid — based on the organisation's preference.
- Prerequisites
- None. No technical background is needed — suitable for all employees who use Microsoft 365.
Training Objective
This training aims to save every knowledge worker real time each week. The programme covers, hands-on, how Microsoft 365 Copilot works and where it applies, drafting and summarising emails in Outlook, producing meeting summaries and action lists in Teams, drafting and designing in Word and PowerPoint, generating analysis and insights in Excel, and prompting best practices for everyday productivity.
The training runs through short, independent scenarios across the five Microsoft 365 apps participants use every day — rather than a single project, it covers practical exercises spanning the whole daily workflow.
By the end of the training, participants use Copilot correctly inside the Outlook, Teams, Word, PowerPoint and Excel apps they use every day, saving real time each week.
Technical Content
Microsoft 365 Copilot Fundamentals
- How Copilot works: generating responses based on email, calendar, file and chat data through Microsoft Graph
- Organisation-wide Q&A and general-purpose chat with Copilot Chat
- Basic awareness of what data Copilot can access and how permissions work
- Creating skills and using them within Office 365
Outlook Copilot
- Summarising and categorising unread emails by importance and urgency
- Summarising long email threads with multiple replies in a single paragraph
- Generating draft replies that reference previous correspondence and attached files
- Rewriting emails in a chosen tone (formal, concise, persuasive, etc.) and adjusting length
- Grouping the inbox by topic/project and suggesting a priority order
- Getting Copilot coaching feedback on the tone and clarity of a draft email
Teams Copilot
- Real-time conversation summary and tracking of key points during a live meeting
- Generating an automatic post-meeting summary, decisions made and a list of action items
- Quickly catching up on a missed meeting with "summarise what was discussed"
- Summarising the discussion on a specific topic from chat history
- Asking questions about earlier discussions during a meeting ("what was decided on this before?")
- Generating a draft agenda for the next meeting from previous meeting notes
Word & PowerPoint Copilot
- Word: generating a draft document/report from scratch from a prompt or source file
- Word: rewriting, shortening/lengthening and changing the tone of existing text
- PowerPoint: generating a complete presentation from a Word document or a prompt
- PowerPoint: redesigning existing slides with Designer and getting image suggestions
- PowerPoint: summarising speaker notes and getting presentation rehearsal feedback
Excel Copilot
- Producing analysis by querying a data table in natural language, without writing formulas
- Automatically detecting and summarising trends, outliers and patterns
- Getting formula suggestions from natural language and explanations of existing formulas
- Chart/visualisation suggestions suited to the data, with automatic creation
- Quickly building models for simple "what-if" scenarios
- Data cleansing suggestions: detecting inconsistencies, blank cells and duplicate records
- A use case for a skill created within Excel
02Exercises and Project Scenarios
Scenario 1
Email Drafting and Summarising with Outlook
Covers summarising a long email thread and preparing a draft reply with Copilot.
Scenario 2
Meeting Summary with Teams
Covers producing an automatic summary and action list from a meeting recording.
Scenario 3
Drafting with Word & PowerPoint
Covers quickly drafting a document and turning it into a presentation.
Scenario 4
Analysis and Insights with Excel
Covers analysing a data table with Copilot and generating summary insights.
Together, the four scenarios show how Copilot fits into the whole daily workflow — correspondence, meetings, documents and data. The four scenarios below are independent of each other and all are covered in the training; unlike the "choose one case and grow it" model of the Power Platform trainings, this training is delivered separately across five Microsoft 365 apps because it needs to cover the participant's whole daily workflow (correspondence, meetings, documents, data). In each scenario, participants can bring their own real email/report/data samples; IBA provides sample content for those who cannot.
03Training Agenda (1 Day)
The agenda is completed end to end in a single day; participants start the morning with Copilot fundamentals and Outlook, and finish the day having practised across Teams, Word/PowerPoint and Excel.
Day 1 — Everyday Productivity with M365 Copilot
- Opening: how Microsoft 365 Copilot works — generating responses based on email, calendar, file and chat data through Microsoft Graph
- General-purpose Q&A and access to organisational information with Copilot Chat
- Writing effective prompts: techniques for giving context, role, format and examples
- Exercise 1: Writing a first prompt with context/role/format and trying it in Copilot Chat
- Copilot in Outlook: summarising and categorising unread emails by importance
- Copilot in Outlook: summarising long email threads with multiple replies
- Copilot in Outlook: generating draft replies that reference previous correspondence and attached files
- Copilot in Outlook: rewriting emails in a chosen tone and prioritising the inbox
- Exercise 2: Summarising a long email thread and preparing a draft reply that references previous correspondence
- Exercise 3: Grouping the inbox by topic/project and producing a priority order
- Copilot in Teams: real-time summary and tracking of key points during a live meeting
- Copilot in Teams: generating an automatic post-meeting summary, decisions and a list of action items
- Copilot in Teams: quickly catching up on a missed meeting and summarising a topic from chat history
- Exercise 4: Producing a summary, decisions and an action list from a meeting recording
- Exercise 5: Generating a draft agenda for the next meeting from previous meeting notes
- Copilot in Word: generating a draft document/report from scratch from a prompt or source file, rewriting existing text
- Copilot in PowerPoint: generating a complete presentation from a Word document, redesigning with Designer
- Exercise 6: Drafting a report in Word, turning it into a PowerPoint presentation and improving its design with Designer
- Copilot in Excel: producing analysis by querying a data table in natural language, without writing formulas
- Copilot in Excel: automatically detecting trends, outliers and patterns; getting formula suggestions from natural language
- Copilot in Excel: chart/visualisation suggestions suited to the data, with automatic creation
- Exercise 7: Extracting summary insights from a data table and visualising them with a suitable chart
- General review, Q&A
04Technical Requirements
- Computer
1 per participant (Windows or macOS), with an internet connection
- Account
A work/school account with a Microsoft 365 Copilot licence assigned
- Software
Outlook, Teams, Word, PowerPoint, Excel (desktop or web version)
- Sample Content
Participants can bring their own email/report/data samples; IBA provides sample content for those who cannot
Licensing
This training requires participants to have a Microsoft 365 Copilot licence assigned in advance.
M365 Copilot is a paid add-on licence to a Microsoft 365 subscription (per-user add-on); the organisation must assign this licence to participants before the training.
For licence assignment and trial options, we recommend speaking to the organisation's Microsoft representative — this is outside the scope of the training.
05Learning Outcomes
- Speed up correspondence
Summarise long email threads in Outlook and generate draft replies.
- Produce meeting outputs
Extract summaries and action lists from Teams meeting recordings.
- Prepare documents
Produce quick drafts and designs with Copilot in Word and PowerPoint.
- Analyse data
Extract summary insights from a table in Excel.
- Write effective prompts
Design prompts with context/role/format for their daily tasks.

