Date: | 23/04/2024 |
---|---|
Time: | 1:00 PM AEST |
Event: | Dynamic Arrays - Intermediate Functions |
Topic: | Dynamic Arrays - Intermediate Functions |
Public: | Public |
Registration: | Click here to register. |
Webinar – Dynamic Arrays – Intermediate Functions
Price: AU$25
This is the third in the series and the second to focus on dynamic array functions.
This session requires the subscription version of Excel.
This session covers.
- new dynamic array functions explained and demonstrated
- LET, LAMBDA, BYROW, BYCOL, TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK and HSTACK
- see how to summarise a formatted table
- learn techniques to split and join text
- discover array syntax what it is and how it can be used
- see how to combine multiple ranges in a single formula
As always, I will share a few other tips along the way.