Excel Course for Data Analysis

Lesson 1 • Data Entry and Validation Basics

Introduces structured data entry, AutoFill, and basic input validation rules. Clean entry habits prevent errors that compound in later analysis steps.

Lesson 2 • Workbook and Worksheet Management

Teaches creating, renaming, moving, and protecting sheets within a workbook. Provides the organisational foundation for multi-sheet data projects.

Lesson 3 • Saving, Sharing, and File Formats

Covers file format options, AutoSave, and cloud-based sharing settings. Ensures work is preserved and accessible across collaborative environments.

Lesson 4 • Navigating the Excel Environment

Covers the Ribbon, Quick Access Toolbar, and worksheet navigation shortcuts. Establishes the spatial awareness needed for all subsequent data work.

Lesson 1 • Sorting and Filtering Data

Applies single-level and multi-level sorts and AutoFilter to isolate subsets. These skills are prerequisites for aggregation and pivot analysis.

Lesson 2 • Cell and Number Formatting

Applies number, date, currency, and custom formats to cells. Proper formatting ensures data is interpreted correctly in calculations and charts.

Lesson 3 • Converting Ranges to Excel Tables

Converts data ranges into structured Excel Tables with automatic expansion and filtering. Tables are the preferred container for all analytical datasets.

Lesson 4 • Data Cleaning Techniques

Removes duplicates, trims whitespace, and standardises inconsistent entries. Clean data is the prerequisite for accurate formulas and summaries.

Lesson 1 • Logical Functions and Nested Logic

Builds IF, AND, OR, and nested logical statements for conditional calculations. Logical functions enable dynamic outputs based on data conditions.

Lesson 2 • Text Functions for Data Manipulation

Applies LEFT, RIGHT, MID, CONCATENATE, and TEXT to reshape string data. Text functions are essential for parsing and reformatting imported datasets.

Lesson 3 • Date and Time Functions

Calculates durations, extracts date parts, and builds date-based conditions. Date functions support time-series analysis and deadline tracking.

Lesson 4 • Mathematical and Statistical Functions

Covers SUM, AVERAGE, COUNT, MIN, MAX, and rounding functions. These form the arithmetic backbone of every analytical model in the course.

Lesson 1 • VLOOKUP and HLOOKUP Fundamentals

Explains vertical and horizontal lookup syntax, match types, and common errors. Provides the baseline lookup skill before introducing modern alternatives.

Lesson 2 • INDEX and MATCH for Flexible Lookups

Combines INDEX and MATCH to retrieve values from any column or row direction. Overcomes VLOOKUP's column-order limitation for complex datasets.

Lesson 3 • XLOOKUP and Modern Lookup Functions

Uses XLOOKUP for cleaner syntax, default values, and reverse-direction searches. Positions students to use the current best-practice lookup approach.

Lesson 4 • Reference Functions for Dynamic Ranges

Applies OFFSET, INDIRECT, and CHOOSE to build dynamic, self-adjusting references. These functions enable dashboards and models that update automatically.

Lesson 1 • Calculated Fields and Items

Creates custom metrics inside PivotTables using calculated fields and items. Extends built-in aggregations without altering the source dataset.

Lesson 2 • Slicers and Timelines for Interactivity

Adds slicers and timeline controls to filter PivotTables visually. Transforms static summaries into interactive reporting tools for stakeholders.

Lesson 3 • Value Field Settings and Show Values As

Configures percentage of total, running totals, and rank calculations. These settings reveal proportional and trend insights within the same PivotTable.

Lesson 4 • Grouping and Summarising Data

Groups dates, numbers, and text fields to create meaningful aggregation levels. Grouping transforms transactional data into analytical summaries.

Lesson 1 • Sparklines and In-Cell Visuals

Inserts sparklines and data bars directly into cells for compact trend display. In-cell visuals complement full charts in dense summary tables.

Lesson 2 • Choosing the Right Chart Type

Maps analytical questions to appropriate chart types using a decision framework. Correct chart selection prevents misrepresentation of data relationships.

Lesson 3 • Formatting Charts for Clarity

Applies titles, legends, gridlines, and colour schemes to maximise readability. Formatting choices directly affect how quickly audiences extract insight.

Lesson 4 • Building and Editing Charts

Creates charts from table data and edits series, axes, and data labels. Hands-on construction reinforces the link between data structure and visual output.

Lesson 1 • Dynamic Array Functions Overview

Introduces spill behaviour, the spill range operator, and implicit intersection changes. Understanding spill is essential before using any dynamic array function.

Lesson 2 • Sequence and Random Array Generation

Generates numeric sequences and random samples using SEQUENCE and RANDARRAY. Supports simulation, test data creation, and dynamic numbering.

Lesson 3 • Unique Values and Frequency Analysis

Applies UNIQUE and FREQUENCY to identify distinct values and distribution patterns. These functions replace manual deduplication and histogram binning.

Lesson 4 • Filtering and Sorting with Formulas

Uses FILTER, SORT, and SORTBY to extract and order data programmatically. Formula-based filtering updates automatically when source data changes.

Lesson 1 • Formatting and Protecting the Final Report

Applies consistent styling, hides gridlines, and locks cells to protect the layout. A polished, protected dashboard builds stakeholder trust and prevents errors.

Lesson 2 • Linking Charts and PivotTables to a Dashboard

Connects PivotCharts and formula-driven charts to a single display sheet. Centralised linking ensures all visuals refresh from one data source.

Lesson 3 • Dashboard Planning and Layout Design

Defines audience needs, KPIs, and grid-based layout before building. Planning prevents redesign and ensures the dashboard answers real business questions.

Lesson 4 • Automating Refresh and Data Updates

Configures PivotTable refresh, Power Query load settings, and connection refresh. Automation reduces manual maintenance and keeps dashboards current.