Microsoft Office Suite (Word, Excel, Windows) Course

Lesson 1 • Keyboard Shortcuts and Productivity Habits

Presents essential Windows shortcuts that accelerate daily tasks. These habits carry over directly into Word and Excel workflows.

Lesson 2 • Windows Desktop and Interface Basics

Covers the taskbar, Start menu, system tray, and desktop icons. Establishes the visual framework students use throughout the course.

Lesson 3 • File Explorer and Folder Management

Teaches creating, renaming, moving, and deleting files and folders. Directly supports organised storage of all Office documents.

Lesson 1 • Character and Paragraph Formatting

Teaches font, size, colour, alignment, and spacing controls. Students apply consistent formatting that meets professional document standards.

Lesson 2 • Entering and Editing Text

Covers typing, selecting, deleting, and rearranging text. Builds the editing muscle memory required for all subsequent Word tasks.

Lesson 3 • Inserting Basic Document Elements

Introduces headers, footers, page numbers, and simple tables. These elements appear in nearly every professional document students will create.

Lesson 1 • Tables: Advanced Formatting and Data

Covers merging cells, table styles, sorting, and formula use in tables. Students build structured data displays without switching to Excel.

Lesson 2 • Templates and Document Reuse

Teaches saving and applying Word templates for letters, reports, and forms. Reusable templates reduce formatting time across recurring document types.

Lesson 3 • Long Document Navigation Tools

Introduces the Navigation Pane, table of contents, and cross-references. These tools are essential for reports, manuals, and multi-page documents.

Lesson 4 • Reviewing and Collaborating in Word

Covers Track Changes, comments, and document comparison. Students prepare documents for team review and incorporate feedback efficiently.

Lesson 1 • Basic Formulas and Functions

Introduces arithmetic operators, SUM, AVERAGE, MIN, MAX, and COUNT. These functions underpin every analytical task in subsequent chapters.

Lesson 2 • Cell Formatting and Presentation

Teaches number formats, cell styles, borders, and conditional formatting basics. Well-formatted cells make data readable and professionally presentable.

Lesson 3 • Excel Interface and Workbook Setup

Introduces the ribbon, Name Box, formula bar, and sheet tabs. Students navigate large workbooks and configure basic workbook properties.

Lesson 1 • Sorting, Filtering, and Tables

Introduces multi-level sorting, AutoFilter, and Excel Tables. Structured tables automate formula expansion and improve data integrity.

Lesson 2 • Logical and Text Functions

Covers IF, AND, OR, CONCATENATE, LEFT, RIGHT, and MID. These functions transform raw data into meaningful, decision-ready information.

Lesson 3 • Absolute and Relative Cell References

Explains the difference between relative, absolute, and mixed references. Mastering references is required before building multi-sheet formulas.

Lesson 4 • Date and Time Functions

Covers TODAY, NOW, DATEDIF, EDATE, and NETWORKDAYS for time-based calculations. Date functions support scheduling, aging, and deadline tracking.

Lesson 1 • Chart Fundamentals and Chart Types

Explains when to use column, bar, line, pie, and scatter charts. Choosing the right chart type is the first step in effective data communication.

Lesson 2 • Chart Formatting and Design

Covers chart titles, axis labels, legends, colours, and chart styles. Polished formatting ensures charts meet organisational presentation standards.

Lesson 3 • PivotTables and PivotCharts

Teaches building, filtering, and grouping PivotTables and linked PivotCharts. PivotTables are the most powerful built-in tool for summarising large datasets.

Lesson 1 • Power Query for Data Import

Covers connecting to external data sources, transforming data, and loading results. Power Query eliminates manual data-cleaning steps in recurring reports.

Lesson 2 • Macro Recording and Basic Automation

Introduces the macro recorder, running macros, and assigning them to buttons. Students automate repetitive formatting and data-entry tasks without coding.

Lesson 3 • Advanced Functions and Array Formulas

Introduces SUMIF, COUNTIF, AVERAGEIF, and dynamic array functions. These formulas handle conditional aggregation across large, complex datasets.

Lesson 4 • What-If Analysis Tools

Covers Goal Seek, Scenario Manager, and Data Tables for modelling outcomes. These tools support budgeting, forecasting, and decision analysis tasks.

Lesson 1 • Accessibility and Document Standards

Covers the Accessibility Checker, alt text, and readable formatting in Word and Excel. Accessible documents meet professional and organisational compliance requirements.

Lesson 2 • Print Settings and PDF Export

Explains print area, page breaks, scaling, and PDF export in both applications. Correct print settings ensure documents look professional on paper and screen.

Lesson 3 • Mail Merge for Mass Communication

Covers the full mail merge workflow using Word and an Excel data source. Students produce personalised letters, labels, and emails at scale.

Lesson 4 • File Management and Version Control

Introduces AutoSave, version history, and OneDrive integration for both apps. Students protect their work and recover previous versions when errors occur.