Watch this video if you want to understand how Dynamic Arrays have changed Excel forever and get a glimpse into the fantastic things you can now do in Excel. As this video is an Introduction to Dynamic Arrays in Excel, I will only show you four new functions in Excel. The SEQUENCE function, the UNIQUE and SORT functions, and the FILTER function. I guarantee that if you watch this video to the end, you will never see Excel the same.
This tutorial was made using Excel 365, and you do need Excel 365 for the Dynamic Array formulas to work.
Chapters:
0:00 Excel Olympics Animation
0:08 What are Dynamic Arrays
1:15 How Excel changed with Dynamic Arrays - Basics (NEED TO WATCH!)
6:15 The SEQUENCE function
10:12 The UNIQUE and SORT functions
13:11 The FILTER function
15:08 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - [ Ссылка ]
Microphone: AKG C3000 (Analog Mic) - [ Ссылка ]
Audio converter: Zoom UAC-2 - [ Ссылка ]
Laptop: Dell XPS 15 - [ Ссылка ]
Lights: Elgato Key Light - [ Ссылка ]
EU Links
Camera: Canon EOS R6 - [ Ссылка ]
Microphone: AKG C3000 (Analog Mic) - [ Ссылка ]
Audio converter: Zoom UAC-2 - [ Ссылка ]
Laptop: Dell XPS 15 - [ Ссылка ]
Lights: Elgato Key Light - [ Ссылка ]
Green Screen (visible in bloopers): [ Ссылка ]
Recorded With: Camtasia - [ Ссылка ]
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: [ Ссылка ]
Subscribe for the Excel Olympics Newsletter: [ Ссылка ]
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support!
#Excel #ExcelOlympics #gasperkamensek
Dynamic Arrays Introduction
Теги
dynamic arraysdynamic arrayunique functionfilter functiondynamic array formulas in exceloffice 365dynamic array formulasexcel array formulasoffice 365 vs office 2019sequence function in excelsort function in ExcelIntroduction to Dynamic Arraysexcel dynamic arrays tutorialexcel tutorialmicrosoft excel tutorialexcel tips and tricksExcel OlympicsGašper KamenšekExcel the Right WayEnter Data in ExcelBasics in ExcelExcel Olympics Channel