$25 Courses

$25 Short Courses

These short, practical courses are between one and two hours long. They are intermediate or advanced level and have an in-depth coverage of an Excel topic.
All courses

include a detailed pdf manual
have a recording of a live webinar
include an example Excel file
have a quiz
include a completion certificate

Most courses include a completed Excel file.
Mix and match these short courses to build your own unique Excel training experience.
Some courses require the subscription version of Excel - check the description for Microsoft 365.

Stay up to date with all the new features in Excel.

Short Course listing

Scroll down to see all the topics

Choose your own Excel training adventure.

$25 Courses

Advanced Budgeting Techniques 2024

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

Advanced Excel Budgeting Techniques

Discover how to build in row level selections to your budget. Version: All versions Recorded: Feb 2020 Level: Advanced Duration 1 hour Price: AU$25

Advanced Range Names 2025

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

Advanced Ranges Names

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. Version: Microsoft 365 Recorded: Aug 2022 Level: Advanced Duration: 1 hour Price: AU$25

Budget Template (1.5 hrs)

See how you can use a Budget Template to speed up the budget creation process. The techniques in this sessions work in all versions. Versions: All versions Recorded: Feb 2020 Level: Advanced Duration: 1.5 hours Price: AU$25

Budget Template 2024 (1hr 45min)

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

Budget Template 2025 (1 hr 45 min)

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

Budget and Power Query 2024

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

Budget and Power Query 2025

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

Custom Functions and Range Names (1.5 hrs)

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, SUMCOL, SUMROW and SUMDA. These SUM functions work with two-dimensional spill ranges. Version: Microsoft 365 Recorded: August 2022 Level: Advanced Duration: 1.5 hours Price: AU$25

Custom Functions and Range Names 2025 (80 min)

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 Advanced Functions

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: April 2024 Level: Advanced Duration: 1 hour Price: AU$25

Dynamic Arrays Advanced Functions 2025 (75 min)

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 Basic Functions

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. Examples include a loan schedule and a simple budget. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: AU$25

Dynamic Arrays Basic Functions 2025

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 Intermediate Functions

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. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: AU$25

Dynamic Arrays Intermediate Functions 2025

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

Excel Budget Payroll

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 & could be scaled further. Version: All Versions Recorded: Feb 2022 Level: Advanced Duration: 1 hour Price: AU$25

Excel Budget Payroll 2024

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

Excel Budget Scenarios - 2025

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

Excel COUNTIFS Function

The COUNTIFS function has been around for many versions. COUNTIFS offers the ability to perform single or multiple criteria counting. This session explores the way you can use it to solve real world problems. Version: All versions Recorded: Aug 2021 Level: Intermediate Duration: 1 hour Price: AU$25

Excel Chart Hacks

Learn how to create non-standard charts in Excel. Includes using text boxes, high/low charts, variance charts, conditional colours, Waterfall charts, banding and expanding ranges. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25

Excel Checkbox Bonanza

See how to make the most of checkboxes in your spreadsheet. This user interface feature makes it easy to turn calculations off and on. Version: All versions Recorded: Feb 2021 Level: Intermediate Duration: 1 hour Price: AU$25

Excel Dashboards #2 - Formula based dashboard

Discover how to use classic Excel formulas to create charts for your dashboard. Lots of different techniques covered. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25

Excel Dashboards #2 - Formula-based 2024

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

Excel Dashboards #3 - Sparklines & Conditional Formats 2024

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

Excel Dashboards #3 - Sparklines and Conditional Formats

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. Version: All Versions Recorded: Apr 2020 Level: Intermediate Duration: 1 hour Price: AU$25

Excel Dashboards #4 - PivotCharts and Slicers 2024

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

Excel Dashboards #5 - Dynamic Arrays 2024 (1.5hrs)

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

Excel Gantt Chart Workshop (1.75hrs)

Learn how to combine many of Excel's features to create flexible date based reports. Version: All Versions Recorded: Apr 2020 Level: Advanced Duration: 1.75 hours Price: AU$25

Excel Level Two - Intermediate - 2024 - 4hrs 30min

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

Excel Level Two - Intermediate - 4.5+ hours

Learn how to work better with data, functions, formats and charts. Include bonus content not in the live event. Level: Intermediate Duration: 4.5+ hours Recorded: May 2020 Price: AU$25

Excel Loan Schedules

This session examines 5 + 2 different loan schedules. 1. Standard Loan Schedule – standard formulas. 2. Standard Loan Schedule – dynamic array formulas. 3. Loan Drawdown Schedule. 4. Interest Only Period Loan Schedule. 5. Extra Repayments Loan Schedule. 6. *Custom Function 7. *Interest Only Version: All versions + Microsoft 365 Recorded: Jun 2024 Level: Intermediate to Advanced Duration: 1 hour Price: AU$25

Excel Logic Formulas (1.25hrs)

Its not just the IF function - find out how to make the most of logic in Excel. See how you can use TRUE and FALSE in formulas. Version: Old (pre-Dynamic arrays) Level: Intermediate Recorded: March 2020 Duration: 1.25 hours Price: AU$25

Excel Option Button Blitz

Learn how to use option buttons (aka radio buttons) to improve the Excel User interface. Version: All Versions Recorded: Jun 2021 Level: Intermediate Duration: 1 hour Price: AU$25

Excel Project - Index Sheet 2022

An Index or a Contents sheet is required for Excel files that have multiple tabs. The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files. Version: Microsoft 365 Recorded: Nov 2022 Level: Advanced Duration: 1 hour Price: AU$25

Excel Reporting Solutions - Month and YTD - 2025

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

Excel Reporting Solutions - 12 Month Report - 2025 Course

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

INDEX and MATCH Solutions (1.5 hrs)

The INDEX-MATCH combination is an advanced technique that can solve many look up problems. The two functions are useful in their own right, but together they provide a range of solutions to common look up requirements. INDEX and MATCH with Dynamic Arrays explained. Version: All versions for most content (Dynamic Arrays require Microsoft 365) Recorded: Aug 2022 Level: Advanced Duration: 1.5 hours Price: AU$25

INDIRECT Function

The function of last resort - it can perform calculations no other function can match. See how to solve common problems using the INDIRECT function. Version: All versions Recorded: March 2020 Level: Intermediate Duration: 1 hour Price: AU$25

Introduction to Range Names

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: Aug 2022 Level: Intermediate Duration: 1 hour Price: AU$25

Macro Shorts 1 - Useful Short Macros - Course

Includes 1 additional product

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: Nov 2025 Duration: 1 hour Price: AU$25

Includes 1 Additional Product

Macro Shorts 1 - Useful Short Macros - Live Webinar

Macros 2 - Recorded to Remarkable 2024

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

Macros 2 - Recorded to Remarkable 2025

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

Macros 3 - Interaction & Debugging 2024

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

Macros 3 - Interaction & Debugging 2025

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: Nov 2025 Level: Intermediate Duration: 80 min Price: AU$25

Macros 8 - VBA Variables 2024

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

Pivot Tables from Start to Finish

PivotTables allow you to summarise large data sets with a few clicks and no formulas. This bundle introduces PivotTables and takes you though the basics and covers more advanced topics. Version: All Versions Recorded: Jun 2020 Level: Intermediate Duration: 2.5+ hours Price: AU$25

Range Name Essentials 2025

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

SUMPRODUCT Function (1.5 hrs)

It has been called the Swiss army knife of functions. It can do array calculations without the array entry. If you don't have dynamic arrays yet, you can practice some of the techniques with SUMPRODUCT. Version: All versions Recorded: March 2020 Level: Intermediate Duration: 1.5 hours Price: AU$25

Summing Functions For Accountants 2025

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

Three Statement Excel Budget

A three statement Budget. See how to integrate the Profit & Loss, Balance Sheet and Cash Flow. This session uses traditional Excel formulas and functions and works in all versions. Versions: All versions Recorded: Feb 2020 Level: Advanced Duration: 1 hour Price: AU$25

Three Statement Excel Budget 2024

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

Three Statement Excel Budget 2025

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

VLOOKUP Function 2024 (1.5 hrs)

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

Testimonials

VLOOKUP Function

Score 10/10

Thanks so much Neale, some great tips in there. This will definitely help me in my role!

K Rowe, July 2024

Format As Table Features

Score 10/10

Brilliant! Will definitely be using this information in my day to day... as well as keep an eye out on more sessions! Thanks Neale. :)

H Gerrand

January 2024

H Gerrand, January 2024