
Discover how Microsoft 365 Copilot shifts professionals from doing to directing — freeing hours every week by automating drafting, summarisation, and data analysis. This lecture sets the productivity mindset you will apply throughout the entire course.
Understand how Copilot lives inside Word, Excel, PowerPoint, Outlook, and Teams as a connected AI layer — not a separate app. Learn the permission model that keeps your enterprise data secure while Copilot works across every M365 surface.
Build a board-ready Copilot ROI argument using the three returns: time saved, quality improved, and strategic capacity unlocked. Master the baseline-pilot-measure-project framework that turns AI adoption from a cost into a defensible business investment.
Learn exactly where the Copilot icon lives in every M365 app, how licences are assigned, and how to troubleshoot the four most common access problems in minutes. Works on desktop, web, and mobile — so your AI assistant travels with you.
Watch a real task — rescheduling a team meeting — completed in under 60 seconds using the ask-review-refine loop. This live demo transforms Copilot from theory into a hands-on skill you can replicate immediately after the lecture ends.
Hands-on lab: open Microsoft 365 Copilot Chat and write your first prompts, then compare results as you add context. Follow the steps in your own Microsoft 365 environment.
Map Copilot's genuine strengths (drafting, synthesis, transformation) against its structural limits (hallucination risk, no real-world judgement). The trust-but-verify mindset you build here protects you in every high-stakes situation.
Confirm that your M365 Copilot data stays inside your organisation's security boundary, is never used to train public models, and inherits your existing access controls. Answer the questions your IT and compliance teams will ask first.
Apply the three professional duties — verify, disclose, respect confidentiality — to every Copilot output you produce. Learn the bright-line rules that separate responsible AI-assisted work from legally and ethically risky shortcuts.
Calibrate realistic expectations so you never feel disappointed or overconfident with AI outputs. Understand which task categories Copilot handles brilliantly and which still require your undivided human judgement and expertise.
Map Copilot onto the recurring workflows you run today — weekly reports, client emails, data reviews — and identify the highest-ROI insertion points. This practical audit turns adoption theory into a concrete personal action plan.
Track your pre-Copilot time-on-task using a simple four-column log so you can prove productivity gains with real data after completing the course. A measured baseline is the foundation of every credible Copilot success story.
Hands-on lab: build a simple tracker in Excel to record how long everyday tasks take before and after using Copilot, so you can measure your own productivity gains.
Consolidate every concept from Section 1 into a single actionable checklist — from accessing Copilot to applying the trust-but-verify rule — so you enter Section 2 with complete confidence in your AI foundations.
Discover why the quality of your prompt determines 80 percent of the quality of Copilot's output, and why prompt engineering is now the highest-leverage professional skill in an AI-augmented workplace.
Understand how large language models process instructions — context windows, token limits, and pattern completion — so you can predict exactly why a prompt succeeds or fails and fix it in seconds.
Master the five-element CRAFT prompt framework that structures every Copilot instruction for maximum clarity. Apply CRAFT to produce executive reports, client emails, and data analyses with consistent, professional results.
Hands-on lab: take weak, vague prompts and rewrite them with the CRAFT Framework (Context, Role, Action, Format, Tone). See how each element improves the result.
Learn to front-load your prompts with the business context Copilot needs — industry, audience, purpose, and constraints — so every output is relevant, accurate, and ready to send with minimal editing.
Assign Copilot a professional role — senior financial analyst, HR director, marketing strategist — to unlock expert-level framing, vocabulary, and reasoning in every response it generates for you.
Write action verbs that remove ambiguity: draft, summarise, compare, extract, rewrite, translate. Precise action specification is the single fastest way to cut the number of refinement rounds from three to one.
Instruct Copilot to deliver outputs in the exact format your workflow requires — bullet list, numbered steps, table, executive summary, slide outline — so you spend zero time reformatting and go straight to review.
Switch Copilot's communication register from formal board-report tone to conversational team-update tone with a single instruction. Master tone management so every Copilot output sounds like you, not a robot.
Chain multiple prompts in sequence to build complex outputs step-by-step — research, then analyse, then present. Iteration techniques let you refine a draft in three focused passes to reach polished, publication-ready quality.
Diagnose the seven most common prompting errors — vague requests, missing context, conflicting instructions — and apply the one-sentence fix for each. This lecture saves hours of frustrating trial and error.
Create a reusable prompt library in a Word or OneNote template so your best prompts are always one click away. A personal prompt library compresses complex tasks into repeatable, consistent, high-quality outputs every time.
Hands-on lab: save your best prompts and reuse them, so good results become repeatable instead of one-off.
Apply the A/B prompt testing method to compare two versions of the same instruction and identify which structural element drove the better result. Systematic testing turns prompt engineering from guesswork into a repeatable craft.
Download and customise ready-made CRAFT prompt templates for Finance, HR, Sales, Marketing, Legal, and Operations. Adapt each template in under two minutes for your exact role, industry, and communication audience.
Review every CRAFT element, advanced chaining technique, and common mistake fix from Section 2 in one rapid-fire summary. Leave with a completed personal prompt library ready to deploy in your real work starting tomorrow.
See how Copilot in Word collapses the document creation cycle from hours to minutes — drafting, rewriting, summarising, and collaborative review all from a single AI assistant embedded in your existing Word ribbon.
Navigate the Copilot pane, Draft with Copilot button, inline rewrite tools, and the margin icon so you can access every Word AI feature without leaving your document or hunting through menus.
Generate a fully structured first draft — complete with headings, body paragraphs, and a conclusion — from a single-sentence brief. Learn the seeding technique that gives Copilot enough context to produce boardroom-ready output on the first try.
Guided demo: watch Copilot in Word draft a proposal from reference files. Learn how to point Copilot at your source material and shape the draft.
Draft business reports, project proposals, and board papers with Copilot using the five-field CRAFT brief that controls structure, evidence, tone, and length. Cut proposal writing time by 70 percent without sacrificing quality or accuracy.
Transform dense, bureaucratic prose into clear, engaging writing using Copilot's rewrite commands. Learn the four rewrite instructions — simplify, elevate, shorten, expand — and when to apply each for maximum professional impact.
Switch a single document between C-suite executive tone, technical team tone, and client-friendly tone using targeted Copilot instructions. One document, three audiences, three minutes — with no manual rewriting required.
Condense 50-page reports, lengthy contracts, and research papers into tight executive summaries in seconds. Master the three summary formats — bullet takeaways, narrative overview, and decision brief — for different stakeholder needs.
Hands-on lab: summarise a long policy document in Word and ask Copilot questions about it to find the answers you need quickly.
Generate SOP documents from a bullet-point brief using Copilot's structured procedure template. Produce numbered steps, responsibility assignments, and compliance checkpoints that meet ISO and enterprise documentation standards.
Use Copilot to draft policy documents, compliance notices, and regulatory summaries with the right formal register and structure. Always verify high-stakes legal language with qualified counsel — Copilot accelerates the draft, not the sign-off.
Integrate Copilot into shared-document review cycles: generate comment responses, reconcile tracked changes, and draft revision notes at AI speed. Collaborative documents that once took days of back-and-forth now close in hours.
Draft C-suite memos, board updates, and all-staff announcements that balance authority with clarity using Copilot's executive communication templates. Deliver the right message at the right level every time.
Convert complex technical specifications and engineering notes into plain-language documentation using Copilot's simplify and structure commands. Produce user guides, API docs, and IT runbooks that non-technical readers can follow.
Build a reusable library of AI-drafted email templates — onboarding, client follow-up, escalation, and decline letters — that maintain your brand voice and save 20+ minutes every day on routine correspondence.
Resolve the five most common Word Copilot problems — missing icon, greyed-out Draft button, incomplete outputs, unexpected tone — with step-by-step fixes you can apply in under two minutes without contacting IT support.
Use Copilot's direct edit mode to rewrite sections in-place, insert missing paragraphs, and restructure argument flow — all without copy-pasting into a side pane. This advanced workflow is the fastest route to a polished final document.
Hands-on lab: edit a document directly with Copilot in Word, including rewriting, tightening and changing tone in place.
Consolidate every Word Copilot skill from Section 3 — drafting, rewriting, summarising, SOPs, collaborative review — into a single checklist you can use to audit your own capability and identify any remaining gaps.
Discover how Microsoft 365 Copilot removes the formula barrier entirely — letting you ask questions about your data in plain English and receive instant charts, PivotTables, and insights. This lecture frames the Excel transformation: from spreadsheet user to data-powered decision-maker.
Navigate the Excel Copilot pane, understand the table-formatting prerequisite, explore suggested prompts, and learn the five core capability categories — insight, action, formula, advanced analysis, and the new COPILOT function. Two minutes of correct setup unlocks the entire Excel AI capability set.
Ask Copilot questions like 'Which product line had the highest margin in Q3?' and receive instant, accurate answers with supporting evidence highlighted in the sheet. Natural language analysis replaces hours of manual pivot-table work.
Describe any calculation in plain English and watch Copilot build the correct formula — complete with your actual column names, an explanation of the logic, and instant insertion into the table. VLOOKUP, nested IFs, SUMIFS, and XLOOKUP are all one sentence away.
Hands-on lab: use Copilot in Excel to create formulas and formula columns from plain-English instructions, then check the results.
Ask Copilot to show you what is interesting in your data and receive automatically surfaced trends, outliers, correlations, and segment performance differences — all without specifying exactly what to look for. Pattern recognition turns a spreadsheet full of numbers into a strategic story in minutes.
Create professional bar charts, line charts, scatter plots, and PivotTables from a single plain English prompt — Copilot selects the right chart type, labels the axes, and inserts a formatted visual ready for reports or slides. Every data insight becomes a shareable visual in under thirty seconds.
Perform variance analysis, profitability calculations, working capital assessments, and investment return modelling without building every formula manually. Copilot writes the financial logic from plain language descriptions and frees finance professionals to focus on the interpretive expertise that numbers alone cannot provide.
Build driver-based budget templates, rolling forecast models, and sensitivity tables using natural language instructions. Copilot constructs the formula architecture of the model so the planning team can spend its time on assumption quality and strategic thinking rather than mechanical spreadsheet construction.
Fix inconsistent text values, remove duplicates, standardise date formats, convert text-stored numbers, and fill intelligent gaps — all through the Clean Data feature and targeted prompts. A dataset that would take thirty minutes of manual correction is standardised in under two minutes.
Hands-on lab: clean, analyse and chart a sales dataset with Copilot in Excel, and learn how to verify what it produces.
Identify month-over-month growth rates, seasonal cycles, accelerating or decelerating trends, and inflection points across any time-series dataset using plain English questions. Turn twelve months of raw numbers into a clear directional narrative ready for management review.
Build a multi-metric executive dashboard — combining KPI summaries, trend charts, variance highlights, and conditional formatting — from a plain language brief. Copilot constructs the layout, writes the formulas, and creates the visual layer that makes data immediately readable for leadership.
Compare products, regions, teams, time periods, or scenarios side by side using natural language prompts that produce structured comparison tables, charts, and ranked summaries. Comparative analysis that previously required complex pivot configurations arrives from a single descriptive sentence.
Build what-if models and sensitivity tables that show how outcomes change as key assumptions vary — growth rate, headcount, price, or cost — without configuring Excel's data table tools manually. Scenario planning becomes a conversational exercise rather than a technical construction project.
Apply data validation rules, identify formula errors, flag out-of-range values, and audit spreadsheet logic using Copilot's diagnostic capabilities. Catch the quality issues that undermine analysis confidence before a spreadsheet leaves your hands.
Use Copilot's Python-powered advanced analysis mode to run forecasting models, regression analysis, clustering, and statistical significance testing — all from plain English descriptions, with no Python code required. Enterprise-grade analytics that previously required a data scientist are now one prompt away.
Connect your Excel Copilot analysis to Power BI for live, shared dashboards — exporting insights, publishing datasets, and maintaining the data connection that keeps reports current automatically. Learn where Excel ends and Power BI begins, and how Copilot bridges the two.
Resolve the most common Excel Copilot issues — greyed-out button, inaccurate formula output, Python analysis errors, and chart format problems — with a step-by-step diagnostic checklist. Every issue has a predictable cause and a fast fix that does not require IT support.
Review every Excel Copilot capability — natural language analysis, formula generation, financial modelling, dashboards, and automation — from Section 4 in one consolidated checklist before moving into PowerPoint excellence.
Discover how Copilot in PowerPoint collapses presentation creation from hours to minutes — generating fully structured decks from a prompt or a Word document, with AI-generated images, speaker notes, and on-brand slide design. The blank slide is no longer the starting point.
Type a topic and an audience, and watch Copilot generate a complete, structured presentation with slides, titles, body content, and layout — ready to refine in minutes. Your first AI-created presentation will change how you think about every deck you build from this point forward.
Convert any Word document — a report, proposal, or briefing — into a fully structured PowerPoint presentation in seconds. Copilot reads the document structure, extracts the key points, and builds slides that match the logic of the written content without any manual copy-pasting.
Hands-on lab: turn a Word document into a PowerPoint presentation with Copilot, then refine the structure and slides.
Reorganise slides, add missing sections, remove redundant content, and rewrite weak titles across an existing presentation using natural language instructions in the Copilot pane. Transform a rough draft deck into a polished, coherent narrative without rebuilding it from scratch.
Generate professional, on-brand images for your slides using FLUX.2 Flex image generation — describing the visual you need in plain English and receiving a custom, royalty-free image in seconds. Combined with PowerPoint brand kits, every slide looks visually consistent and professionally designed.
Generate comprehensive speaker notes for every slide, create a presentation summary for pre-reading, and build a one-page executive brief — all from the deck itself, in seconds. Arrive at every presentation fully prepared without spending an evening writing notes.
Hands-on lab: add speaker notes to a deck and summarise it with Copilot in PowerPoint.
Build high-stakes presentation types — investor proposals, board briefings, client pitches, and sales decks — using structured Copilot workflows that start with the audience's priorities and end with a persuasive, professionally formatted deliverable.
Apply PowerPoint Copilot to the specific presentation types your role demands — Finance board packs, HR town halls, Sales proposals, Operations reviews, and Marketing campaign decks — with role-specific prompting strategies that produce department-ready outputs from the first draft.
Use Copilot to check and improve presentation accessibility — alt text for images, reading-order clarity, colour contrast, and language simplification for global audiences. Build presentations that every audience member can access and understand, regardless of ability or native language.
Diagnose and resolve the most common PowerPoint Copilot issues — missing features, inconsistent slide formatting, image generation failures, and template conflicts — and apply a pre-publish quality checklist that ensures every deck meets professional standards before it leaves your hands.
Discover how Microsoft 365 Copilot in Outlook reclaims the hours lost to email management — summarising long threads, drafting polished replies, prioritising what matters, and turning your calendar from a burden into an intelligently managed asset.
Navigate the Copilot features built into Outlook's compose window, reading pane, and calendar interface — understanding exactly where each capability lives, how to activate it, and what each tool is designed to accomplish in your daily communication workflow.
Summarise any email thread — however long, however tangled — into a clear brief of what happened, what was decided, and what is needed from you, in seconds. Thread summarisation is the single fastest way to regain control of a busy inbox without missing anything important.
Go from a blank compose window to a contextually accurate, professionally toned reply draft using a single prompt — with Copilot reading the thread automatically to ensure every response is relevant, complete, and appropriately voiced.
Use Copilot's email coaching feature to receive real-time feedback on tone, clarity, length, and likely reader response before you hit send. Write emails that land the way you intend — not the way inbox fatigue or time pressure accidentally shaped them.
Hands-on lab: summarise email threads, draft replies and get coaching on your writing with Copilot in Outlook.
Ask Copilot to identify the emails that need your attention today — the ones with deadlines, decisions, or dependencies — and surface them above the noise. Inbox prioritisation turns a hundred unread messages into a manageable daily action list in under a minute.
Use Copilot to summarise meeting context before it starts, draft agendas from email threads, suggest optimal scheduling windows, and generate action-item follow-ups the moment a meeting ends. Your calendar becomes a productivity system, not a schedule you manage manually.
Guided demo: prepare for and schedule meetings with Copilot in Outlook.
Explore Copilot's agentic capabilities in Outlook — where AI handles recurring email tasks, drafts responses to standard enquiries, and monitors threads for items requiring your attention — working in the background so your inbox manages itself between the moments you engage with it.
Apply Outlook Copilot to the high-stakes communication scenarios that define professional relationships — client updates, executive briefings, escalation management, and cross-border correspondence — with prompting strategies that produce the right message for the right audience every time.
Master the drafting scenarios that demand the most professional judgement — delivering bad news, managing a sensitive complaint, declining a request diplomatically, or writing an escalation that is firm without being damaging. Copilot drafts the difficult message; you bring the human judgement.
Build a structured daily Outlook routine — a morning inbox triage using Copilot summaries, a midday reply session using drafted responses, and an end-of-day thread clearance — that makes inbox zero an achievable daily outcome rather than a distant aspiration.
Understand how Copilot respects sensitivity labels, existing permissions, and compliance policies within Outlook — and learn the user-level practices that keep confidential communications protected when AI assistance is involved in drafting and summarising.
Build shared Outlook Copilot habits across your team — consistent thread summarisation practices, shared prompt templates for common communication types, and team-level agreements about when and how AI drafting assistance is used — turning individual adoption into collective communication excellence.
Consolidate every Outlook Copilot capability from Section 6 — thread summarisation, smart drafting, coaching, inbox prioritisation, calendar intelligence, and agentic features — into a checklist and commit to the three daily habits that will permanently reduce your time in the inbox.
Discover how Copilot in Teams transforms every meeting from a time cost into a structured, documented, action-producing event — with automatic summaries, real-time assistance, and post-meeting follow-up that happens without anyone having to take a single manual note.
Navigate the Copilot features available before, during, and after Teams meetings — where the icon lives, how to activate live meeting assistance, and how to access the meeting intelligence panel that contains summaries, transcripts, and action items after the call ends.
Generate a structured meeting summary — covering key decisions, assigned actions, open questions, and next steps — automatically after any recorded Teams meeting. Summaries that once took thirty minutes of note reconciliation are ready in seconds, shared with the team before the call window closes.
Demo: ask Copilot to recap a Teams channel into short notes, open questions and action items with owners, then draft a follow-up message that you check before posting.
Ask Copilot live questions during a meeting — 'What did Sarah say about the deadline?' or 'Summarise the discussion so far' — without interrupting the flow or missing anything while you type notes.
Draft the follow-up email, produce the action-item list, create the meeting minutes document, and schedule the next calendar event — all from the Teams meeting summary, in under five minutes. Post-meeting administration that previously consumed the hour after every call is fully automated.
Use Copilot across Teams channels to summarise project thread history, extract open tasks from channel conversations, draft status updates, and surface decisions buried in weeks of chat — turning Teams channels from message archives into active, navigable project intelligence systems.
Apply Teams Copilot to the workflows that cross departmental boundaries — joint project kick-offs, cross-functional review meetings, multi-team escalation threads — extracting the decisions and dependencies that matter to each stakeholder group from a single shared record.
Use Copilot to close the information gap between in-room and remote participants — generating real-time summaries for late joiners, producing catch-up briefings for absent colleagues, and ensuring distributed teams have equal access to the intelligence that in-person participants absorb naturally.
Extend Copilot beyond meetings into Teams chat and channel conversations — summarising long thread histories, finding specific decisions or commitments made in past messages, and drafting responses that reflect the full context of a channel conversation without reading every message.
Guided demo: catch up on chats and channels with Copilot in Teams so you can find what matters fast.
Use Copilot to synthesise team activity data, meeting frequency patterns, action-item completion rates, and communication health signals from Teams — producing a clear picture of team engagement and delivery without manual reporting or spreadsheet construction.
Chain Teams Copilot with Word, Excel, PowerPoint, and Outlook in end-to-end workflows — converting a Teams meeting into a Word report, exporting action items into an Excel tracker, creating a PowerPoint summary from the meeting record, and emailing the output directly from Outlook.
Consolidate every Teams Copilot capability from Section 7 — meeting summaries, real-time assistance, post-meeting automation, channel intelligence, and cross-app integration — into a mastery checklist and identify the three meeting types in your calendar that will benefit most immediately.
Discover Microsoft 365 Copilot Chat as the AI hub that reaches across every application in your Microsoft 365 estate — combining information from emails, documents, meetings, and chats into unified answers, rich research briefings, and collaborative Copilot Pages that your whole team can build on.
Map the full capability set of Copilot Chat — cross-application retrieval, file analysis, web-grounded research, AI model selection, Copilot Pages creation, and enterprise search — and understand exactly when to use Copilot Chat versus Copilot inside a specific application.
Ask Copilot Chat questions that span multiple apps — 'Summarise all emails and documents related to the Henderson project' — and receive a unified answer drawn from your entire M365 data estate in seconds.
Draft documents, briefings, and reports that draw simultaneously from emails, spreadsheets, meeting notes, and external research — producing a single, coherent output that synthesises sources a human would take hours to manually read and reconcile.
Use Copilot Chat to prepare for a client meeting, a board presentation, or a competitive review by gathering intelligence from your internal files and the web simultaneously — producing a structured briefing document in minutes that would previously require a full research day.
Query your organisation's data across multiple file types and sources in a single natural language question — 'What do our recent project reports say about delivery risk?' — and receive a synthesised, evidence-cited answer drawn from the breadth of your Microsoft 365 content.
Upload PDFs, Word documents, spreadsheets, and presentations directly into Copilot Chat for instant analysis, summarisation, extraction, and comparison — without opening the files in their native applications or switching between multiple tools.
Hands-on lab: upload PDFs and other files to Copilot Chat, then analyse them and ask questions about the content.
Build Copilot Pages — living, editable documents that capture AI-generated research, summaries, and insights — and share them with colleagues for collaborative refinement. Copilot Pages turn a one-time research session into a persistent, team-accessible knowledge asset.
Hands-on lab: turn a Copilot Chat response into a shareable Copilot Page you can edit and send to colleagues.
Use Copilot Chat as an intelligent enterprise search engine — finding specific documents, decisions, commitments, and expertise buried across your organisation's SharePoint, Teams, Exchange, and OneDrive estate — with natural language queries that return ranked, cited results in seconds.
Understand when to select different AI models within Copilot Chat for different task types — choosing the right balance of reasoning depth, speed, and context capacity for complex analysis, creative drafting, real-time research, or straightforward summarisation.
Guided demo: use the Researcher and Analyst agents for deep work, and learn when to choose each one.
Consolidate every Copilot Chat capability from Section 8 — cross-app retrieval, file analysis, research, Copilot Pages, enterprise search, and model selection — into a mastery checklist and identify the three information-gathering workflows in your role that Copilot Chat can transform this week.
Discover how chaining Copilot across multiple Microsoft 365 applications multiplies the productivity impact of each individual tool — turning the research-to-report pipeline, the meeting-to-action cycle, and the data-to-decision workflow into seamless AI-powered processes.
Build a complete research-to-report-to-presentation pipeline using Copilot Chat for research, Word for the report, and PowerPoint for the deck — with each stage grounded in the output of the previous one and the total time reduced from a full day to under two hours.
Hands-on lab: build a research-to-report-to-presentation pipeline across Copilot Chat, Word and PowerPoint.
Chain Excel analysis through Copilot Chat to Word and PowerPoint — turning raw data into visualised insights, then into a decision-ready report, then into an executive presentation — with Copilot maintaining the analytical thread across every application transition.
Build the complete post-meeting workflow in Teams and Outlook — automatic summary, structured action list, follow-up email, and progress-tracking document — all from a single meeting record, with every output generated and distributed in under ten minutes.
Design repeatable content production workflows — brief in Word, research in Copilot Chat, draft in Word, visualise in PowerPoint, distribute via Outlook — that turn a single content brief into multiple formats for multiple audiences without starting from scratch at each stage.
Build the complete executive briefing workflow — intelligence gathering in Copilot Chat, synthesis in Word, visualisation in PowerPoint, and pre-meeting distribution in Outlook — producing a boardroom-ready briefing pack in a fraction of the time traditional preparation requires.
Apply Copilot across the full project lifecycle — initiation documents in Word, planning models in Excel, stakeholder presentations in PowerPoint, meeting management in Teams, and status communications in Outlook — with each phase's Copilot output feeding into the next.
Build the complete customer engagement workflow — research and briefing in Copilot Chat, proposal in Word, pitch deck in PowerPoint, follow-up in Outlook, and meeting management in Teams — with AI assistance at every client-facing touchpoint from first contact to signed agreement.
Chain Excel modelling, Word narrative, PowerPoint visualisation, and Outlook distribution across the complete financial planning and reporting cycle — from budget template to board report to management communication — with AI assistance compressing the time cost of every stage.
Use Copilot to support the strategic planning process — environmental scanning in Copilot Chat, analysis in Excel, strategy documents in Word, board presentations in PowerPoint, and team communications in Outlook — turning a months-long planning cycle into a structured, AI-accelerated process.
Build cross-application QA and review workflows — document review in Word, data validation in Excel, presentation review in PowerPoint, and approval communications in Outlook — using Copilot at each stage to accelerate the review cycle without reducing the rigour.
Review every multi-app workflow pattern from Section 9 — research pipelines, meeting cycles, financial planning, content production, and custom design — with a checklist and a personal workflow planning template.
Discover how Microsoft 365 Copilot adapts to the specific tasks, document types, and communication demands of each professional function — and learn the role-specific prompting strategies that turn a general AI assistant into a specialist productivity partner for your exact job.
Apply Copilot to the core Finance workflow — variance analysis in Excel, board report drafting in Word, budget presentation in PowerPoint, and stakeholder communication in Outlook — with role-specific prompts that produce finance-grade analytical outputs from each application.
Use Copilot across the HR function — policy drafting in Word, headcount analysis in Excel, town hall presentations in PowerPoint, and candidate and employee communications in Outlook — with HR-specific prompts that maintain the balance of legal precision and human warmth.
Build the complete sales productivity workflow with Copilot — client research in Copilot Chat, proposal drafting in Word, pitch deck creation in PowerPoint, and CRM-linked follow-up in Outlook — compressing the sales preparation cycle and improving the quality of every client interaction.
Apply Copilot to the marketing content lifecycle — campaign briefs in Word, performance analysis in Excel, campaign presentations in PowerPoint, and audience communications in Outlook — with marketing-specific prompts that maintain brand voice while dramatically accelerating content production.
Use Copilot for operations excellence — SOP creation in Word, process performance analysis and defect tracking in Excel, operational review presentations in PowerPoint, and cross-functional communications in Outlook — with operations-specific prompts that balance procedural precision with accessibility for frontline teams.
Apply Copilot to the complete project management workflow — initiation documents, risk registers, and status reports in Word, project trackers and resource models in Excel, stakeholder presentations in PowerPoint, and meeting management in Teams — compressing every phase of the project communication cycle.
Use Copilot to support executive leadership productivity — strategy documents and board papers in Word, financial models and scenario analysis in Excel, board presentations in PowerPoint, and all-hands communications in Outlook — with leadership-specific prompts that produce CEO-level outputs from every application.
Build the customer success workflow with Copilot — QBR preparation in Copilot Chat and Word, health score analysis in Excel, customer presentations in PowerPoint, and relationship communications in Outlook — with prompts that produce the right balance of data rigour and personal warmth.
Apply Copilot to the legal function — contract summarisation and policy drafting in Word, compliance data analysis in Excel, regulatory presentations in PowerPoint, and formal legal communications in Outlook — with the verification discipline that high-stakes legal work requires at every stage.
Use Copilot for IT productivity — system documentation and user guides in Word, infrastructure data analysis in Excel, technical presentations in PowerPoint, and IT communications in Outlook — with IT-specific prompts that make complex technical content accessible to non-technical audiences.
Build the consulting delivery workflow with Copilot — research in Copilot Chat, proposal and deliverable drafting in Word, data analysis in Excel, client presentations in PowerPoint, and relationship management in Outlook — compressing the billable hour cost of every engagement phase.
Apply Copilot to healthcare administration — patient communication drafting in Word, clinical data summarisation in Excel, and operational presentations in PowerPoint — with the sensitivity, compliance awareness, and verification discipline that clinical and administrative healthcare work demands.
Use Copilot across the education workflow — lesson plan and curriculum document creation in Word, student performance analysis in Excel, presentation of learning outcomes in PowerPoint, and parent and institutional communications in Outlook — with prompts calibrated for the language and standards of educational settings.
Apply Copilot to manufacturing operations — quality procedure documentation in Word, production data analysis and defect tracking in Excel, operational review presentations in PowerPoint, and supplier and team communications in Outlook — with manufacturing prompts that connect quality data to process improvement.
Hands-on lab: build a prompt pack for a department, with reusable role-based prompts your team can share.
Consolidate the department-specific Copilot applications from Section 10 into a role-matched capability checklist — identifying the three most time-consuming tasks in your function that Copilot can immediately improve, and building the first role-specific prompt template for your personal library.
This course contains the use of artificial intelligence.
Microsoft 365 Copilot is the most significant productivity shift in enterprise software in a generation — and most professionals use only a fraction of what it can do.
This course gives knowledge workers, enterprise teams and business professionals a complete, structured system for mastering Microsoft 365 Copilot. You learn a repeatable prompting method — the CRAFT Framework (Context, Role, Action, Format, Tone) — and then practise it across Word, Excel, PowerPoint, Outlook, Teams and Copilot Chat in 23 hands-on labs and demos.
How You Learn:
Narrated concept lessons — structured, slide-based video lessons teach the concepts, frameworks and strategies clearly on any device, even without a Copilot licence.
23 hands-on labs and demos — 17 labs and 6 demos with step-by-step guided videos, from your first prompts in Copilot Chat to a complete capstone workflow. Each one is a task you repeat in your own Microsoft 365 environment.
15 section quizzes (10 questions each) and 2 full practice tests to check your understanding.
15 enterprise role-play scenarios — one at the end of every section — where you apply the skills to a realistic workplace situation.
Downloadable prompt templates and frameworks you can use immediately at work.
What You Will Be Able to Do After This Course:
Write high-quality, structured prompts with the CRAFT Framework and save them in a reusable personal prompt library
Draft, rewrite, summarise and edit documents in Microsoft Word with Copilot, including from reference files
Create formulas, clean data, analyse results and build charts in Microsoft Excel in plain English
Turn a Word document into a professional PowerPoint deck, with speaker notes and summaries
Summarise, draft and coach emails and schedule meetings with Copilot in Outlook
Catch up on chats, channels and meetings with Copilot in Teams
Use Copilot Chat, Pages, and the Researcher and Analyst agents for deep research and shareable outputs
Build department prompt packs, a simple agent, scheduled prompts and a research-to-report-to-presentation pipeline
Fact-check Copilot answers, recover from flawed responses and use Copilot responsibly with a clear view of enterprise data security, governance and compliance
Measure your productivity baseline and build the business case for Copilot adoption in your organisation
Course Structure — What Is Inside:
The course has 15 sections, each ending with a quiz and a role-play scenario:
Section 1 — Microsoft Copilot Foundations for Enterprise Success: how Copilot fits the modern enterprise, data security basics and your productivity baseline
Section 2 — Master Prompt Engineering for Business Results: the CRAFT Framework, common mistakes and your reusable prompt library
Section 3 — Copilot in Microsoft Word — Document Excellence: drafting from reference files, summarising long policies and editing in place
Section 4 — Copilot in Microsoft Excel — Data Intelligence: formulas, cleaning, analysis and charts on a sales dataset
Section 5 — Copilot in Microsoft PowerPoint — Presentation Excellence: turning a Word document into a deck, plus speaker notes and summaries
Section 6 — Copilot in Microsoft Outlook — Communication Excellence: summarising, drafting and coaching emails, and scheduling meetings
Section 7 — Copilot in Microsoft Teams — Collaboration Intelligence: meeting intelligence and catching up on chats and channels
Section 8 — Microsoft 365 Copilot Chat — Your AI Assistant Everywhere: working with files, shareable Pages, and the Researcher and Analyst agents
Section 9 — Advanced Cross-Application Workflows: research-to-report-to-presentation pipelines across apps
Section 10 — Department-Specific Copilot Applications: role-based prompt packs for Finance, HR, Sales, Legal, Operations and Marketing
Section 11 — Enterprise Security, Governance, and Compliance: data protection, permissions, auditing and risk management
Section 12 — Team Adoption and Change Management: building a simple agent, adoption reports and organisational messages
Section 13 — Advanced Prompt Engineering and Power User Techniques: chaining, iteration, scheduled prompts and team prompt libraries
Section 14 — Troubleshooting, Optimization, and Continuous Learning: fact-checking and recovering from flawed answers
Section 15 — Your Personal Copilot Productivity System: a capstone business-transformation workflow that ties everything together
A final section holds two full-course practice tests.
More hands-on demos and labs are being added over time, including a Teams meeting recap demo, a Microsoft Purview audit demo and a Power Automate recurring-task demo.
Who This Course Is For:
Knowledge workers and enterprise professionals who use Microsoft 365 daily and want to work faster and smarter with AI
HR, Finance, Marketing, Operations and Project Management professionals who want to apply Copilot to their own workflows
Managers and team leads who want to run meetings, manage communications and drive team productivity with Copilot
IT administrators and change management professionals planning or supporting a Copilot rollout
Business owners and entrepreneurs who want enterprise-grade AI without hiring additional staff
This course is not for people who want only a brief overview. It is a complete, structured programme for professionals who want to go deep.
Prerequisites:
A Microsoft 365 subscription (some features and labs require a Microsoft 365 Copilot licence; the concept lessons can be followed without one)
Basic familiarity with Word, Excel, Outlook and Teams (beginner to intermediate level)
No prior experience with Copilot, AI tools or prompt writing is needed — everything is taught from the ground up
About the Course Design and Production:
The course content, structure, teaching framework, enterprise scenarios and all subject-matter decisions were designed by the instructor, based on deep expertise in Microsoft 365 and enterprise productivity. AI tools supported the creation of presentation visuals, narration and lab videos. Every lesson, lab and quiz was reviewed and validated by the instructor for accuracy and real-world relevance.
A Note from the Instructor:
Microsoft 365 Copilot is not a feature. It is a fundamental shift in how enterprise work gets done. I built this course so every learner walks away with a complete, repeatable system they can use every day — not just a collection of tips. I will see you inside.
Microsoft, Microsoft 365, Copilot, Teams, Outlook, Word, Excel, PowerPoint, SharePoint and Entra are trademarks of the Microsoft group of companies. This course is independently developed and is not affiliated with, sponsored by, or endorsed by any of these organizations.