August 2026 Webinars

Bundle
2 Items

Special bundle pricing AU$35 for two live Excel webinars in August! Save AU$15! Live webinars including their associated recordings and their on-line courses. 2 CPD hours. Thu 20 Aug 2026 - XLOOKUP Function - the replacement for VLOOKUP - see how versatile and flexible XLOOKUP can be. Thu 27 Aug 2026 - FILTER Function - learn how to automate filtering and make your file more interactive with the FILTER function.

Buy now

FILTER function

Course
3 Lessons

Includes live webinar Thu 27 Aug 2026 1pm AEST 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: Due 27 Aug 2026 Level: Intermediate Duration: 1 hour Price: AUD25

View product

XLOOKUP Function - 2026 (70 min)

Course
5 Lessons

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

View product