Excel Yourself/Dynamic Arrays Basic Functions 2025

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

Contents

Materials

The session materials

  • a pdf manual which you can print out and make notes in

  • Excel file to work through during the session

  • the completed file to review if you need to

Dynamic_Arrays_Basic_Functions_2025.xlsx
Dynamic_Arrays_Basic_Functions_2025.pdf
Dynamic_Arrays_Basic_Functions_2025-completed.xlsx

Session Recording May 2025

Dynamic-Arrays-Basic-Functions-20250520.mp4

Quiz

Test your new found knowledge with these 10 questions.

Dynamic Arrays - Basic Functions Quiz