Excel Sequence Function

Publié le: 14 septembre 2021
sur la chaîne: Excel Olympics

16,886

266

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

Sur cette page du site, vous pouvez voir la vidéo en ligne Excel Sequence Function durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Excel Olympics 14 septembre 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 16,886 fois et il a aimé 266 téléspectateurs. Bon visionnage!