Bonus Macro A macro that formats a spill range and runs off a shortcut key. ONLY AVAILABLE WITH THE DYNAMIC ARRAYS BUNDLE!

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

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

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces important concepts plus new symbols and functions to get you started using dynamic arrays. Version: Microsoft 365 Recorded: May 2025 Level: Intermediate Duration: 1 hour Price: Free