Excel Yourself/Dynamic Arrays Basic Functions

  • $25

Dynamic Arrays Basic Functions

  • 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. Examples include a loan schedule and a simple budget. Version: Microsoft 365 Recorded: April 2024 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.xlsx
Dynamic_Arrays_Basic_Functions.pdf
Dynamic_Arrays_Basic_Functions_completed.xlsx

Session Recording (recorded April 2024)

Dynamic Arrays - Basic Functions - video

Quiz

Test your new found knowledge with these 10 questions.

Dynamic Arrays - Basic Functions Quiz