Microsoft Office · Intermediate level

Intermediate level · Module 6 of 6 · 20 guided hours

Office Skills Portfolio Studio

Combine Word, Excel, PowerPoint, Outlook and cloud tools to complete the level project and the program portfolio under realistic deadlines.

Learning objectives

  • Analyse a document brief and plan deliverables
  • Produce integrated documents with consistent data
  • Quality-check and present a professional portfolio

Topics

  • reading a brief and planning
  • integrating Excel data into Word and PowerPoint
  • accessibility and quality checks
  • portfolio presentation

Lessons

  1. Lesson 1 From Brief to Plan

    Interpret a manager's or client's request and plan the documents, data and deadlines.

    briefdeliverablechecklistdeadline

  2. Lesson 2 Integrating Data Across Applications

    Keep numbers consistent by linking Excel data into Word reports and PowerPoint slides.

    paste linkembedsingle source of truthupdate links

  3. Lesson 3 Protecting and Distributing Final Files

    Prepare final documents for sharing outside the office: PDFs, protection, hidden data and sensible file sizes.

    document inspectorrestrict editingPDF exportfile size

  4. Lesson 4 Quality Checks and Portfolio Presentation

    Check documents for accuracy, accessibility and consistency, and present the portfolio professionally.

    accessibilityalt textconsistency checkportfolio

Practical activity

Complete and present the NGO Monthly Report Pack level project and assemble the final Professional Office Portfolio.

Expected outcomes

  • A complete, consistent document pack
  • A job-ready office skills portfolio

Assessment

Level project assessed with the level rubric; portfolio assessed against the final-project criteria.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.