Excel Course

Lesson 1 • Creating and Managing Workbooks

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

Lesson 2 • Worksheet Structure and Cell Basics

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

Lesson 3 • Data Entry and Editing Techniques

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

Lesson 4 • Printing and Page Layout Setup

Configures print areas, margins, headers, and footers for output. Ensures professional-looking printed reports from the start.

Lesson 1 • Cell and Text Formatting Essentials

Covers fonts, alignment, borders, and fill colours for visual structure. Directly improves readability of all worksheets built in this course.

Lesson 2 • Table Styles and Structured Tables

Converts ranges to Excel Tables with automatic formatting and filtering. Introduces structured references used in later formula chapters.

Lesson 3 • Number and Date Formatting

Teaches built-in and custom number formats for currency, dates, and percentages. Ensures data displays correctly without altering underlying values.

Lesson 4 • Conditional Formatting Rules

Applies colour scales, data bars, and icon sets based on cell values. Enables instant visual identification of trends and outliers.

Lesson 1 • Essential Math and Statistical Functions

Covers SUM, AVERAGE, COUNT, MIN, MAX, and ROUND for numeric analysis. Forms the calculation backbone of most business spreadsheets.

Lesson 2 • Date and Time Functions

Calculates durations, deadlines, and periods using TODAY, NOW, and DATEDIF. Supports scheduling and time-based reporting tasks.

Lesson 3 • Formula Fundamentals and Operators

Introduces formula syntax, operator precedence, and cell references. Establishes the logic framework for every function in this chapter.

Lesson 4 • Logical Functions for Decision Making

Teaches IF, AND, OR, and NOT to build conditional logic into formulas. Enables automated decisions based on data conditions.

Lesson 1 • Reference Functions and Named Ranges

Covers OFFSET, INDIRECT, and named ranges for dynamic and readable references. Enables formulas that adapt automatically to data changes.

Lesson 2 • VLOOKUP and HLOOKUP Mastery

Explains exact and approximate match lookups in vertical and horizontal tables. Provides the foundational lookup skill before introducing modern alternatives.

Lesson 3 • Conditional Aggregation Functions

Applies COUNTIF, SUMIF, AVERAGEIF, and their multi-criteria variants for filtered totals. Connects lookup logic to summary calculations.

Lesson 4 • XLOOKUP for Modern Lookups

Uses XLOOKUP to replace VLOOKUP and INDEX/MATCH with a single, flexible function. Covers default values, search modes, and array returns.

Lesson 1 • Data Validation Rules

Restricts cell input using lists, number ranges, and custom formulas. Prevents entry errors before they corrupt downstream analysis.

Lesson 2 • What-If Analysis Tools

Applies Goal Seek, Scenario Manager, and Data Tables for sensitivity analysis. Supports business decision-making by modeling variable outcomes.

Lesson 3 • Grouping, Subtotals, and Outlines

Groups rows and columns and inserts automatic subtotals for hierarchical summaries. Prepares students for pivot table aggregation in the next chapter.

Lesson 4 • Removing Duplicates and Cleaning Data

Uses Remove Duplicates, Find and Replace, and text tools to clean raw data. Ensures dataset accuracy before applying formulas or pivot tables.

Lesson 1 • Dynamic Charts with Named Ranges

Links charts to dynamic named ranges so visuals update automatically with new data. Integrates chart skills with the reference functions from Chapter 4.

Lesson 2 • Building and Editing Charts

Creates charts from selected data and edits source ranges, series, and axes. Builds hands-on chart construction skills applicable to any dataset.

Lesson 3 • Advanced Chart Types and Combos

Builds combo charts, waterfall, funnel, and sparkline visualizations for complex data. Expands the visual toolkit beyond standard chart types.

Lesson 4 • Choosing the Right Chart Type

Maps data relationships to appropriate chart types including bar, line, and pie. Prevents common visualization mistakes that mislead audiences.

Lesson 1 • Building Your First PivotTable

Creates a PivotTable from a structured dataset and configures field placement. Establishes the drag-and-drop workflow central to all pivot analysis.

Lesson 2 • Filtering PivotTables with Slicers

Adds slicers and timelines for interactive, visual filtering of PivotTable data. Enables dashboard-style interactivity without code.

Lesson 3 • Summarizing and Grouping PivotData

Applies sum, count, average, and custom calculations within PivotTables. Groups dates and numbers into meaningful reporting periods.

Lesson 4 • PivotTable Design and Layout Options

Customizes PivotTable styles, layouts, and subtotal display for professional output. Aligns pivot reports with organizational formatting standards.

Lesson 1 • Dynamic Array Functions

Uses FILTER, SORT, UNIQUE, SEQUENCE, and RANDARRAY for spill-range outputs. Replaces complex legacy formulas with readable, single-cell solutions.

Lesson 2 • Array Formulas and Legacy CSE

Introduces Ctrl+Shift+Enter array formulas for multi-value calculations in a single cell. Provides context for understanding modern dynamic array behavior.

Lesson 3 • Macros and Basic Automation

Records and runs macros to automate repetitive formatting and data tasks. Introduces automation concepts without requiring programming knowledge.

Lesson 4 • Protecting and Securing Workbooks

Locks cells, protects sheets, and encrypts workbooks to control access and edits. Safeguards formulas and data in shared professional environments.