Complete Range Names 2025

Learn advanced range names techniques. See how to simplify formulas & speed up formula creation. Learn different ways to create ranges & how to use naming conventions to make formulas easy to copy & amend. Version: Microsoft 365 Recorded: April 2025 Level: Advanced Duration: 75 min Price: AU$25

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

Learn about range names and see how to simplify formulas & speed up formula creation. Discover different ways to create ranges & how to use naming conventions to make formulas easy to copy & amend. Version: All Recorded: April 2025 Level: Intermediate Duration: 1 hour Price: AU$25