What are excels 7 new dynamic array formulas
Автор: Karina Adcock
Загружено: 2019-02-27
Просмотров: 13120
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 • Excel's new dynamic array FILTER formula
How to make a dynamic heat map in excel • How to make a dynamic heat map in excel - ...
Find the top 5 values in excel - dynamic array formulas & original formulas • Find the top 5 values in excel - dynamic a...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
