Excel Live Training Registrations
Learn new Excel skills and techniques in your lunch hour. See how to save time doing common tasks. Since 2012 I have presented over 500 live webinars to thousands of people worldwide.
All webinars include a detailed PDF instruction manual plus an example Excel file. All registrants receive access to the recording the day after the session. The next sessions, including free sessions, are listed below.
Join the Free Registration List to always be registered for the free sessions.
Webinar: PivotTable Essentials 2025
10/10
I always learn something. Your courses are great.
J Stinson
December 2025
| DATE / TIME / DURATION | DETAILS | SKILL LEVEL | PRICE | LINKS |
|---|---|---|---|---|
| Be automatically registered for all my free webinars – use the Join Free List – link on the right. ➡️ The next free webinar will be mid-September 2026. See you online! | Join Free List | |||
****** SPECIAL LIMITED OFFER FOR AUGUST 2026 ****** TWO WEBINARS FOR AU$35 – use the Register link ➡️ Both the XLOOKUP and FILTER webinars for one low price – save AU$15 | Intermediate | AU$35 | Register | |
| Date: Thu 20 August 2026 Start time: 1pm AEST Sydney time Duration: 60 min Location: Online | XLOOKUP Function XLOOKUP replaces VLOOKUP and it allows you to solve previous impossible lookup challenges. XLOOKUP works well with dynamic arrays and offers solutions to challenging Excel problems. In this session you will – learn the basics of the XLOOKUP function – discover how easy it is to handle N/A! errors – see how to look from the bottom up – use XLOOKUP to return a reference – see how to use XLOOKUP with dynamic arrays – learn how to return multiple columns – discover how to do wildcard searches – see how to use regex patterns – learn how to do two-way look ups – discover how to do two-column lookups – see how to return a spill range from a lookup | Intermediate | AU$25 | Register |
| Date: Thu 27 August 2026 Start time: 1pm AEST Sydney time Duration: 60 min Location: Online | FILTER Function The FILTER function automates filtering and allows you to better add user interaction to your spreadsheet. It allows you to convert other functions to conditional functions like SUMIFS. FILTER works well with checkboxes. Topics covered include: – FILTER function basics – Handling errors – AND vs OR comparisons – Using wildcards characters – Using TRIMRANGE – Working with other functions – Using the LET function – Using checkboxes | Intermediate | AU$25 | Register |
| Be automatically registered for all my free webinars – use the Join Free List – link on the right. ➡️ The next free webinar will be mid-September 2026. See you online! | Join Free List |