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, SUMCOL, SUMROW and SUMDA. These SUM functions work with two-dimensional spill ranges. Version: Microsoft 365 Recorded: August 2022 Level: Advanced Duration: 1.5 hours 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: April 2024 Level: Advanced Duration: 1 hour 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. Examples include a loan schedule and a simple budget. Version: Microsoft 365 Recorded: April 2024 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: April 2024 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: April 2024 Level: Intermediate Duration: 1 hour Price: Free