Date: | 18/04/2024 |
---|---|
Time: | 1:00 PM AEST |
Event: | Dynamic Arrays - Basic Functions |
Topic: | Dynamic Arrays - Basic Functions |
Public: | Public |
Registration: | Click here to register. |
Webinar – Dynamic Arrays – Basic Functions
Price: AU$25
This is the second in the series and the first to focus on dynamic array functions.
This session requires the subscription version of Excel.
This session covers.
- new dynamic array functions explained and demonstrated
- SEQUENCE, CHOOSECOLS, CHOOSEROWS, TAKE and DROP
- flexible loan schedule and flexible budget example
- Formatted tables and dynamic arrays
- Old functions that work well with spill ranges
- TRANSPOSE and INDEX
As always, I will share a few other tips along the way.