MS Office Course

Lesson 1 • Navigating the Office Interface

Covers the Ribbon, Quick Access Toolbar, and Backstage view across Office apps. Establishes shared UI patterns used throughout the entire course.

Lesson 2 • File Management and Cloud Storage

Teaches creating, saving, and organising files locally and in OneDrive. Connects file hygiene habits to productivity across all Office applications.

Lesson 3 • Getting Help and Using Templates

Introduces built-in Help, Tell Me search, and the Office template library. Enables self-sufficiency when encountering unfamiliar features later in the course.

Lesson 1 • Text and Paragraph Formatting

Applies fonts, sizes, colours, alignment, spacing, and indentation to text. Directly supports professional document appearance covered in later sections.

Lesson 2 • Tables and Visual Elements in Word

Inserts and formats tables, images, shapes, and SmartArt within documents. Enhances document clarity and visual communication for professional audiences.

Lesson 3 • Styles, Themes, and Consistency

Uses built-in Styles and document Themes to enforce visual consistency. Reduces manual formatting effort and prepares documents for automatic tables of contents.

Lesson 4 • Creating and Editing Documents

Covers typing, selecting, cutting, copying, and pasting text efficiently. Forms the baseline editing skill set required for all Word tasks ahead.

Lesson 1 • Mail Merge for Mass Communication

Automates personalised letters, labels, and emails using data source connections. Scales document production for HR, marketing, and administrative workflows.

Lesson 2 • References and Navigation Tools

Builds tables of contents, footnotes, endnotes, and bookmarks for long documents. Enables readers to navigate complex reports and academic-style documents efficiently.

Lesson 3 • Advanced Tables and Lists

Creates nested lists, multi-level numbering, and complex table structures. Supports structured reporting and policy document formatting requirements.

Lesson 1 • Basic Formulas and Functions

Writes SUM, AVERAGE, MIN, MAX, and COUNT formulas using cell references. Introduces formula logic that underpins all advanced Excel calculations ahead.

Lesson 2 • Excel Interface and Workbook Basics

Navigates worksheets, cells, rows, columns, and workbook structure. Establishes spatial awareness of Excel needed for all subsequent data work.

Lesson 3 • Formatting Cells and Worksheets

Applies number formats, cell styles, borders, and conditional formatting visually. Transforms raw data into readable, professional-looking spreadsheets.

Lesson 4 • Printing and Page Setup in Excel

Configures print areas, page breaks, headers, and scaling for clean output. Ensures spreadsheets print correctly for reports and stakeholder distribution.

Lesson 1 • PivotTables and PivotCharts

Summarises large datasets with PivotTables and visualises trends with PivotCharts. Delivers fast, flexible reporting without writing complex formulas.

Lesson 2 • Logical and Conditional Functions

Uses IF, AND, OR, and nested logic to automate decision-based calculations. Enables dynamic spreadsheets that respond to changing data conditions.

Lesson 3 • Sorting, Filtering, and Tables

Organises data using sort, AutoFilter, and structured Excel Tables with slicers. Accelerates data exploration and prepares datasets for PivotTable analysis.

Lesson 4 • Lookup and Reference Functions

Retrieves data across tables using VLOOKUP, HLOOKUP, INDEX, and MATCH. Supports data consolidation tasks common in reporting and reconciliation workflows.

Lesson 1 • Themes, Slide Masters, and Branding

Applies themes, customises Slide Masters, and enforces brand consistency across decks. Reduces per-slide formatting effort and ensures visual coherence.

Lesson 2 • Building a Presentation from Scratch

Creates slides, applies layouts, and organises content using the Outline view. Establishes a logical slide structure before applying visual design elements.

Lesson 3 • Visual Content: Images, Charts, and SmartArt

Inserts and formats images, charts linked to Excel, and SmartArt diagrams. Replaces text-heavy slides with visuals that improve audience comprehension.

Lesson 4 • Animations and Slide Transitions

Applies entrance, emphasis, and exit animations alongside slide transitions. Guides audience attention without distracting from the core message.

Lesson 1 • Calendar and Meeting Management

Schedules appointments, sends meeting invites, and manages recurring events. Coordinates team availability and reduces scheduling conflicts in the workplace.

Lesson 2 • Contacts and People Management

Creates, edits, and organises contacts and distribution lists in Outlook. Supports efficient communication targeting for teams and client groups.

Lesson 3 • Email Composition and Management

Composes, replies, forwards, and organises emails using folders and rules. Builds a structured inbox system that supports professional communication habits.

Lesson 4 • Signatures, Templates, and Quick Parts

Creates professional email signatures, reusable templates, and Quick Parts blocks. Saves time on repetitive communication and maintains brand consistency.

Lesson 1 • Productivity Tips and Workflow Optimisation

Applies keyboard shortcuts, custom views, and Quick Access Toolbar customisation. Maximises daily efficiency by reducing mouse dependency and repetitive actions.

Lesson 2 • Linking and Embedding Data Across Apps

Links Excel charts and tables into Word and PowerPoint with live data updates. Eliminates manual copy-paste errors in reports and presentations.

Lesson 3 • Collaboration with Microsoft 365 Tools

Uses co-authoring, comments, and version history in real-time across Office apps. Supports distributed team workflows using cloud-based collaboration features.