Basic Microsoft Office course

Lesson 1 • Overview of the Office Suite

Introduces the purpose and relationship of Word, Excel, PowerPoint, and Outlook. Establishes context for why each application is used in professional settings.

Lesson 2 • Customising Your Work Environment

Adjusts display settings, themes, and accessibility options to suit individual needs. A personalised environment improves efficiency throughout the course.

Lesson 3 • Managing Files and Folders

Teaches creating, saving, and organising Office files locally and in the cloud. Proper file management prevents data loss and supports collaboration.

Lesson 1 • Printing and Sharing Documents

Prepares documents for print and digital distribution using export and share options. Learners finalise professional-quality output ready for real-world use.

Lesson 2 • Formatting Characters and Paragraphs

Applies font styles, sizes, colours, alignment, and spacing to text. Consistent formatting gives documents a polished, professional appearance.

Lesson 3 • Working with Page Layout

Configures margins, orientation, page size, and section breaks. Layout decisions directly affect how documents print and are shared.

Lesson 4 • Inserting Visual Elements

Adds images, shapes, and text boxes to enrich document content. Visual elements support communication and make documents more engaging.

Lesson 1 • Templates and Reusable Content

Saves and applies document templates to standardise recurring formats. Reusable content reduces repetitive work across the organisation.

Lesson 2 • Building Tables in Word

Creates, formats, and modifies tables to organise data within documents. Tables are essential for presenting structured information clearly.

Lesson 3 • Automatic References and Navigation

Generates tables of contents, footnotes, and cross-references automatically. These tools save time and maintain accuracy in long documents.

Lesson 1 • Understanding the Excel Workspace

Explores the grid, cells, rows, columns, and sheet tabs unique to Excel. Understanding the workspace is prerequisite to all spreadsheet work.

Lesson 2 • Writing Basic Formulas

Introduces formula syntax, arithmetic operators, and cell references. Formulas transform raw data into calculated, actionable results.

Lesson 3 • Entering and Managing Data

Covers data types, data entry shortcuts, and data validation rules. Clean, validated data is the foundation of accurate analysis.

Lesson 4 • Formatting Cells and Worksheets

Applies number formats, cell styles, borders, and conditional formatting. Proper formatting makes spreadsheets readable and professionally presentable.

Lesson 1 • Logical and Conditional Functions

Uses IF, AND, OR, and nested logic to make spreadsheets decision-aware. Conditional logic is central to automating business rules in Excel.

Lesson 2 • Lookup and Reference Functions

Retrieves data across tables using VLOOKUP, HLOOKUP, and XLOOKUP. Lookup functions eliminate manual searching and reduce data entry errors.

Lesson 3 • Text and Date Functions

Manipulates text strings and calculates date differences with built-in functions. These functions clean imported data and automate date-based reporting.

Lesson 4 • Charts and Data Visualisation

Builds column, line, pie, and bar charts to communicate data visually. Effective charts translate numbers into clear stories for any audience.

Lesson 1 • Designing Slides with Themes and Layouts

Applies themes, colour schemes, and slide layouts to create visual consistency. A coherent design establishes credibility and aids audience comprehension.

Lesson 2 • Transitions and Animations

Adds slide transitions and object animations to control presentation flow. Used purposefully, motion guides attention without distracting the audience.

Lesson 3 • Adding and Formatting Content

Inserts and formats text, images, shapes, SmartArt, and tables on slides. Rich, well-formatted content keeps audiences engaged and informed.

Lesson 4 • PowerPoint Interface and Views

Explores the slide panel, editing area, notes pane, and view modes. Familiarity with the interface accelerates all subsequent presentation work.

Lesson 1 • Contacts and Tasks

Manages contact records and personal task lists within Outlook. Integrated contacts and tasks support daily productivity without switching apps.

Lesson 2 • Composing and Managing Email

Covers writing, replying, forwarding, and organising email messages. Effective email habits reduce communication errors and inbox overload.

Lesson 3 • Calendar and Scheduling

Creates appointments, meetings, and recurring events in the Outlook calendar. Effective scheduling prevents conflicts and keeps teams aligned.

Lesson 1 • Automating Repetitive Tasks with Macros

Records and runs simple macros in Word and Excel to automate repetitive actions. Macros save significant time on high-frequency, rule-based tasks.

Lesson 2 • Using Microsoft Teams with Office

Integrates Office apps within Teams for chat-based collaboration and file sharing. Teams extends Office workflows into a unified communication hub.

Lesson 3 • Productivity Tips and Best Practices

Consolidates keyboard shortcuts, Office Search, and workflow habits for peak efficiency. These practices compound daily time savings across all Office applications.

Lesson 4 • Linking Data Across Applications

Embeds and links Excel data and charts into Word documents and PowerPoint slides. Linked objects update automatically, keeping reports and presentations current.