Microsoft Office Essentials Course

Lesson 1 • Customising Your Workspace

Explains how to tailor the Office environment for personal productivity. Students configure views and preferences that persist across all three applications.

Lesson 2 • Getting Help and Using Templates

Introduces built-in Help, Tell Me search, and the Office template library. It equips students to self-solve problems and accelerate document creation.

Lesson 3 • Navigating the Office Interface

Covers the Ribbon, Quick Access Toolbar, and backstage view across Word, Excel, and PowerPoint. It establishes the shared interface logic used throughout the course.

Lesson 1 • Character and Paragraph Formatting

Teaches font styling, alignment, indentation, and line spacing controls. Students apply consistent formatting that meets professional document standards.

Lesson 2 • Proofing and Finalising Documents

Teaches spell check, grammar check, word count, and document accessibility review. It ensures that students submit error-free, professional-quality work.

Lesson 3 • Page Layout and Document Setup

Covers margins, orientation, page size, headers, footers, and page numbers. It prepares students to produce print-ready and submission-ready documents.

Lesson 4 • Using Styles and Themes

Introduces built-in heading styles, style sets, and document themes for uniform design. This connects to later sections on tables of contents and long-document formatting.

Lesson 1 • Working with SmartArt and Charts

Introduces SmartArt diagrams and embedded charts for visual data communication. This connects to Excel chart concepts introduced later in the course.

Lesson 2 • Long-Document Features

Covers table of contents, footnotes, endnotes, and bookmarks for navigating lengthy documents. This builds on heading styles established in the previous chapter.

Lesson 3 • Building and Formatting Tables

Covers inserting, resizing, merging, and styling tables for data presentation. This builds on paragraph formatting skills to organise information visually.

Lesson 4 • Inserting Images and Shapes

Explains how to insert, resize, crop, and position images and shapes within documents. It introduces text-wrapping options critical for professional layouts.

Lesson 1 • Entering and Editing Data

Covers data types, data entry techniques, AutoFill, and Flash Fill for efficient input. Accurate data entry is the prerequisite for all formula and analysis work.

Lesson 2 • Sorting and Filtering Data

Explains single-column and multi-column sorting plus AutoFilter for data exploration. This prepares students for structured data analysis in later Excel chapters.

Lesson 3 • Formatting Cells and Worksheets

Teaches number formats, cell styles, borders, shading, and column width adjustment. Formatted worksheets communicate data clearly and support professional presentation.

Lesson 4 • Understanding the Excel Workspace

Introduces workbooks, worksheets, cells, rows, and columns as the structural units of Excel. This establishes spatial awareness needed for all subsequent Excel work.

Lesson 1 • Building Formulas from Scratch

Teaches formula syntax, arithmetic operators, and cell references for basic calculations. This establishes the logic framework required for all function-based work.

Lesson 2 • Essential Math and Statistical Functions

Covers SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA for everyday data summarisation. These functions form the core toolkit for business reporting tasks.

Lesson 3 • Logical and Lookup Functions

Introduces IF, nested IF, VLOOKUP, HLOOKUP, and XLOOKUP for conditional logic and data retrieval. It enables students to build dynamic, decision-driven spreadsheets.

Lesson 4 • Text and Date Functions

Covers CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, TODAY, and DATE for data manipulation. This prepares students to clean and transform imported or inconsistent data.

Lesson 1 • Conditional Formatting for Insights

Covers highlight rules, data bars, colour scales, and icon sets to surface patterns visually. This builds on cell formatting skills to add analytical meaning to raw data.

Lesson 2 • Creating and Customising Charts

Teaches chart type selection, data range setup, axis labels, and chart formatting. Students match chart types to data stories for clear visual communication.

Lesson 3 • PivotCharts and Slicers

Covers PivotCharts linked to PivotTables and slicers for interactive dashboard filtering. It enables students to build dynamic reports for stakeholder presentations.

Lesson 4 • Data Validation and Named Ranges

Teaches input restrictions, dropdown lists, error alerts, and named ranges for controlled data entry. This reduces input errors and simplifies formula readability.

Lesson 1 • Inserting Visuals and Media

Explains inserting images, icons, shapes, SmartArt, and video clips into slides. This builds on Word visual skills while adding media elements unique to presentations.

Lesson 2 • Adding and Formatting Text

Covers text box insertion, placeholder editing, font formatting, and text alignment in slides. This reinforces Word formatting skills within the constraints of slide design.

Lesson 3 • Understanding the PowerPoint Interface

Introduces the slide panel, editing area, notes pane, and view modes specific to PowerPoint. This connects shared Office interface knowledge to presentation-specific workflows.

Lesson 4 • Applying Themes and Slide Masters

Teaches built-in themes, colour and font variants, and Slide Master editing for brand consistency. This ensures uniform design across all slides without manual repetition.

Lesson 1 • Preparing and Delivering Presentations

Covers Presenter view, speaker notes, rehearse timings, and laser pointer tools. This prepares students to deliver confidently in live and hybrid meeting environments.

Lesson 2 • Slide Transitions

Covers applying, timing, and customising slide transitions for smooth deck flow. It teaches restraint in transition use to maintain professional presentation standards.

Lesson 3 • Linking Excel Data to Slides

Explains embedding and linking Excel charts and tables into PowerPoint slides. This connects Excel analysis skills to presentation delivery for data-driven storytelling.

Lesson 4 • Object Animations

Teaches entrance, emphasis, exit, and motion path animations for individual slide objects. It enables students to control information reveal and audience focus strategically.