Dynamic Array Functions in Excel – Recorded Webinar
This recorded live webinar will walk you through dynamic arrays in Excel. Dynamic arrays allow you to work with multiple values simultaneously in a formula. This feature enables Excel formulas to return numerous results based on a single formula entered in one cell. The results are also dynamic, meaning that if the source data changes, the results will dynamically update.
In this month’s webinar, Deb discusses the following:
- What are dynamic arrays?
- UNIQUE
- FILTER
- SORT and SORTBY
- RANDARRAY
- Spill errors
- SEQUENCE
- Brand new dynamic arrays in Excel 365
- TEXTBEFORE, TEXTAFTER, and TEXTSPLIT
Watch the session here, and download the instructor demo files to follow along.
Dynamic Array Functions in Excel – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Excel Chart Formatting Tips and Tricks
Excel Bad Habits (and how to change them!)
Please visit our free Microsoft Office resources center for more high-quality Microsoft guides.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!
