Login
Excel Yourself/Dynamic Arrays Bundle 2025
Buy now

  • $60

Dynamic Arrays Bundle 2025

  • Bundle
  • 6 Products

Dynamic arrays are a game changer for creating formulas in Excel. This dynamic array series has four courses and two bonuses. Bonus 1: Macro to format a spill range. Bonus 2: Custom Functions and Range Names (80 min) course added. Includes live webinar registrations in May 2025. Version: Microsoft 365 Recorded: due May 2025 Level: Intermediate to Advanced Duration: 5.5 hours Price: AU$60
Buy now

Contents

  • $5

Bonus - Dynamic Arrays - Macro to format spill ranges

  • Closed
  • Course
  • 2 Lessons

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

  • $25

Custom Functions and Range Names 2025 (80 min)

  • Course
  • 5 Lessons

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

  • $25

Dynamic Arrays Advanced Functions 2025 (75 min)

  • Course
  • 5 Lessons

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

  • $25

Dynamic Arrays Basic Functions 2025

  • Course
  • 5 Lessons

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

  • $25

Dynamic Arrays Intermediate Functions 2025

  • Course
  • 5 Lessons

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. Includes live webinar registration 22 May 2025. Version: Microsoft 365 Recorded: due 22 May 2025 Level: Intermediate Duration: 1 hour Price: AU$25
View product

  • Free

Dynamic Arrays Introduction 2025

  • Course
  • 5 Lessons

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