Microsoft Office Course

Lesson 1 • Navigating the Office Interface

Covers the Ribbon, Quick Access Toolbar, and backstage view common to all apps. Builds muscle memory for efficient navigation before application-specific work begins.

Lesson 2 • Customizing Your Office Environment

Covers account settings, themes, and accessibility options across the suite. Prepares a personalised, accessible workspace that supports sustained productivity.

Lesson 3 • File Management and Cloud Storage

Teaches creating, saving, and organising files locally and in OneDrive. Ensures students can manage versions and share documents safely from day one.

Lesson 1 • Creating and Editing Documents

Covers typing, selecting, cutting, copying, and pasting text efficiently. Establishes core editing habits that underpin all subsequent Word work.

Lesson 2 • Styles, Themes, and Templates

Introduces built-in styles, document themes, and reusable templates for consistency. Reduces formatting time and enforces brand or organisational standards.

Lesson 3 • Text and Paragraph Formatting

Teaches font styling, paragraph alignment, indentation, and spacing controls. Connects visual consistency to professional document standards.

Lesson 4 • Page Layout and Document Structure

Covers margins, orientation, columns, headers, footers, and page breaks. Ensures documents meet print and digital layout requirements.

Lesson 1 • Mail Merge and Bulk Documents

Covers mail merge for letters, labels, and envelopes using data sources. Enables high-volume personalised document production efficiently.

Lesson 2 • References and Automated Indexes

Teaches table of contents, footnotes, endnotes, citations, and indexes. Automates reference management for academic and professional reports.

Lesson 3 • Macros and Automation in Word

Introduces recording and running macros to automate repetitive Word tasks. Connects automation concepts that will be expanded in later Excel chapters.

Lesson 4 • Long Document Navigation Tools

Covers the Navigation Pane, bookmarks, cross-references, and hyperlinks. Enables efficient movement and linking within large documents.

Lesson 1 • Excel Interface and Workbook Basics

Covers the Excel grid, workbook structure, and worksheet navigation. Establishes spatial understanding of rows, columns, and cell references.

Lesson 2 • Entering and Formatting Data

Teaches data types, number formats, cell alignment, and conditional formatting basics. Ensures data is entered consistently and displayed meaningfully.

Lesson 3 • Core Formulas and Functions

Introduces formula syntax, arithmetic operators, and essential functions. Builds the calculation foundation required for all advanced Excel work.

Lesson 4 • Sorting, Filtering, and Tables

Teaches converting ranges to Excel Tables, sorting, and filtering data sets. Prepares structured data for analysis in subsequent chapters.

Lesson 1 • PivotTables and PivotCharts

Teaches building, filtering, and grouping PivotTables to summarise large data sets. Connects raw data to executive-level summary reporting.

Lesson 2 • What-If Analysis and Forecasting

Introduces Goal Seek, Scenario Manager, Data Tables, and Forecast sheets. Enables forward-looking financial and operational modelling.

Lesson 3 • Data Import, Power Query, and Automation

Teaches importing external data, transforming it with Power Query, and recording macros. Bridges manual analysis with automated, repeatable workflows.

Lesson 4 • Advanced Functions and Array Formulas

Covers SUMIF, COUNTIF, AVERAGEIF, INDEX-MATCH, and dynamic array functions. Extends calculation power for complex, multi-condition analysis.

Lesson 1 • Animations, Transitions, and Slide Show

Covers entrance animations, slide transitions, and slide show delivery settings. Prepares students to present confidently with controlled, purposeful motion.

Lesson 2 • Charts, Tables, and Embedded Data

Teaches inserting charts, tables, and linked Excel data into slides. Connects data analysis outputs to presentation-ready visual formats.

Lesson 3 • Text, Shapes, and Visual Content

Teaches adding and formatting text boxes, shapes, icons, and images on slides. Builds visual literacy for creating clear, uncluttered slide content.

Lesson 4 • Slide Design with Themes and Masters

Covers applying themes, editing Slide Masters, and creating consistent layouts. Ensures brand-aligned, professional visual consistency across all slides.

Lesson 1 • Advanced Teams and Collaboration Features

Covers Teams apps, tabs, meeting controls, and breakout rooms. Extends Teams use to structured, facilitated collaborative sessions.

Lesson 2 • Outlook Email Management

Covers composing, formatting, and organising email with folders, rules, and flags. Builds habits for inbox control and professional communication.

Lesson 3 • Calendar, Meetings, and Scheduling

Teaches creating appointments, scheduling meetings, and managing shared calendars. Enables coordinated scheduling across teams and time zones.

Lesson 4 • Microsoft Teams Fundamentals

Introduces Teams channels, chats, file sharing, and meeting features. Connects Outlook scheduling with real-time collaboration in Teams.

Lesson 1 • Capstone: Integrated Office Project

Applies all core skills in a simulated business project spanning Word, Excel, PowerPoint, and Outlook. Validates readiness for professional Office use through end-to-end task completion.

Lesson 2 • Power Automate for Office Workflows

Covers building no-code automated flows that connect Office apps and services. Reduces manual effort through trigger-based automation across the suite.

Lesson 3 • Linking Data Across Office Applications

Covers embedding and linking Excel data in Word and PowerPoint for live updates. Eliminates manual re-entry and ensures consistency across documents.

Lesson 4 • OneDrive, SharePoint, and Co-Authoring

Teaches real-time co-authoring, SharePoint document libraries, and version control. Enables seamless team collaboration on shared Office files.