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

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

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

Discover quick ways to create and edit formulas and functions.

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

See various ways to lookup demonstrated and explained. From VLOOKUP and HLOOKUP to INDEX and MATCH. Level: Intermediate Duration: 1 hour Recorded: Mar 2020 Price: AU$25

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

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

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

A brand new function that replaces VLOOKUP, HLOOKUP and INDEX-MATCH formulas. It has some special features. See how to apply them in the 1.5 hour session. Version: All Versions Recorded: Mar 2021 Level: Intermediate Duration: 1.5 hours Price: AU$25

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

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

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

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

Level: Intermediate Duration: 1 hour Price: Free

Learn the tips, tricks, traps and techniques to summing up right in Excel. 

Learn the tips, tricks, traps and techniques to get summing right in Excel.  Version: All Versions Recorded: Apr 2022 Level: Intermediate Duration: 1 hour Price: AU$25

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