Basic and Advanced Excel Course

Lesson 1 • Workbook and Worksheet Management

Teaches creating, saving, and organizing workbooks and sheets. Proper file habits prevent data loss and support team collaboration.

Lesson 2 • Basic Cell and Range Formatting

Applies fonts, borders, colors, and number formats to cells. Readable formatting is essential before building reports or sharing data.

Lesson 3 • Cell Selection and Data Entry

Introduces efficient cell selection techniques and data entry shortcuts. Accuracy at this stage reduces errors in formulas and analysis later.

Lesson 4 • Navigating the Excel Interface

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

Lesson 1 • Relative, Absolute, and Mixed References

Distinguishes how cell references behave when copied or filled. Mastering reference types is critical for scalable, accurate spreadsheet models.

Lesson 2 • Formula Syntax and Operators

Explains how Excel parses formulas and applies operator precedence. A solid syntax foundation prevents calculation errors in complex models.

Lesson 3 • Text Functions for Data Cleaning

Covers LEFT, RIGHT, MID, TRIM, CONCATENATE, and TEXT. Clean text data is a prerequisite for accurate lookups and pivot analysis.

Lesson 4 • Essential Math and Statistical Functions

Introduces SUM, AVERAGE, COUNT, MIN, MAX, and ROUND. These functions form the backbone of quantitative analysis in any Excel workflow.

Lesson 1 • Filtering and Advanced Filter Options

Applies AutoFilter and Advanced Filter to isolate relevant records. Filtering skills directly support reporting, auditing, and data validation tasks.

Lesson 2 • Sorting Data Effectively

Teaches single-level and multi-level sorting by value, color, or custom list. Proper sorting is the first step in making datasets readable and analyzable.

Lesson 3 • Removing Duplicates and Data Consistency

Uses Remove Duplicates, TRIM, and consistent formatting to clean datasets. Consistent data is essential before any aggregation or lookup operation.

Lesson 4 • Excel Tables and Structured References

Converts ranges to Excel Tables and uses structured reference syntax. Tables automate formatting and make formulas self-documenting and easier to audit.

Lesson 1 • XLOOKUP for Modern Data Retrieval

Introduces XLOOKUP syntax, default values, and search modes. XLOOKUP replaces legacy lookup functions with a cleaner, more powerful single formula.

Lesson 2 • VLOOKUP Fundamentals and Limitations

Explains VLOOKUP syntax, exact vs. approximate match, and common errors. Understanding its limits motivates the adoption of more flexible alternatives.

Lesson 3 • INDEX and MATCH for Flexible Lookups

Combines INDEX and MATCH to retrieve values from any column or row direction. This pair overcomes VLOOKUP's structural limitations in complex datasets.

Lesson 4 • HLOOKUP and Two-Way Lookups

Applies HLOOKUP for horizontal tables and combines it with VLOOKUP for two-way retrieval. Expands lookup capability to matrix-style data structures.

Lesson 1 • Dynamic Charts with Named Ranges

Links charts to dynamic named ranges so visuals update automatically with new data. Dynamic charts reduce manual maintenance in recurring reporting workflows.

Lesson 2 • Sparklines and In-Cell Visuals

Creates sparklines and uses data bars and icon sets for compact visuals. In-cell visuals add analytical context without requiring separate chart objects.

Lesson 3 • Choosing the Right Chart Type

Maps data relationships to appropriate chart types such as bar, line, and pie. Selecting the correct chart type is the foundation of effective visual communication.

Lesson 4 • Building and Editing Charts

Covers inserting charts, selecting data ranges, and switching rows and columns. Hands-on editing skills allow rapid iteration during analysis and presentation.

Lesson 1 • Filtering with Slicers and Timelines

Adds slicers and timelines for interactive, visual filtering of PivotTable data. These controls make dashboards intuitive for non-technical stakeholders.

Lesson 2 • Summarising and Grouping Data

Applies SUM, COUNT, AVERAGE, and custom calculations within PivotTables. Grouping dates and numbers reveals patterns invisible in row-level data.

Lesson 3 • Calculated Fields and Items

Creates custom metrics inside PivotTables using calculated fields and items. Custom calculations extend PivotTable analysis without altering source data.

Lesson 4 • PivotCharts and Dashboard Integration

Generates PivotCharts linked to PivotTables and arranges them into a dashboard layout. Integrated visuals allow executives to explore data through a single interface.

Lesson 1 • Advanced Conditional Functions

Extends conditional logic with SUMIF, COUNTIF, AVERAGEIF, and their multi-criteria variants. These functions replace manual filtering with automated, criteria-driven aggregation.

Lesson 2 • Financial Functions for Business Analysis

Applies PMT, PV, FV, NPV, and IRR to investment and loan scenarios. Financial functions enable professionals to model cash flows and evaluate business decisions.

Lesson 3 • Dynamic Array Functions

Introduces FILTER, SORT, UNIQUE, SEQUENCE, and RANDARRAY for spill-range outputs. Dynamic arrays eliminate helper columns and enable self-updating analytical outputs.

Lesson 4 • Date and Time Functions

Covers TODAY, NOW, DATEDIF, NETWORKDAYS, and EDATE for temporal calculations. Date functions automate deadline tracking, ageing reports, and scheduling models.

Lesson 1 • Data Tables for Sensitivity Analysis

Builds one-variable and two-variable data tables to test formula sensitivity. Sensitivity tables reveal how outputs change across a range of input assumptions.

Lesson 2 • Recording and Running Macros

Records, edits, and runs macros to automate repetitive formatting and data tasks. Macro automation reduces processing time and eliminates human error in routine workflows.

Lesson 3 • Introduction to VBA Scripting

Introduces VBA variables, loops, conditionals, and subroutines for custom automation. Basic VBA skills extend Excel beyond its built-in capabilities for complex workflows.

Lesson 4 • Solver for Optimisation Problems

Configures Solver to maximise, minimise, or meet targets subject to constraints. Optimisation models support resource allocation, scheduling, and cost minimisation decisions.