Excel Yourself/FREE Excel Webinars - all together in one course

Free Excel webinar recordings and materials

Many of the free Excel courses on this site are combined in a single course. Over 1,600 people have enrolled in this course.

As I add new free content it will be added to this special bundle to make it easy for you to access free content including materials and recordings. Currently it has over 25 hours of free, high quality Excel training.

This Bundle of courses will always be free.

  • Free

FREE Excel Webinars - all together in one course

  • Bundle

Over 25 free Excel webinars and their materials, all together in one brilliant bundle.

Contents

  • Free

Ask Me Anything 2025 (70 min)

To celebrate my 500th public webinar I ran another Excel Ask Me Anything session. Thanks to all who submitted questions. Topics include. • Filtering • Automating Footers and Headers • XOR and MOD functions • Templates • Dates and PivotTables • A simpler Age calculation Version: M365 - Subscription Recorded: July 2025 Level: Mixed - Beginner to Advanced Duration: 70 min Price: Free

  • Free

Budget Challenge 2024 - Subscription version

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Version: Microsoft 365 Recorded: Feb 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

  • Free

Budget Challenge - 2025 - Subscription version

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Version: Microsoft 365 Recorded: Feb 2025 Level: Intermediate to Advanced Duration: 1 hour Price: Free

  • Free

Budget Challenge Solution

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through my solution which matched his results. Level: Intermediate to Advanced Duration: 1 hour Price: Free

  • Free

Budget Challenge Solution Subscription 2023

  • Closed

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Version: Microsoft 365 Recorded: Feb 2023 Level: Intermediate to Advanced Duration: 1 hour Price: Free

  • Free

Budget Challenge Solution - Subscription Version

  • Closed

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Level: Intermediate to Advanced Duration: 1 hour Price: Free

  • Free

Dynamic Arrays Introduction

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces important concepts plus new symbols and functions to get you started using dynamic arrays. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Dynamic Arrays Introduction 2025

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces important concepts plus new symbols and functions to get you started using dynamic arrays. Version: Microsoft 365 Recorded: May 2025 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Ask Me Anything July 2022

As a follow up to my 400th public webinar I ran another Excel Ask Me Anything session. Thanks to all who submitted questions. Topics include. • Power Query and exceptions • Pivot table headings and formats • Allocations • Paste annoyances • Icon annoyance • Finding the last date for a code Version: All Versions Recorded: Jul 2022 Level: Mixed - Beginner to Advanced Duration: 1.25 hours Price: Free

  • Free

Excel Ask Me Anything June 2022 (1.25 hours)

To celebrate my 400th public webinar I ran an Excel Ask Me Anything session. Thanks to all who submitted questions. Topics include. • Charts • Pivot tables • Formatted tables • Unlocking cells • Financial models • Time calculations • The zodiac – well sort of Version: All Versions Recorded: Jun 2022 Level: Beginner to Advanced Duration: 1.25 hours Price: Free

  • Free

Excel Chart Tips and Tricks

  • Closed

Discover quick and easy ways to edit charts.

  • Free

Excel Chart Tips and Tricks 2021

Discover quick and easy ways to edit charts. Version: All Versions Recorded: Nov 2021 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Conditional Formats

Automate your formats and learn how to control conditional formats. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Copy and Paste Techniques

  • Closed

Learn the basics plus some advanced techniques. Level: Beginner Duration: 1 hour Price: Free

  • Free

Excel Copy and Paste Techniques 2024

Learn the basics of pasting plus some advanced techniques. Version: All versions Recorded: Dec 2024 Level: Beginner Duration: 1 hour 15 min Price: Free

  • Free

Excel Custom Number Formats

Learn a few formatting tricks to help you display numbers exactly as you want. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Dashboards #1 - Guidelines

Lots of ideas to improve your charts and dashboards.

  • Free

Excel Dashboards #1 - Guidelines - 2024

Lots of ideas to improve your charts and dashboards. Version: All Versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Data Handling Tips

This session focuses on using Excel's built-in data handling features like Format as Table, filtering, sorting and advanced filters. I will share tips, tricks and some traps when using the above features. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Date and Time Calculations

Learn the tricks to perform calculation with dates and time. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Financial Functions Part One and Two (2 hours)

  • Closed

Learn how to use Excel's specialised financial functions. Level: Intermediate Duration: 2 hours Price: Free

  • Free

Excel Format as Table Feature

  • Closed

Make the most of tables in Excel by using Format As Table. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Formatting Tips and Tricks

Lots of ideas and shortcuts to help improve your spreadsheet formatting. Level: Beginner Duration: 1 hour Price: Free

  • Free

Excel Formula and Function Tips and Tricks

  • Closed

Discover quick ways to create and edit formulas and functions.

  • Free

Excel Guidelines

  • Closed

Suggestions and recommendations to improve your Excel files. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Guidelines 2023

Suggestions and recommendations to improve your Excel files. These guidelines will help you use and create spreadsheets that. - are more reliable - identify errors - are easier to use and understand - have more flexible formulas (can be copied to more places) - are more structured - are easy to navigate Version: All Versions Recorded: Sep 2023 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Keyboard Shortcuts

Speed up your Excel work with better keyboard shortcuts. Level: Beginner Duration: 1 hour Price: Free

  • Free

Excel Keyboard Shortcuts - 2025

Speed up your Excel work with better keyboard shortcuts. See how to use the Ctrl, Shift and Alt keys to speed up your work. Lots of different shortcuts to make your Excel life easier. Version: All versions Recorded: June 2025 Level: Beginner Duration: 1 hour Price: Free

  • Free

Excel Mouse Shortcuts

Speed up your Excel work with better mouse skills. Level: Beginner Duration: 1 hour Price: Free

  • Free

Excel Mouse Shortcuts 2025

Speed up your Excel work with better mouse skills. See how to combine the keyboard and mouse to get your work done faster. Recorded: July 2025 Level: Beginner Duration: 1 hour Price: Free

  • Free

Excel Power Query Tips

Power Query simplifies importing data into Excel. These tips help to make using Power Query a bit easier. Tips covered relate to. -listing errors -data types and why they are important -financial year hack -IFERROR in Power Query? -renaming steps -adding notes to steps -default settings Version: All Versions Recorded: August 2025 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Questions & Answers April 2020 (1.5 hours)

Functions, formulas, formats and lots of other topics are covered in this wide ranging session. Version: All Versions Recorded: Apr 2020 Level: Intermediate Duration: 1.5 hours Price: Free

  • Free

Excel Text Functions

  • Closed

Everyone knows how well Excel handles numbers, but not everyone knows that Excel can work well with text as well.  This session demonstrates frequently used techniques to manipulate text and get the output you require. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel Text Functions 2023

Everyone knows how well Excel handles numbers, but not everyone knows that Excel can work well with text as well. This session demonstrates frequently used techniques to manipulate text and get the output you require. The session includes old and new text functions and features. Version: Microsoft 365 Recorded: Oct 2023 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel What If Techniques

  • Closed

Use Excel's built-in features to help solve complex problems. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Excel What If Techniques 2025

Use Excels built-in What If features to help solve complex problems. Topics covered: - Goal Seek - Solver - Scenario Manager - Data Tables - Forecast Sheet Version: All versions Level: Intermediate Recorded: April 2025 Duration: 1 hour Price: Free

  • Free

Financial Functions 2022 Parts 1 and 2 (2+ hours)

  • Closed

Learn how to use Excel's specialised financial functions. Includes a bonus 15 minute video on goal seek and macros. Version: Microsoft 365 Recorded: May 2022 Level: Intermediate Duration: 2+ hours Price: Free

  • Free

Financial Functions Part 1 (2024)

  • Includes 1 additional product

Most of these functions involve loans or calculations associated with the time value of money. They take three or more arguments (parts of a function), but there are a few things you need to know to use them correctly. This session covered the following six functions PV, PMT,CUMIPMT,RATE, FV, NPER, IFERROR Version: Microsoft 365 Recorded: Oct 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Includes 1 Additional Product

  • Free

Financial Functions Part 2 (2024)

  • Includes 1 additional product

Most of these functions involve the time value of money. There are a few things you need to know to use them correctly. This session covered the following functions NPV, PV, XNPV, IRR and XIRR. Version: All versions Recorded: Nov 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Includes 1 Additional Product

  • Free

Format As Table 2025

Learn how make the most of tables in Excel by using Format As Table. This is an important data handing skill to master. Tables allow you to build scalable solutions in Excel. See how to use them with range names, formulas, functions and PivotTables. Version: All Versions (some content requires the subscription version) Recorded: Oct 2025 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Format as Table Feature 2024

  • Closed

Learn how make the most of tables in Excel by using Format As Table. This is an important data handing skill to master. Version: All Versions Recorded: Jan 2024 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Formula & Function Tips 2022

  • Closed

Discover quick ways to create and edit formulas and functions. Version: All Versions Recorded: Jan 2022 Level: Beginner Duration: 1 hour Price: Free

  • Free

Formula & Function Tips 2024

Discover quick ways to create and edit formulas and functions. Includes many different techniques and shortcuts to speed up formula creation. Version: All Versions Recorded: July 2024 Level: Beginner Duration: 1 hour Price: Free

  • Free

Interactive Excel Chart

Learn how to build in interaction to your charts. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Interactive Excel Chart 2022

Learn how to build in interaction to your charts. Includes worksheet controls - combo boxes and a scroll bar. Version: All Versions Recorded: Aug 2022 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Introduction to Excel Power Query - 2025

Learn how to automate the data importation process in Excel. Import CSV files and perform data cleansing steps at the same time. See how to convert a MYOB report into real data. Version: All Versions Recorded: January 2025 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Introduction to Power BI (1.5 hours)

  • Closed

Get started with this incredible reporting App. Level: Intermediate Duration: 1.5 hours Price: Free

  • Free

Introduction To Power Pivot

  • Closed

Pivot Tables on steroids - in a good way. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Introduction to Power Pivot 2022

Pivot Tables on steroids - in a good way. See how to report on multiple tables in one report. Includes an introduction to DAX functions. Version: All Versions Recorded: Aug 2022 Level: Intermediate Duration: 1.5 hours Price: Free

  • Free

Introduction to Power Query - 2021

  • Closed

Learn how to automate the data importation process in Excel. Version: All Versions Recorded: May 2021 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Introduction to Power Query in Excel

  • Closed

Learn how to automate the data importation process in Excel.

  • Free

Macros 1 - Recording tips,tricks and traps

  • Closed

Learn how to reduce keystrokes, automate tasks and speed up your work. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Macros 1 - Recording Tips Tricks and Traps 2025

Learn how to reduce keystrokes, automate tasks and speed up your work. Plus get some bonus macros. Get started with recorded macros. Version: All versions Recorded: Nov 2025 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Master Excel's Form Controls

Learn how to create easy to use interfaces. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Power BI - importing data with Get Data (Power Query)

  • Closed

An introduction in how to get data in Power BI. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Power Query - Import Multiple Files - 2021

  • Closed

Learn how to automate the data importation process in Excel. Level: Intermediate Duration: 1 hour Price: Free

  • Free

Power Query - Import Multiple Files - 2022

  • Closed

Learn how to automate the data importation process in Excel. Version: All Versions Recorded: Apr 2022 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Power Query - Import Multiple Files 2024

  • Closed

Learn how to automate the data importation process in Excel. Discover how to combine all the CSV files from a folder and sib-folder. See how to combine sheets from multiple Excel files. Version: All Versions Recorded: June 2024 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Power Query - Import Multiple Files 2025

Learn how to automate the data importation process in Excel. Discover how to combine all the CSV files from a folder and sub-folder. See how to combine sheets from multiple Excel files. Learn how to merge tables together. Version: All Versions Recorded: September 2025 Level: Intermediate Duration: 1 hour Price: Free

  • Free

Quick Access Toolbar and Ribbon - 2025

The mysterious section at the top right of the Excel screen that is a treasure trove of shortcuts and productivity improvements. It is called the Quick Access Toolbar and many users have not yet tapped into its potential. Did you know you can make your own ribbon tabs? Version: All versions Recorded: Jan 2025 Level: Beginner Duration: 1 hour Price: Free