Microsoft Office

Level 2 of 2

Intermediate Level

Prerequisites

Microsoft Office Beginner level or equivalent skills: file management, basic Word formatting, simple Excel formulas and basic PowerPoint. Learners who need advanced spreadsheet analysis (lookups, PivotTables, Power Query) should continue with the Advanced Excel program afterwards.

Duration

8 weeks · 100 guided hours · 6 modules. Taught live by an instructor — online or in person.

By the end of this level you can

  • Produce long, structured documents with styles, an automatic table of contents and mail merge
  • Manage everyday office data in Excel with functions, tables, sorting, filtering and charts
  • Design and deliver persuasive presentations that combine Word, Excel and PowerPoint content
  • Communicate and schedule professionally with Outlook email and calendar
  • Collaborate on shared documents with OneDrive, Teams, comments and version history

Modules

  1. 1Module 1 · 18 h · 3 lessonsLong Documents, Templates and Mail Merge
  2. 2Module 2 · 20 h · 4 lessonsExcel for Everyday Office Data
  3. 3Module 3 · 14 h · 3 lessonsPresentations that Persuade
  4. 4Module 4 · 14 h · 3 lessonsEmail, Calendar and Professional Communication with Outlook
  5. 5Module 5 · 14 h · 3 lessonsCollaboration and Cloud Work with OneDrive and Teams
  6. 6Module 6 · 20 h · 4 lessonsOffice Skills Portfolio Studio

Intermediate level project

NGO Monthly Report Pack

For a fictional NGO programme, produce the complete monthly reporting pack a programme officer would send to a manager and partners.

Deliverables

  • A 6–10 page Word report with styles, automatic table of contents, captions and an embedded Excel chart
  • The Excel workbook holding the monthly data, with functions, a formatted table and charts
  • An 8-slide briefing presentation with speaker notes
  • Mail-merged invitation letters for a review meeting, plus the meeting invitation sent from Outlook
  • A shared OneDrive folder with correct permissions and a cover email linking the files

Assessed on

  • Professional, consistent formatting across all documents
  • Accurate figures that match between workbook, report and slides
  • Correct use of styles, table of contents, mail merge and sharing permissions
  • Clear, concise and appropriate written communication

All levels are taught live by an instructor — online or in person — see registration options.