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
-
Lesson 1 From Brief to Plan
Interpret a manager's or client's request and plan the documents, data and deadlines.
briefdeliverablechecklistdeadline
-
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
-
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
-
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.