Excel and Advanced Excel Course

Lesson 1 • Formatting Cells and Worksheets

Applies number formats, fonts, borders, and alignment to data. Produces readable, professional-looking spreadsheets from the start.

Lesson 2 • Cell Selection and Data Entry

Introduces cell referencing, data types, and efficient entry techniques. Forms the input foundation for all formula and analysis work.

Lesson 3 • Navigating the Excel Environment

Covers the Ribbon, Quick Access Toolbar, and worksheet tabs. Establishes spatial familiarity needed for all subsequent tasks.

Lesson 4 • Creating and Managing Workbooks

Teaches file creation, saving formats, and workbook properties. Ensures students can manage files across Excel versions.

Lesson 1 • Formula Syntax and Cell References

Explains operator precedence, relative vs. absolute references, and named ranges. Prevents the most common formula errors from the outset.

Lesson 2 • Math and Statistical Functions

Covers SUM, AVERAGE, COUNT, MIN, MAX, and ROUND families. Enables quick numerical summaries across any dataset.

Lesson 3 • Text Functions for Data Cleaning

Teaches LEFT, RIGHT, MID, TRIM, CONCATENATE, and TEXT functions. Equips students to standardise and reshape raw text data.

Lesson 4 • Logical Functions and Conditionals

Builds IF, AND, OR, NOT, and nested logic structures. Allows formulas to make decisions based on data conditions.

Lesson 1 • Filtering and Advanced Filter

Teaches AutoFilter, number/text/date filter types, and Advanced Filter with criteria ranges. Enables targeted data extraction without altering source data.

Lesson 2 • Data Validation and Input Controls

Configures dropdown lists, numeric limits, and custom validation rules. Prevents entry errors before they corrupt downstream analysis.

Lesson 3 • Removing Duplicates and Data Cleanup

Uses Remove Duplicates, Find and Replace, and Go To Special for data hygiene. Produces a reliable, deduplicated dataset for analysis.

Lesson 4 • Sorting Data Effectively

Covers single-column and multi-level sorts by value, colour, and custom lists. Establishes ordered data as a prerequisite for reliable analysis.

Lesson 1 • Formatting Charts for Clarity

Applies titles, axis labels, legends, gridlines, and colour themes. Transforms default charts into polished, presentation-ready visuals.

Lesson 2 • Sparklines and Conditional Formatting Visuals

Embeds sparklines and applies icon sets, colour scales, and data bars in cells. Delivers at-a-glance insights directly within the data table.

Lesson 3 • Building and Editing Charts

Walks through chart insertion, data source editing, and series management. Gives students full control over what data appears in each chart.

Lesson 4 • Chart Types and Selection Criteria

Maps data relationships to appropriate chart types: column, bar, line, pie, and scatter. Prevents misleading visualisations through informed type selection.

Lesson 1 • XLOOKUP for Modern Lookups

Introduces XLOOKUP's return array, not-found argument, and match modes. Replaces VLOOKUP and HLOOKUP with a single, flexible function.

Lesson 2 • Error Handling in Lookup Formulas

Uses IFERROR, IFNA, and ISERROR to manage lookup failures gracefully. Produces clean outputs even when source data is incomplete.

Lesson 3 • VLOOKUP and HLOOKUP Fundamentals

Explains syntax, exact vs. approximate match, and column index logic. Provides the baseline lookup skill used in most business spreadsheets.

Lesson 4 • Conditional Lookup Functions

Applies COUNTIF, SUMIF, AVERAGEIF, and their multi-criteria variants. Aggregates data based on one or more matching conditions.

Lesson 1 • Building Your First PivotTable

Guides through source data requirements, field placement, and layout options. Establishes the core drag-and-drop workflow for all PivotTable tasks.

Lesson 2 • Grouping and Filtering PivotData

Groups dates, numbers, and text items, and applies slicers and timelines. Enables rapid interactive exploration of large datasets.

Lesson 3 • PivotCharts and Dashboard Integration

Links PivotCharts to PivotTables and connects slicers across multiple visuals. Produces interactive, single-page dashboards from pivot data.

Lesson 4 • Show Values As and Percentage Views

Applies running totals, percent of total, and rank options to value fields. Transforms raw counts into meaningful comparative metrics.

Lesson 1 • LAMBDA and Custom Functions

Defines reusable custom functions with LAMBDA and stores them as named formulas. Eliminates repetitive formula duplication across large workbooks.

Lesson 2 • Text and Lookup Array Combinations

Combines TEXTSPLIT, TEXTBEFORE, TEXTAFTER, and VSTACK with lookup arrays. Handles complex text parsing and multi-table stacking in one formula.

Lesson 3 • Array Formula Techniques

Builds Ctrl+Shift+Enter arrays and implicit intersection logic for multi-cell calculations. Enables formulas to process entire ranges in a single expression.

Lesson 4 • Dynamic Array Functions

Introduces FILTER, SORT, SORTBY, UNIQUE, and SEQUENCE as spill-range functions. Replaces manual list management with self-updating formula outputs.

Lesson 1 • Forecasting and Trend Analysis

Applies the Forecast Sheet tool, trendlines, and moving averages to time-series data. Produces forward-looking projections with confidence intervals.

Lesson 2 • Solver for Optimisation Problems

Configures Solver with objective cells, variable cells, and constraints. Finds optimal solutions for resource allocation and cost minimisation problems.

Lesson 3 • Recording and Running Macros

Records, stores, and runs macros using the Macro Recorder and the View tab. Automates repetitive formatting and data tasks without writing code.

Lesson 4 • What-If Analysis Tools

Uses Goal Seek, Data Tables, and Scenario Manager to model variable outcomes. Supports financial and operational planning with structured sensitivity analysis.