Dynamic Arrays Introduction
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 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
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