Latest Excel courses

Learn advanced range names techniques. See how to simplify formulas & speed up formula creation. Learn different ways to create ranges & how to use naming conventions to make formulas easy to copy & amend. (Includes registration to the live webinar 17 April 2025) Version: Microsoft 365 Recorded: April 2025 Level: Advanced Duration: 1 hr 15 min Price: AU$25

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

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

See how you can use a Budget Template to speed up the budget creation process. This course uses new features and functions in the subscription version of Excel. Includes an extras video to cover the new functions in more depth. Version: Microsoft 365 Recorded: Feb 2025 Level: Advanced Duration: 1 hr 45 min Price: AU$25

See how to solve two budget issues with Power Query. Power Query can ensure all files have the same inputs and it can automate the budget consolidation process. Version: All Versions Recorded: Feb 2025 Level: Advanced Duration: 1 hour Price: AU$25

Three range sessions for the price of two! Range Name Essentials - the basics to get you started. Advanced Range Names - more advanced techniques. Custom Functions & Range Names (80 min) - make your own functions. Version: Microsoft 365 Recorded: April 2025 Level: Intermediate to Advanced Price AUD50

Learn how to create your own functions in Excel without using macros or VBA. This session requires the subscription version of Excel. Functions created include SheetName, IFBLANK, and SUMDA. The SUM functions works with two-dimensional spill ranges. Version: Microsoft 365 Recorded: April 2025 Level: Advanced Duration: 80 minutes Price: AU$25

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces the advanced level functions and formula techniques you need to make the most of dynamic arrays. Includes creating your own custom functions. Version: Microsoft 365 Recorded: May 2025 Level: Advanced Duration: 75 min Price: AU$25

Dynamic arrays are a game changer for creating formulas in Excel. Functions covered SEQUENCE, UNIQUE, CHOOSECOLS, CHOOSEROWS, TAKE, DROP, FILTER and SORTBY. This session introduces the basic functions and techniques you need to make the most of dynamic arrays. Version: Microsoft 365 Recorded: May 2025 Level: Intermediate Duration: 1 hour Price: AU$25

Dynamic arrays are a game changer for creating formulas in Excel. This dynamic array series has four courses and two bonuses. Bonus 1: Macro to format a spill range. Bonus 2: Custom Functions and Range Names (80 min) course added. Includes live webinar registrations in May 2025. Version: Microsoft 365 Recorded: due May 2025 Level: Intermediate to Advanced Duration: 5.5 hours Price: AU$60

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces the intermediate level functions and techniques you need to make the most of dynamic arrays. Includes live webinar registration 22 May 2025. Version: Microsoft 365 Recorded: due 22 May 2025 Level: Intermediate Duration: 1 hour Price: AU$25

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

Learn how to convert a single budget into a multiple scenario budget. Discover structures, techniques + shortcuts to make the conversion easier. See how to use data tables to capture the important metrics from each scenario. See how easy it is to add even more scenarios Version: Microsoft 365 Recorded: Feb 2025 Level: Advanced Duration: 1 hour Price: AU$25

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

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

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

Dynamic arrays change the way Excel reports are created. See how to apply dynamic arrays to a Month and YTD report. Includes a new range syntax technique as well. The session covers. - automatically inserting new accounts - filtering the report - changing the order of accounts - hiding zero and blank rows using a Slicer Version: Microsoft 365 Recorded: Jun 2025 Level: Intermediate Duration: 1 hour Price: AU$25

Dynamic arrays have changed the way Excel reports are created. See how to apply dynamic arrays to a 12 month report with budgets and forecasts. The session covers. - automatically inserting new accounts - filtering the report - changing the order of accounts Other reporting tips will also be shared. Version: M365 - Subscription Recording: Oct 2025 Level: Advanced Duration: 80 min Price: AU$25

The Excel courses from 2025 in one bundle. AU$350 value for AU$210. Most courses require the subscription version of Excel. Topics include. - Power Query, Budgets - Range Names, Dynamic Arrays - Reporting solutions, Tips & Shortcuts - XLOOKUP Function Over 27 hours of practical Excel Training. All courses include a Certificate of Completion. 3 month payment plan available. Scroll down to see all the courses.

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

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

Macros don't have to be long and complex to be useful. This session covers over 20 useful short macros (6 lines or less) that can speed up your work. They may give you inspiration and techniques to develop your own short macros. Level: Intermediate Version: All versions Recorded: Due: Thu 27 Nov 2025 Duration: 1 hour Price: AU$25

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

Recorded macros have lots of limitations. See how to remove many of the limitations with a little bit of programming. No programming experience required. Learn how to speed up your macros and use variables. (Session assumes you have completed the Macros 1 session or that you are comfortable with recording macros) Version: All versions Recorded: due 25 Nov 2025 Level: Intermediate Duration: 90 min Price: AU$25

Recorded macros can’t interact with the user. Interaction makes macros more user-friendly and flexible. Debugging involves removing errors from your code. Learning these techniques help improve your macros. Macros 1 and 2 are prerequisites or you must be familiar with editing recorded macros to do this session. Version: All versions Recorded: due 27 Nov 2025 Level: Intermediate Duration: 90 min Price: AU$25

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

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

Learn about range names and see how to simplify formulas & speed up formula creation. Discover different ways to create ranges & how to use naming conventions to make formulas easy to copy & amend. Version: All Recorded: April 2025 Level: Intermediate Duration: 1 hour Price: AU$25

Learn the tips, tricks, traps and techniques to get summing right in Excel.  Discover how to do 3-D sums plus how to use the SUMIFS, SUBTOTAL and AGGREGATE functions. See how SUMPRODUCT works plus how to do complex conditional sums with the SUM function. Version: All versions Recorded: August 2025 Level: Intermediate Duration: 1 hour Price: AU$25

A three statement Budget built using dynamic arrays, Excel's new formula and function calculation engine. You need the subscription version of Excel for this session. See how to integrate the Profit & Loss, Balance Sheet and Cash Flow. Version: Microsoft 365 Recorded: Feb 2025 Level: Advanced Duration: 1 hr 15 min Price: AU$25

Discover how to build in row level selections into your budget. Incorporate Excel's new dynamic arrays in your budget. Techniques covered include - range names - logic calculations involving TRUE and FALSE - check boxes and how to turn off features - the INDIRECT function - dynamic arrays - creating a custom function example Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration 1 hour Price: AU$25

Learn how to take Excel to the next level. Includes many advanced functions. Advanced PivotTable techniques including how to create relationships between tables. Dynamic arrays are covered in depth. Version: Microsoft 365 Recorded: Nov 2024 Level: Advanced Duration: 4.5+ hours Price: AU$50

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

See how you can use a Budget Template to speed up the budget creation process. This course uses new features and functions in the subscription version of Excel. Includes an extras video to cover the new functions in more depth. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1 hr 45 min Price: AU$25

See how to solve two budget issues with Power Query. Power Query can ensure all files have the same inputs and it can automate the budget consolidation process. Version: All Versions Recorded: Feb 2024 Level: Advanced Duration: 1 hour Price: AU$25

Create 4 different dashboards in Excel. 1. Formula-based dashboard - old school but effective. 2. Sparkline charts plus conditional formatting - small charts + icons. 3. Interactive dashboard using PivotCharts & Slicers. 4. Dynamic Arrays - the new way to calculate formulas - subscription version required. Bonus - Chart Hacks - see how to create unusual charts Level: Intermediate Duration: 8+ hours Price: AU$100

Dynamic arrays are a game changer for creating formulas in Excel. This dynamic array series has four courses and two bonuses. Bonus 1: Macro to format a spill range. Bonus 2: Custom Functions and Range Names (1.5 hour) course added. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 5.5 hours Price: AU$60

All the courses you need to get started and be productive with macros plus a few bonuses. Macros make automating and delegating Excel tasks much easier. Recorded macros (1.25hrs) Recorded to Remarkable (1.5hrs) Interaction & Debugging (1.5hrs) VBA Variables (1.25hrs) Macros Bonus - videos not seen in the live webinars Versions: All versions Recorded: May 2024 Level: Intermediate Duration: 5.5+ hours Price: AU$60

This session examines an existing payroll budget structure. Payroll is one of largest expenses in many organisations. Getting it right is an important step in the budget process. Often the payroll budget is separate to the main budget due to confidentiality issues. This payroll model handles up 250 staff & can be scaled. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

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

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

Discover how to use classic Excel formulas to create charts for your dashboard. Version: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. This sessions has been updated to use dynamic arrays. Version: Microsoft 365 Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

See how easy it add interaction to your dashboards by using Slicers to enable live filtering. Versions: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

This is the fifth in the dashboard series and focuses on creating a dashboard using dynamic arrays. Subscription version required. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail and a total in a single formula. Version: Microsoft 365 Recorded: March 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

The best place to start. Learn the Excel basics plus lots of techniques and shortcuts to speed up your work. Version: All versions Level: Beginner Recorded: Aug 2024 Duration: 4 hours 30 min Price: Free

Learn how to work better with data, functions, formats and charts. Combine formatted tables and pivot tables to create reports without a single formula. Have you formats automatically update based on cell values. Use charts to visualise the numbers. Learn the secrets of the SUM function plus see how to use XLOOKUP, SUMIFS and IF. Recorded: Sep 2024 Level: Intermediate Duration: 4 hours 30 min Price: AU$25

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

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

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

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: May 2024 Level: Intermediate Duration: 1 hour Price: Free

Recorded macros have lots of limitations. See how to remove many of the limitations with a little bit of programming. No programming experience required. Learn how to speed up your macros and use variables. (This session assumes you have completed the Macros 1 session or that you are comfortable with recording macros) Version: All versions Recorded: May 2024 Level: Intermediate Duration: 1hr 30min Price: AU$25

Recorded macros can’t interact with the user. Interaction makes macros more user-friendly and flexible. Debugging involves removing errors from your code. Learning these techniques help improve your macros. Macros 1 and 2 are prerequisites or you must be familiar with editing recorded macros to do this session. Version: All versions Recorded; May 2024 Level: Intermediate Duration: 1hr 30min Price: AU$25

This session covers variables in depth and expands on previous sessions. Learn how to make the most of variables in your VBA code. There are so many advantages to using variables, but you need to get a good understanding of them to get the most out of them. Version: All versions Recorded: May 2024 Level: Intermediate Duration: 1 hour 15 minutes Price: AU$25

New courses were added in 2024 & others updated. This Bundle brings them all together. Free and Paid sessions. Includes Budgets, Dashboards, Macros, Functions and Dynamic Arrays. Get all the latest courses for one low price. Payment plan available at no extra cost. Versions: Microsoft 365 Recorded: During 2024 Level: Beginner to Advanced Duration: 45 hours Price: AU$315 Payment Plan: AU$105 per month x 3 months

A three statement Budget built using dynamic arrays, Excel's new formula and function calculation engine. You need the subscription version of Excel for this session. See how to integrate the Profit & Loss, Balance Sheet and Cash Flow. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1 hr 15 min Price: AU$25

One of the most popular functions in Excel. See how to use it and avoid many of the issues plus handle the various errors that can happen. Versions: All versions Recorded: July 2024 Level: Intermediate Duration: 1.5 hours Price: AU$25