Microsoft Excel 365: From Beginner to Pro Course

Lesson 1 • Selecting, Entering, and Editing Data

Introduces cell selection techniques and data entry shortcuts. Accurate data entry underpins every formula and analysis task ahead.

Lesson 2 • Creating and Managing Workbooks

Teaches file creation, saving formats, and AutoRecover settings. Ensures students protect their work from the very first session.

Lesson 3 • Printing and Page Layout Essentials

Configures margins, print areas, and headers for professional output. Prepares students to share polished worksheets from day one.

Lesson 4 • Navigating the Excel 365 Interface

Covers the Ribbon, Quick Access Toolbar, and worksheet tabs. Builds the spatial awareness needed for all subsequent Excel tasks.

Lesson 1 • Data Validation Rules

Creates dropdown lists, numeric limits, and custom error messages. Prevents invalid entries before they corrupt downstream analysis.

Lesson 2 • Cell Formatting Fundamentals

Applies fonts, colours, borders, and alignment to cells. Transforms raw data into readable, professional-looking spreadsheets.

Lesson 3 • Working with Rows, Columns, and Cells

Teaches resizing, inserting, deleting, and freezing rows and columns. Maintains dataset integrity as spreadsheets grow in size.

Lesson 4 • Number and Date Formatting

Covers built-in and custom number formats for currency, dates, and percentages. Ensures data displays correctly for any audience.

Lesson 1 • Text Functions for Data Cleaning

Uses TRIM, CONCAT, LEFT, RIGHT, MID, and FIND to manipulate strings. Prepares imported or inconsistent text data for reliable analysis.

Lesson 2 • Formula Syntax and Cell References

Explains operators, order of operations, and relative vs. absolute references. Correct referencing is the foundation of every reliable formula.

Lesson 3 • Date and Time Functions

Calculates durations, deadlines, and periods using TODAY, NOW, DATEDIF, and NETWORKDAYS. Automates time-sensitive reporting tasks.

Lesson 4 • Essential Math and Statistical Functions

Covers SUM, AVERAGE, COUNT, MIN, MAX, and ROUND. These functions handle the majority of everyday business calculations.

Lesson 1 • XLOOKUP for Modern Data Retrieval

Introduces XLOOKUP's flexible syntax, default values, and reverse search. Replaces VLOOKUP limitations with a single, powerful function.

Lesson 2 • Advanced Reference Functions

Covers INDIRECT, OFFSET, CHOOSE, and MATCH for flexible referencing. Enables spreadsheets to adapt automatically to structural changes.

Lesson 3 • INDEX and MATCH Combination

Pairs INDEX with MATCH for two-way lookups and dynamic ranges. Solves retrieval problems that VLOOKUP and XLOOKUP cannot handle alone.

Lesson 1 • Sorting Data Effectively

Applies single-level and multi-level sorts by value, colour, or custom list. Correct sorting is prerequisite to meaningful filtering and reporting.

Lesson 2 • Removing Duplicates and Data Cleanup

Identifies and removes duplicate records using built-in tools and formulas. Clean data prevents double-counting and reporting errors.

Lesson 3 • Converting Data to Excel Tables

Creates formatted tables with structured references and auto-expansion. Tables are the recommended foundation for all data management tasks.

Lesson 4 • Named Ranges and Dynamic Arrays

Defines named ranges and introduces spill functions like UNIQUE and SORT. Reduces formula complexity and enables self-updating outputs.

Lesson 1 • Dynamic Charts with Tables and Slicers

Links charts to Excel Tables and slicers for interactive filtering. Dynamic charts update automatically as underlying data changes.

Lesson 2 • Choosing the Right Chart Type

Maps data relationships to bar, line, pie, scatter, and combo charts. Selecting the correct chart type is the first step in effective visualisation.

Lesson 3 • Sparklines and In-Cell Visuals

Embeds sparklines and icon sets directly inside cells for compact dashboards. Provides at-a-glance trends without requiring full chart objects.

Lesson 4 • Building and Formatting Charts

Inserts charts, edits data sources, and applies layouts and styles. Proper formatting ensures charts are readable and presentation-ready.

Lesson 1 • Summarising and Grouping Data

Applies SUM, COUNT, AVERAGE, and custom calculations to PivotTable values. Grouping dates and numbers reveals patterns invisible in raw data.

Lesson 2 • Building Your First PivotTable

Creates a PivotTable from a table or range and arranges fields. Understanding the field list is the gateway to all PivotTable analysis.

Lesson 3 • Filtering PivotTables with Slicers

Adds slicers and timelines to enable one-click PivotTable filtering. Interactive filters make reports accessible to non-technical stakeholders.

Lesson 4 • PivotCharts and Dashboard Integration

Generates PivotCharts linked to PivotTables and arranges them into dashboards. Combines slicers and charts for fully interactive reporting layouts.

Lesson 1 • Introduction to Macros and VBA

Records macros and edits basic VBA code to automate repetitive tasks. Provides a practical entry point into Excel automation without deep programming.

Lesson 2 • Advanced Formula Techniques

Combines array formulas, LAMBDA, and LET for compact, reusable logic. Reduces formula sprawl and improves spreadsheet maintainability.

Lesson 3 • Workbook Protection and Security

Locks cells, protects sheets, and encrypts workbooks to control access. Ensures sensitive data and formulas remain intact in shared environments.

Lesson 4 • What-If Analysis Tools

Uses Goal Seek, Scenario Manager, and Data Tables to model outcomes. Empowers decision-makers to evaluate options without rebuilding spreadsheets.