In this recorded Excel tutorial, Excel expert, Deb Ashby, who took us through the Array Functions in Excel introduced in Microsoft a few years ago.

To download the Excel file and follow along, go here ️
https://www.simonsezit.com/article/dynamic-array-functions-in-excel-xlookup-filter-unique-xmatch-webinar-recording/

GET FOUR FREE COURSES ️ https://www.simonsezit.com/four-free-courses

These functions replace and improve upon some existing functions (XLOOKUP instead of INDEX, MATCH). In this Dynamic Array session Debs covers the following Excel Functions:

- FILTER Function in Excel
- RANDARRAY Function in Excel
- SEQUENCE Function in Excel
- UNIQUE Function in Excel
- SORT Function in Excel
- SORTBY Function in Excel
- XLOOKUP Function in Excel (including XLOOKUP vs. INDEX MATCH)
- XMATCH Function in Excel

This is a recording of a live training session held for Simon Sez IT members: ⏩https://www.simonsezit.com/membership/

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Excel beginners https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Excel 2021 Tutorials for Intermediate Users here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3

Microsoft Excel 2019 Advanced playlist: https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)