Excel training

Lesson 1 • Worksheet Structure and Cell Basics

Explains rows, columns, cells, and ranges as the foundational grid. Prepares students for data entry and formula construction.

Lesson 2 • Creating and Managing Workbooks

Teaches file creation, saving formats, and workbook properties. Establishes file hygiene habits critical for professional use.

Lesson 3 • Navigating the Excel Interface

Covers the Ribbon, Quick Access Toolbar, and worksheet tabs. Builds the spatial awareness needed for all subsequent Excel tasks.

Lesson 4 • Data Entry and Editing Techniques

Covers typing, editing, AutoFill, and Flash Fill for efficient input. Reduces manual errors and speeds up data population.

Lesson 1 • Formula Fundamentals

Introduces formula syntax, operators, and order of operations. Establishes the logic framework for all function-based work ahead.

Lesson 2 • Math and Statistical Functions

Covers SUM, AVERAGE, MIN, MAX, COUNT, and ROUND for numeric analysis. Provides the quantitative toolkit used in most business spreadsheets.

Lesson 3 • Absolute and Relative Cell References

Distinguishes relative, absolute, and mixed references using the dollar sign. Enables accurate formula copying across large datasets.

Lesson 4 • Text Functions for Data Cleaning

Teaches LEFT, RIGHT, MID, TRIM, CONCATENATE, and TEXT for string manipulation. Prepares data for analysis by standardising inconsistent entries.

Lesson 1 • XLOOKUP and Modern Lookup Tools

Introduces XLOOKUP as the modern replacement for legacy lookup functions. Simplifies syntax and adds return-array and not-found arguments.

Lesson 2 • AND, OR, and NOT Operators

Combines multiple conditions using AND, OR, and NOT within IF formulas. Expands conditional logic to handle complex business rules.

Lesson 3 • IF and Nested Logic

Constructs IF statements and nested IF chains for conditional outputs. Forms the decision-making backbone of dynamic spreadsheet models.

Lesson 4 • INDEX and MATCH Functions

Combines INDEX and MATCH for flexible, bidirectional lookups. Overcomes VLOOKUP column-order restrictions in complex datasets.

Lesson 1 • Excel Tables for Structured Data

Converts ranges to Excel Tables for automatic expansion and structured references. Streamlines filtering, formatting, and formula consistency.

Lesson 2 • Filtering and Advanced Filtering

Uses AutoFilter and Advanced Filter to isolate relevant records. Reduces noise in large datasets and supports targeted analysis.

Lesson 3 • Removing Duplicates and Data Cleanup

Identifies and removes duplicate records and standardises inconsistent data. Ensures dataset integrity before analysis or reporting.

Lesson 4 • Data Validation Rules

Restricts cell input using validation rules, drop-down lists, and alerts. Prevents data entry errors before they corrupt analysis.

Lesson 1 • Formula-Based Conditional Formatting

Uses custom formulas to apply formatting across entire rows or complex conditions. Extends visual logic beyond built-in rule presets.

Lesson 2 • Conditional Formatting Rules

Applies highlight rules, data bars, colour scales, and icon sets to cells. Transforms raw numbers into visually scannable information.

Lesson 3 • Formatting and Customising Charts

Modifies chart titles, axes, legends, colours, and data labels for clarity. Produces publication-ready visuals aligned with professional standards.

Lesson 4 • Creating Charts and Graphs

Builds column, bar, line, and pie charts from worksheet data. Selects appropriate chart types to match the data story being told.

Lesson 1 • Array Formulas and CTRL+SHIFT+ENTER

Constructs legacy array formulas for multi-cell calculations in older Excel versions. Bridges understanding between classic and modern dynamic array behaviour.

Lesson 2 • Error Handling and Formula Auditing

Applies IFERROR, IFNA, and auditing tools to diagnose and handle formula errors. Builds robust models that degrade gracefully under unexpected inputs.

Lesson 3 • Dynamic Array Functions

Uses FILTER, SORT, UNIQUE, and SEQUENCE to return spilling result arrays. Automates list generation and data extraction without helper columns.

Lesson 4 • LAMBDA and Custom Functions

Defines reusable custom functions using LAMBDA without VBA. Encapsulates complex logic into named, callable formulas for team-wide reuse.

Lesson 1 • Building Your First PivotTable

Creates a PivotTable from a structured dataset and arranges fields. Establishes the drag-and-drop workflow central to all pivot analysis.

Lesson 2 • Summarising and Grouping Data

Applies SUM, COUNT, AVERAGE, and grouping by date or number ranges. Enables multi-dimensional summaries from a single data source.

Lesson 3 • Filtering PivotTables with Slicers

Adds Slicers and Timelines for interactive, visual PivotTable filtering. Transforms static summaries into user-friendly interactive reports.

Lesson 4 • PivotCharts and Dashboard Integration

Generates PivotCharts linked to PivotTables for dynamic visual reporting. Combines charts and Slicers into cohesive, interactive dashboards.

Lesson 1 • Productivity Shortcuts and Custom Views

Applies keyboard shortcuts, custom views, and workspace settings to accelerate daily tasks. Reduces mouse dependency and speeds up common operations.

Lesson 2 • Recording and Running Macros

Records macro actions and assigns them to buttons for one-click execution. Automates repetitive formatting and data tasks without writing code.

Lesson 3 • Named Ranges and Dynamic Names

Creates named ranges and dynamic named formulas for readable, maintainable models. Replaces cryptic cell addresses with meaningful labels throughout workbooks.

Lesson 4 • Introduction to VBA Basics

Opens the VBA editor and reads recorded macro code to understand structure. Provides a foundation for editing and extending recorded macros.