Login
Excel Yourself/August 2026 Webinars
Enrollment is closed

  • $35

August 2026 Webinars

  • Closed
  • Bundle
  • 2 Items

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.
Buy now

Contents

  • $25

FILTER function

  • Course
  • 6 Lessons

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

  • $25

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