Advanced Excel and Word Course

Lesson 1 • Navigating the Word Interface

Explore Word's ribbon, document views, and navigation pane. This provides the baseline orientation required before formatting or editing work begins.

Lesson 2 • Customizing the Workspace

Tailor ribbons, toolbars, and default settings for personal efficiency. This reduces repetitive setup time throughout the course and on the job.

Lesson 3 • Navigating the Excel Interface

Master the ribbon, Quick Access Toolbar, and worksheet navigation. This establishes the spatial awareness needed for all subsequent Excel tasks.

Lesson 1 • Formatting Cells and Ranges

Apply number formats, borders, fills, and alignment to structure data visually. Proper formatting improves readability and supports conditional rules.

Lesson 2 • Managing Rows, Columns, and Sheets

Insert, delete, hide, and resize rows, columns, and worksheets efficiently. Sheet organisation skills scale directly to multi-sheet workbook design.

Lesson 3 • Cell Referencing and Range Selection

Distinguish absolute, relative, and mixed references and select named ranges. Reference types directly control formula behaviour across the workbook.

Lesson 1 • Lookup and Reference Functions

Retrieve data with VLOOKUP, HLOOKUP, INDEX, and MATCH. These functions connect separate data tables and eliminate manual cross-referencing.

Lesson 2 • Building Basic Formulas

Construct arithmetic formulas using operators and cell references. Understanding operator precedence prevents calculation errors in complex expressions.

Lesson 3 • Text and Date Functions

Manipulate strings and calculate date intervals with built-in functions. Text and date functions clean imported data and automate time-based reporting.

Lesson 4 • Logical and Conditional Functions

Apply IF, AND, OR, and nested logic to drive conditional outputs. Logical functions form the decision layer of most business spreadsheet models.

Lesson 1 • Styles and Themes

Create, modify, and apply heading and body styles to enforce document consistency. Styles also power automatic tables of contents and navigation.

Lesson 2 • Headers, Footers, and Page Numbers

Insert dynamic headers, footers, and page numbering with section-level control. These elements meet professional and organisational document standards.

Lesson 3 • Page Layout and Section Breaks

Set margins, orientation, columns, and section breaks for complex layouts. Section breaks enable independent formatting within a single document.

Lesson 4 • Tables in Word Documents

Build, format, and sort tables to present structured data within documents. Word tables complement Excel data when embedded in reports and proposals.

Lesson 1 • Chart Creation and Formatting

Select appropriate chart types and format axes, labels, and series for clarity. Well-designed charts communicate findings faster than tables alone.

Lesson 2 • Slicers, Timelines, and PivotCharts

Add slicers and timelines to enable interactive filtering of PivotTables. PivotCharts extend analysis into dynamic visual dashboards.

Lesson 3 • Conditional Formatting

Highlight cells with rules, colour scales, data bars, and icon sets. Visual cues accelerate pattern recognition without altering underlying data.

Lesson 4 • Sorting and Filtering Data

Apply single and multi-level sorts and AutoFilter to isolate relevant records. Filtering skills are a prerequisite to meaningful PivotTable and chart work.

Lesson 1 • Automatic Tables of Contents and Indexes

Generate and update tables of contents and indexes from heading styles and marked entries. Automation eliminates manual page-number tracking in long documents.

Lesson 2 • Footnotes, Endnotes, and Citations

Insert footnotes, endnotes, and formatted citations to meet academic and professional standards. Reference tools maintain credibility and document traceability.

Lesson 3 • Mail Merge for Documents and Labels

Connect a data source to a Word template to produce personalised letters, emails, and labels. Mail merge scales one-to-one communication to thousands of recipients.

Lesson 4 • Track Changes and Document Review

Use tracked changes, comments, and comparison tools to manage collaborative editing. Review features maintain an auditable record of document revisions.

Lesson 1 • Array Formulas and Dynamic Arrays

Write legacy array formulas and leverage dynamic array functions like FILTER and SORT. Dynamic arrays spill results automatically, replacing many helper-column workarounds.

Lesson 2 • Power Query for Data Transformation

Import, clean, and reshape data from multiple sources using Power Query. Repeatable query steps replace manual data preparation and reduce errors.

Lesson 3 • What-If Analysis Tools

Use Goal Seek, Scenario Manager, and Data Tables to model variable outcomes. What-if tools support financial planning, budgeting, and risk assessment.

Lesson 4 • Advanced Statistical and Math Functions

Use SUMIFS, AVERAGEIFS, COUNTIFS, and statistical functions for multi-criteria analysis. These functions power KPI dashboards and operational KPI performance reports.

Lesson 1 • Building Interactive Dashboards

Combine PivotTables, charts, slicers, and form controls into a single dashboard sheet. Dashboards consolidate KPIs into one view for executive reporting.

Lesson 2 • Embedding Excel Data in Word

Paste, link, and embed Excel tables and charts into Word documents. Linked objects update automatically when source data changes, keeping reports current.

Lesson 3 • Excel Macros and VBA Basics

Record macros and write basic VBA procedures to automate repetitive Excel tasks. VBA skills extend Excel's built-in capabilities for custom business solutions.