Published On Sep 14, 2021
In this video, You will learn how to use the SEQUENCE function in Excel. I will demonstrate the use on several Real Life examples that you should be able to convert to your needs in no time.
This tutorial was made using Excel 365 and since the SEQUENCE function is one of the new Dynamic Array Functions in Excel it is only available in Excel 365.
Blog Post on the Topic: https://bit.ly/3EjTNXU
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction to the SEQUENCE function
1:21 Simple Examples
2:38 Combining with other Excel Functions
3:25 Creating a Date SEQUENCE
5:11 Dynamic Calendars Using SEQUENCE function
7:07 Single Column sorting of Values
9:09 Transformations using SEQUENCE function
12:00 Food for Thought
15:00 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! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek