1. Home
  2. Masterclasses
  3. Microsoft Office & Copilot

Microsoft Office & Copilot AI

The essential 2026 office toolkit. Word, Excel, PowerPoint, Outlook and Teams — supercharged by Microsoft Copilot AI built directly into every app. Our most popular masterclass.

Free after redundancy in Wales with Welsh Government ReAct+ funding

Check if you qualify Download course info (PDF)
5 daysAbout 40 hours, 9am to 5pm
BeginnerLevel
Maesteg or onlineLlynfi Enterprise Centre or live online
£0With ReAct+ funding

What you'll learn on the Microsoft Office & Copilot course.

Microsoft Office skills appear on 80% of job adverts in Wales. But most people are self-taught, use maybe 10% of what the tools can do, and have never touched the AI features that arrived in 2024.

This five-day masterclass takes you from wherever you are — even total beginner — through to advanced features and Copilot AI across the full Microsoft 365 suite.

By Friday you'll be visibly, measurably more productive than your colleagues. That's the point.

40hIntensive training
5Hands-on labs
3Portfolio deliverables
1:6Tutor ratio max

Five days, one step at a time.

Mornings are taught sessions. Afternoons are hands-on labs where you build something real.

  1. Day 1

    Word & Copilot AI

    From blank page to polished document — plus Copilot's AI drafting, rewriting and summarisation built right in.

    • Document structure & styles
    • Headers, footers & page numbers
    • Tables of contents
    • Track changes & collaboration
    • Copilot AI: draft from prompt
    • Copilot AI: rewrite & summarise

    LabCreate a professional report using Word and Copilot together

  2. Day 2

    Excel & Copilot AI

    Formulas, pivot tables, charts — then Copilot's AI to analyse, highlight insights and build dashboards automatically.

    • Essential formulas (VLOOKUP, IF, SUMIF)
    • Pivot tables & charts
    • Conditional formatting
    • Data validation
    • Copilot AI: analyse data
    • Copilot AI: formula suggestions

    LabBuild a budget tracker with formulas, pivots and AI insights

  3. Day 3

    PowerPoint & Outlook

    Presentations that don't bore people, plus email management that reclaims your morning.

    • Slide design principles
    • PowerPoint Copilot: deck from prompt
    • Animations & transitions done right
    • Outlook inbox management
    • Rules, categories & quick steps
    • Copilot AI: email drafting & summaries

    LabCreate a client-ready presentation and organise a chaotic inbox

  4. Day 4

    Teams & Collaboration

    The hub of modern work. Channels, meetings, file sharing, and the Copilot features that summarise everything.

    • Teams channels & governance
    • Effective meetings & agendas
    • Screen sharing & whiteboard
    • Teams Copilot: meeting recaps
    • SharePoint integration
    • OneDrive best practices

    LabDesign and run a structured team meeting using Teams + Copilot

  5. Day 5

    Advanced Copilot & Automation

    Copilot across the full suite, plus Power Automate basics to connect your Office apps into automated workflows.

    • Copilot prompt mastery
    • Cross-app Copilot workflows
    • Power Automate basics
    • Recurring task automation
    • Personal productivity audit
    • Building your daily AI workflow

    CapstoneBuild your personal Copilot-powered daily workflow

Learner using Microsoft Office with Copilot AI on the free Microsoft Office and Copilot course

Three real projects for your CV.

You leave with work you can show an employer, not just a certificate.

  • Personal Copilot Workflow

    A documented daily workflow using Copilot across Word, Excel, Outlook, PowerPoint and Teams — your productivity secret weapon.

  • Automated Reporting Template

    An Excel + Copilot reporting template that refreshes, analyses and summarises data at the click of a button.

  • Productivity Audit

    A before/after analysis of your work showing exactly how much time AI-enhanced Office skills save you each week.

Is this course right for you?

Best for: Office workers, admin staff, jobseekers, anyone.

This is for you if…

  • Anyone who uses (or will use) Microsoft Office at work
  • Admin and office staff wanting to be visibly more productive
  • Jobseekers who need Office skills on their CV
  • People who are self-taught and know they have gaps
  • Anyone curious about AI in everyday work tools

It's probably not for you if…

  • You already use advanced Excel functions and Copilot daily
  • You specifically need Google Workspace training
  • You want deep coding or development skills
  • You need a self-paced course with no set schedule

Your next chapter starts a week on Monday.

Five days is all it takes. Check you qualify, then reserve your place on the next Microsoft Office & Copilot course.

Reserve my place Check if you qualify