Learn how to take Excel to the next level. Includes many advanced functions and techniques. 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

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

Over 5 hours of video, detailed pdf manuals, example code, bonuses and quizzes. Includes a course on automating macros so they run automatically. Creating re-usable programming functions plus functions that work on a sheet. There are two workshops with real world examples. Create a reporting Add-in that runs from a right click menu. Version: All versions Recorded: 2020 Level: Advanced Duration: 5+ hours Price: AU$80

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: April 2025 Level: Advanced Duration: 75 min Price: AU$25

Special bundle pricing AU$35 for August 2026! Save AU$15! 2+ CPD hours. XLOOKUP Function - (70 min) the replacement for VLOOKUP - see how versatile and flexible XLOOKUP can be. FILTER Function (65 min) - learn how to automate filtering and make your file more interactive with the FILTER function.

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

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

See how to create 4 different dashboards in Excel. 1. Formula-based dashboard. 2. Sparkline charts plus conditional formatting. 3. Interactive dashboard using PivotCharts & Slicers. 4. Dynamic Arrays - the new way to calculate formulas - subscription version required. Extra chart courses included. Bonus - Chart Hacks - see how to create unusual charts Level: Intermediate Duration: 10+ hours Price: AU$100

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 plus two bonuses. Bonus 1: Macro to format a spill range. Bonus 2: Custom Functions and Range Names (80 min) course added. Version: Microsoft 365 Recorded: 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. Version: Microsoft 365 Recorded: due 22 May 2025 Level: Intermediate Duration: 1 hour Price: AU$25

See how to create different reports using dynamic arrays. These flexible reports automatically update and easily handle new accounts being added. Two separate reporting courses handling two different reports - plus a bonus dashboard course. Month and YTD report. Revised 12 Month report Dashboard Version: M365 Recorded: 2024 + 2025 Level: Advanced Duration: Over 3 and a half hours Price: AU$40

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

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

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

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

See how to use controls to improve the Excel user interface. Check boxes and option buttons can speed up and simplify selections. See how to use range names with controls. Versions: All versions Level: Intermediate Duration: 3 hours Price: AU$25

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. Version: All Versions Recorded: Apr 2020 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

Learn about the most useful and powerful functions Excel has to offer. Functions covered include XLOOKUP, VLOOKUP, SUM, SUMIFS, SUMPRODUCT, IF, INDIRECT, COUNTIFS, INDEX and MATCH. Includes an introduction to dynamic arrays. Level: Intermediate to Advanced Duration: 15+ hours Price: AU$110

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

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

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

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

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

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

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

Includes registration live webinar Thu 29 Oct 1pmAEST. 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 Version: M365 subscription Recording: due Oct 2026 Level: Advanced Duration: 75 min Price: AU$25

Includes registration to live webinar Thu 22 Oct 1pm AEST. Dynamic arrays change the way Excel reports are created. See how to apply dynamic arrays to a Month + YTD report. The session covers. - automatically inserting new accounts - filtering the report - adjustable account sequence - hiding rows using a Slicer Version: Microsoft 365 Recorded: due Oct 2026 Level: Advanced Duration: 1 hour Price: AU$25

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$410 value for AU$255. Most courses require the subscription version of Excel. Topics include. - Power Query, Budgets - Range Names, Dynamic Arrays - Reporting solutions, Tips & Shortcuts - XLOOKUP - Macros Over 30 hours of practical Excel Training. All courses include a Certificate of Completion. 3 month payment plan available. Scroll down to see all the courses.

The FILTER function automates filtering and allows you to better add user interaction to your spreadsheet. Topics: • FILTER function basics • Handling errors • AND vs OR comparisons • Using wildcards characters • Using TRIMRANGE • Working with functions • Using checkboxes Version: M365 Recorded: August 2026 Level: Intermediate Duration: 65 minutes Price: AUD25

Excel's formatted tables are a powerful data feature, but structured references have a few issues. This session looks at solving those issues with range names. In the process providing more flexibility and interaction when referring to columns in a formatted table. Version: M365 Recorded: July 2026 Level: Advanced Duration: 90 min Price: AUD25

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

See how the INDEX and XMATCH functions work together to create flexible Excel formulas. See how they can handle structures that other lookup functions can't. Topics covered: • Create flexible lookup formulas. • Handle dynamic arrays and tables. • Build month, YTD and moving average reports. • Manage errors clearly. Version: M365 Recorded: September 2026 Level: Intermediate Duration: 60 min 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

Learn practical ways to make Power Query more flexible by letting users choose filters, files, folders and date ranges directly from Excel, using range names, parameter tables and reusable functions. Topics covered: • Use range names to capture entries • Build a parameter table to centralise interactions • Create reusable functions Version: M365 Recorded: Sep 2026 Level: Intermediate Duration: 1 hour Price: AU$25

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

Essential macro courses in one bundle. You get the 2025 versions Macros 1 - Recording tips, Tricks + Traps - 1 hr Macros 2 - Recorded to remarkable - 90 min Macros 3 - Interaction + debugging - 90 min NEW - Macro Shorts 1 - short useful macros - 1 hr BONUS Macros 8 - VBA Variables recorded in 2024 - 75 min Version: All versions Recorded: Nov 2025 Level: Intermediate Duration: 6+ hours Price: AU$60

Start with the basics and progress to real programming. This course assume no previous programming experience. You start with recording macros and work towards creating your own code. See how to automate tasks so you can save time and effort. Macros can make you more productive. Level: Intermediate Duration: 5+ hours Price: AU$59

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

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; 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: Nov 2025 Level: Intermediate Duration: 80 min 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

Includes registration to live webinars in October 2026. Special bundle pricing AU$35 for October 2026! Save AU$15! 2+ CPD hours. See how dynamic arrays change the way Excel reports are created. Thu 22 Oct 1pm - Month and YTD Report (75 min) - Automatically insert new accounts plus change their sequence. Thu 29 Oct 1pm - 12 Month Report (75 min) - Build a 12 month report and choose between budgets or forecasts.

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

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 about range names and see how to simplify formulas & speed up formula creation. Lots of shortcuts and tips and tricks. This session covers • 3 ways to create names • rules + suggestions • shortcuts • name intersections • formula-based names Version: M365 Recorded: September 2026 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

Learn powerful techniques to make your Excel solutions more flexible. Range Name Essentials - learn the basics plus some advanced techniques INDEX & XMATCH Solutions - see how these 2 functions can solve complex problems Interactive Power Queries (NEW) - build-in interaction and flexibility Version: M365 - Subscription Recorded: Sep 2026 Level: Intermediate Duration: 1 hour each (3 hours in total) Price: AU$50

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

Learn all about range names. 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. Create your own custom functions with range names. Version: Microsoft 365 Recorded: Aug 2022 Level: Intermediate to Advanced Duration: 3.5 hrs with 1+ hrs bonus Price: AU$49

Over 11 hours of video, detailed pdf manuals, example code, bonuses and quizzes. Level: Intermediate Duration: 11+ hours Price: AU$139

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

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

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

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

XLOOKUP replaces VLOOKUP, HLOOKUP and INDEX-MATCH as the best lookup solution. See how to: - handle #N/A! errors - look from the bottom up - return a reference - return multiple columns - do wildcard searches - two-way look ups - two-column lookups - use regex patterns - look up and return a spill range Version: Microsoft 365 Recording: August 2026 Level: Intermediate Duration: 70 minutes Price: AU$25