Excel Sequence Function
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
In questa pagina del sito puoi guardare il video online Excel Sequence Function della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Excel Olympics 14 settembre 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 16,886 volte e gli è piaciuto 266 spettatori. Buona visione!
