Office Productivity Mastery

This module develops professional fluency in the three cornerstones of office productivity: Microsoft Word, Microsoft Excel and Microsoft PowerPoint, with equivalent coverage of Google Docs, Sheets and Slides. Learners move beyond basic use into styles, templates, mail merges, pivot tables, data validation, slide masters and lightweight automation. Emphasis is placed on reproducible workflows, keyboard efficiency, and documents that remain clean, accessible and version-safe. By the end, learners can produce boardroom-quality deliverables in a fraction of the time an untrained user would need.

Learning Outcomes

Apply built-in styles, headings and a table of contents to produce consistently formatted long-form documents.

Perform mail merges and use track changes with multiple reviewers in Microsoft Word.

Build spreadsheets that use VLOOKUP, XLOOKUP, pivot tables, conditional formatting and data validation accurately.

Design accessible presentations using slide masters, speaker notes and presenter view.

Use keyboard shortcuts and templates to accelerate repeated office tasks measurably.

Record and edit simple macros to automate repetitive formatting and data operations.

Choose appropriate file formats and sharing settings for business documents.

Troubleshoot common formatting, formula and compatibility issues in office documents.

Topics Covered

Word styles, headings and tables of contents

Templates, section breaks and page layout

Mail merge for letters, labels and emails

Track changes, comments and compare documents

Excel references, named ranges and formulas

VLOOKUP, XLOOKUP, INDEX/MATCH and lookup patterns

Pivot tables, slicers and PivotCharts

Conditional formatting and data validation

Charts, sparklines and dashboards

PowerPoint slide master and layouts

Animations, transitions and presenter view

Keyboard shortcuts across Office and Google Workspace

Recording and editing simple macros (VBA / Apps Script)

File formats, PDF export and accessibility checks

Collaboration, co-authoring and version history

Skills Developed

Producing professionally formatted long documents Building reliable spreadsheet models and dashboards Designing clear and accessible slide decks Automating repetitive tasks with templates and macros Using shortcuts for keyboard-first productivity Managing document versions and collaborator feedback Choosing correct file formats for a given audience Diagnosing formula and formatting problems

Suggested Resources

{'title': 'Microsoft 365 Training', 'author': 'Microsoft Learn', 'source': 'support.microsoft.com/training'}

{'title': 'Excel Exposure Course', 'author': 'Ben Currier', 'source': 'excelexposure.com'}

{'title': 'ExcelJet Shortcut and Formula Reference', 'author': 'Dave Bruns', 'source': 'exceljet.net'}

{'title': 'Google Workspace Learning Center', 'author': 'Google', 'source': 'support.google.com/a/users'}

{'title': "The Non-Designer's Design Book", 'author': 'Robin Williams', 'source': 'Peachpit Press'}

{'title': 'Slide:ology', 'author': 'Nancy Duarte', 'source': "O'Reilly Media"}

{'title': 'ICDL Advanced Modules (Word, Spreadsheets, Presentation)', 'author': 'ICDL Foundation', 'source': 'icdl.org'}

Assessment

Learners complete three graded practical artefacts (a long Word report, an Excel analysis workbook and a PowerPoint deck) alongside a timed MCQ test and a short reflective journal on time saved.

word_report20%

excel_workbook20%

powerpoint_deck20%

final_mcq_test20%

reflective_journal20%

Practice bank: 200 MCQs · Timed mock & self-paced modes

Start Practice →