Basic to Advanced Excel Course

Lesson 1 • Creating and Managing Workbooks

Teaches file creation, saving formats, and workbook properties. Establishes safe file-handling habits used throughout the course.

Lesson 2 • Entering and Editing Data

Covers text, number, and date entry plus editing shortcuts. Accurate data entry is the foundation of reliable spreadsheet output.

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 • Working with Cells and Ranges

Introduces cell addressing, selection techniques, and range naming. These skills underpin every formula and data operation ahead.

Lesson 1 • Cell Formatting Essentials

Covers fonts, borders, fill colours, and alignment options. These tools transform raw data into professional-looking reports.

Lesson 2 • Conditional Formatting

Applies rules-based formatting to highlight trends and outliers. Connects visual cues directly to data values for faster analysis.

Lesson 3 • Row, Column, and Sheet Management

Controls row height, column width, and sheet organisation. Proper structure makes large workbooks easier to navigate and maintain.

Lesson 4 • Number and Date Formats

Teaches built-in and custom number formats for currency, dates, and percentages. Correct formatting prevents misreading of numeric data.

Lesson 1 • Logical and Conditional Functions

Teaches IF, AND, OR, NOT, and nested logic structures. Conditional logic enables dynamic, decision-driven spreadsheet behaviour.

Lesson 2 • Formula Syntax and Operators

Explains operator precedence, parentheses, and formula construction rules. A solid syntax foundation prevents calculation errors in all later work.

Lesson 3 • Text Functions

Manipulates strings with CONCATENATE, LEFT, RIGHT, MID, and TRIM. Text functions clean and restructure data imported from external sources.

Lesson 4 • Date and Time Functions

Calculates durations, deadlines, and schedules using TODAY, NOW, and DATEDIF. Date functions are critical for project tracking and reporting.

Lesson 1 • Sorting and Filtering Data

Applies single and multi-level sorts and AutoFilter to datasets. Sorting and filtering are the first steps in any data exploration workflow.

Lesson 2 • Tables and Structured References

Converts ranges to Excel Tables for automatic expansion and structured references. Tables simplify formula writing and improve data scalability.

Lesson 3 • Importing and Connecting External Data

Brings data from CSV, text, and web sources into Excel. External connections keep reports current without manual copy-paste updates.

Lesson 4 • Removing Duplicates and Cleaning Data

Uses Remove Duplicates, TRIM, and text tools to clean raw data. Clean data is a prerequisite for accurate formulas and pivot tables.

Lesson 1 • XLOOKUP and XMATCH

Introduces the modern XLOOKUP and XMATCH functions with built-in error handling. These replace legacy lookups with simpler, more powerful syntax.

Lesson 2 • INDEX and MATCH

Combines INDEX and MATCH for flexible two-way lookups. This pair overcomes VLOOKUP's column-order and left-lookup limitations.

Lesson 3 • VLOOKUP and HLOOKUP

Teaches vertical and horizontal lookup syntax, match types, and common errors. These functions are the most widely used data-retrieval tools in business.

Lesson 4 • Conditional Lookup Techniques

Applies SUMIF, COUNTIF, and AVERAGEIF for criteria-based aggregation. Conditional lookups power summary dashboards and exception reports.

Lesson 1 • Advanced Chart Types

Builds combo, waterfall, funnel, and histogram charts for complex data. Advanced chart types reveal patterns that standard charts cannot show.

Lesson 2 • Formatting and Customising Charts

Applies titles, labels, legends, and colour schemes to charts. Proper formatting ensures charts are self-explanatory and visually consistent.

Lesson 3 • Chart Fundamentals and Types

Introduces chart creation, data selection, and the most common chart types. Choosing the right chart type is the first step in effective visualisation.

Lesson 4 • Sparklines and In-Cell Visuals

Embeds sparklines and data bars directly inside cells for compact trend views. In-cell visuals add context without consuming extra worksheet space.

Lesson 1 • Slicers and Timelines

Adds slicers and timelines for visual, click-based PivotTable filtering. These controls make reports interactive for non-technical stakeholders.

Lesson 2 • Building Your First PivotTable

Creates a PivotTable from a structured dataset and explores the field list. Understanding the layout areas is essential before applying any analysis.

Lesson 3 • Grouping and Summarising Data

Groups dates, numbers, and text fields to create meaningful summaries. Grouping transforms raw records into actionable business insights.

Lesson 4 • Calculated Fields and Items

Adds custom calculations inside PivotTables using calculated fields and items. These extend PivotTable analysis beyond the source data's existing columns.

Lesson 1 • Statistical Analysis Tools

Runs descriptive statistics, regression, and correlation via the Analysis ToolPak. These tools support data-driven decisions without external software.

Lesson 2 • What-If Analysis Tools

Applies Goal Seek, Scenario Manager, and Data Tables for sensitivity analysis. What-if tools quantify the impact of variable changes on outcomes.

Lesson 3 • Solver and Optimisation

Uses the Solver add-in to find optimal solutions under defined constraints. Solver handles resource allocation, scheduling, and cost minimisation problems.

Lesson 4 • Array Formulas and LAMBDA

Builds Ctrl+Shift+Enter arrays and custom LAMBDA functions for reusable logic. LAMBDA enables users to define named functions without VBA.