Microsoft Office and Excel Course

Lesson 1 • Customising the Office Environment

Adjust display settings, themes, and accessibility options to optimise your workspace. A personalised environment improves efficiency across all Office tasks.

Lesson 2 • The Office Interface and Ribbon

Explore the shared layout of Office apps, including the Ribbon, Quick Access Toolbar, and status bar. This foundation applies to every application covered in the course.

Lesson 3 • File Management and Cloud Storage

Create, save, and organise files locally and in OneDrive. Proper file management prevents data loss and enables collaboration throughout the course.

Lesson 1 • Creating and Editing Text

Enter, select, cut, copy, paste, and find-and-replace text efficiently. These editing skills underpin every document task in this chapter.

Lesson 2 • Styles, Headings, and Navigation

Use built-in styles and heading levels to create structured, navigable documents. Styles also enable automatic table-of-contents generation.

Lesson 3 • Tables, Lists, and Visual Elements

Insert and format tables, bulleted lists, images, and shapes to enhance document clarity. Visual elements make complex information easier to scan.

Lesson 4 • Reviewing and Finalising Documents

Use Track Changes, comments, and document properties to review and finalise work. These tools support collaborative editing and quality control.

Lesson 1 • Building a Slide Deck from Scratch

Add, duplicate, reorder, and delete slides while choosing appropriate layouts. A well-structured deck is the foundation of every effective presentation.

Lesson 2 • Design Themes and Visual Consistency

Apply themes, colour palettes, and fonts to achieve a unified visual identity. Consistent design reinforces credibility and audience focus.

Lesson 3 • Animations and Slide Transitions

Add entrance, emphasis, and exit animations alongside slide transitions to guide audience attention. Purposeful animation enhances rather than distracts.

Lesson 4 • Presenting and Sharing Slides

Use Presenter View, rehearse timings, and export slides for sharing. These skills ensure smooth delivery and broad accessibility of your content.

Lesson 1 • The Excel Workspace

Identify cells, rows, columns, sheets, and the formula bar within the Excel interface. Confident navigation is prerequisite to all data work.

Lesson 2 • Printing and Page Layout in Excel

Set print areas, headers, footers, and page breaks to produce clean printed output. Print-ready spreadsheets are essential for reports and presentations.

Lesson 3 • Managing Workbooks and Worksheets

Insert, rename, move, copy, and protect worksheets within a workbook. Organised workbooks reduce errors and improve team collaboration.

Lesson 4 • Entering and Editing Data

Input text, numbers, dates, and times correctly and edit cell contents efficiently. Accurate data entry prevents errors that compound in formulas.

Lesson 1 • Logical Functions and Conditionals

Apply IF, AND, OR, and nested logic to make formulas respond to data conditions. Logical functions transform static sheets into dynamic decision tools.

Lesson 2 • Formula Syntax and Cell References

Understand operator precedence, relative, absolute, and mixed references. Correct referencing is the single most critical skill for building reliable formulas.

Lesson 3 • Date and Time Functions

Calculate durations, extract date parts, and automate date logic with TODAY, NOW, DATEDIF, and EDATE. Date functions power scheduling and reporting workflows.

Lesson 4 • Text Functions and Data Cleaning

Use TRIM, CONCATENATE, LEFT, RIGHT, MID, and TEXT to manipulate string data. Clean, consistent text is essential before analysis or reporting.

Lesson 1 • Sorting and Filtering Data

Sort data by single or multiple columns and apply AutoFilter to isolate subsets. These tools are the first step in any data analysis workflow.

Lesson 2 • Lookup and Reference Functions

Use VLOOKUP, HLOOKUP, INDEX, and MATCH to retrieve data across sheets and tables. Lookup functions eliminate manual searching and reduce errors.

Lesson 3 • Conditional Formatting

Highlight cells based on rules, data bars, colour scales, and icon sets to surface patterns visually. Conditional formatting turns numbers into instant visual signals.

Lesson 4 • Data Validation and Error Prevention

Restrict cell input using drop-down lists, numeric ranges, and custom formulas. Validation enforces data integrity before errors enter the dataset.

Lesson 1 • Building a Basic Dashboard

Combine charts, KPI metrics, and slicers on a single sheet to create an interactive summary view. Dashboards consolidate insights for decision-makers.

Lesson 2 • Formatting Charts for Clarity

Customise titles, axes, legends, gridlines, and colours to produce publication-ready visuals. Formatting removes ambiguity and directs audience attention.

Lesson 3 • Creating and Editing Charts

Insert charts from selected data, switch rows and columns, and edit data sources. Accurate source data ensures charts reflect the intended message.

Lesson 4 • Choosing the Right Chart Type

Match data relationships to appropriate chart types: column, bar, line, pie, and scatter. Chart selection is the most impactful visualisation decision.

Lesson 1 • Calculated Fields and Items

Add custom calculations inside PivotTables using calculated fields and items. These extend PivotTable analysis without modifying source data.

Lesson 2 • Filtering PivotTables with Slicers

Insert slicers and timelines to filter PivotTables interactively without using dropdown menus. Slicers make reports accessible to non-technical stakeholders.

Lesson 3 • PivotCharts and Visual Reporting

Generate PivotCharts linked to PivotTables for dynamic visual reports. PivotCharts update automatically when filters or data change.

Lesson 4 • Building PivotTables from Scratch

Create PivotTables from structured data, arrange fields, and apply value summarisations. PivotTables are the fastest way to summarise thousands of rows.