September 2026 Webinars

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

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