Complete Excel Course

Lesson 1 • Customising the Excel Environment

Adjust display settings, themes, and default options to match workflow needs. A personalised environment reduces friction in all future tasks.

Lesson 2 • Understanding the Excel Workspace

Identify ribbons, tabs, toolbars, and the formula bar. Establishes shared vocabulary used throughout the entire course.

Lesson 3 • Workbook and File Management

Create, save, and organise workbooks using multiple formats. Connects file hygiene to data integrity practices introduced later.

Lesson 4 • Navigating Cells and Ranges

Move efficiently through large datasets using keyboard shortcuts and Go To tools. Speeds up every subsequent data-entry and editing task.

Lesson 1 • Number and Date Formatting

Display values as currency, percentages, fractions, and custom date formats. Proper formatting prevents misreading of numeric data in reports.

Lesson 2 • Cell and Text Formatting

Control fonts, alignment, borders, and fill colours at the cell level. These skills underpin every visual design decision in later chapters.

Lesson 3 • Styles, Themes, and Templates

Apply cell styles and workbook themes for consistent branding. Templates reduce setup time for recurring reports built in later chapters.

Lesson 4 • Conditional Formatting Essentials

Highlight cells automatically based on rules, colour scales, and icon sets. Conditional formatting is extended with formulas in advanced chapters.

Lesson 1 • Formula Syntax and References

Understand operator precedence, cell references, and formula construction rules. Correct reference types prevent errors in all subsequent formula work.

Lesson 2 • Text Functions and Manipulation

Extract, combine, and clean text strings using built-in functions. Text functions are critical for data cleaning covered in the next chapter.

Lesson 3 • Essential Maths and Statistical Functions

Use SUM, AVERAGE, COUNT, MIN, MAX, and rounding functions on real data. These functions appear in nearly every workbook built in this course.

Lesson 4 • Date and Time Functions

Calculate durations, extract date parts, and work with time values. Date logic supports scheduling and reporting models built later.

Lesson 1 • Structuring Data as Tables

Convert ranges to Excel Tables for automatic formatting and structured references. Tables are the foundation for PivotTables and dynamic formulas ahead.

Lesson 2 • Data Cleaning Techniques

Identify and fix duplicates, inconsistent text, and formatting errors in raw data. Clean data is required before any meaningful analysis or reporting.

Lesson 3 • Data Validation and Input Controls

Restrict cell input with validation rules, drop-down lists, and error alerts. Validation prevents bad data from corrupting downstream analysis.

Lesson 4 • Importing and Connecting External Data

Bring data from CSV, text files, and web sources into Excel. External data connections feed the Power Query workflows introduced later.

Lesson 1 • Lookup Error Handling and Optimisation

Diagnose and resolve lookup errors using IFERROR, IFNA, and auditing tools. Robust error handling is essential for production-quality workbooks.

Lesson 2 • VLOOKUP and HLOOKUP Foundations

Perform vertical and horizontal lookups with exact and approximate matches. Understanding these functions clarifies why XLOOKUP improves on them.

Lesson 3 • Advanced Reference Functions

Use OFFSET, INDIRECT, and CHOOSE to build dynamic ranges and references. These functions power the named ranges and dashboards in later chapters.

Lesson 4 • INDEX and MATCH Combination

Use INDEX and MATCH together for flexible two-way lookups. This combination overcomes column-order limitations of VLOOKUP.

Lesson 1 • Summarising and Grouping Data

Apply sum, count, average, and custom calculations, then group dates and numbers. Grouping transforms raw records into meaningful time-series summaries.

Lesson 2 • Calculated Fields and Items

Create custom metrics inside PivotTables using calculated fields and items. Extends summarisation beyond source data columns.

Lesson 3 • PivotCharts and Report Design

Generate PivotCharts linked to PivotTables and format them for executive reports. Combines data summarisation with visual communication skills.

Lesson 4 • Building Your First PivotTable

Create a PivotTable from a structured table and arrange fields in rows, columns, and values. This section establishes the mental model for all PivotTable work.

Lesson 1 • Building Interactive Dashboards

Combine charts, slicers, KPI indicators, and form controls into a single dashboard sheet. Applies all visualisation skills to a complete, deliverable output.

Lesson 2 • Dynamic Charts with Named Ranges

Link charts to dynamic named ranges so visuals update automatically with new data. Dynamic charts are the core engine of automated dashboards.

Lesson 3 • Formatting and Customising Charts

Apply titles, labels, legends, colours, and axis settings for professional output. Consistent formatting aligns charts with organisational branding standards.

Lesson 4 • Advanced Chart Types

Build combo, waterfall, funnel, and sparkline charts for specialised analysis. These chart types handle business scenarios basic charts cannot represent.

Lesson 1 • Advanced Conditional Formatting with Formulas

Write formula-based conditional formatting rules for complex highlighting logic. Extends the basic conditional formatting introduced in Chapter 2.

Lesson 2 • Recording and Running Macros

Record, edit, and run macros to automate repetitive formatting and data tasks. Macro basics prepare learners for VBA scripting in the supplementary chapter.

Lesson 3 • Formula Auditing and Optimisation

Trace precedents, evaluate formulas, and optimise calculation speed in large models. Auditing skills ensure reliability of complex workbooks before distribution.

Lesson 4 • Dynamic Array Functions

Use FILTER, SORT, UNIQUE, SEQUENCE, and SPILL behaviour for modern data workflows. Dynamic arrays replace many complex legacy formulas with simpler syntax.