What are excels 7 new dynamic array formulas

Excel recently introduced 7 new dynamic spilled arrays: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY & SINGLE. In this video I show you what each of these new formulas can do. These formulas are currently only available on the Office Insider version of Office 365 or on Google Sheets. -------------------------------------------------------------------------------- #exceltutorial #excelformulas #exceldynamicarrays SUBSCRIBE: https://goo.gl/c46YPs Microsoft Office 365, 2016, Office Insider, Version 1903 --------------------------------------------------------------------------------- IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: - This video is part of a playlist: Excel's new dynamic array FILTER formula https://www.youtube.com/playlist?list=PLVe64sIb7fSaAgWWAn_Lvewj7H0gbKGWL - How to make a dynamic heat map in excel https://youtu.be/62G8edt2go8 - Find the top 5 values in excel - dynamic array formulas & original formulas https://youtu.be/5BLR0C9xjnQ