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: [ Ссылка ]
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 - [ Ссылка ]
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! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek
Excel Sequence Function
Теги
excel sequence functionsequence functionmicrosoft excelmicrosoft excel tutorialsnew excel functionsadvanced excel tricksmicrosoft excel tutorialsequence function in excelsequence function exampleexcel tips and tricks 2021microsoft 365excel 365Dynamic ArraysDynamic Arrays in ExcelNew Excel FunctionsModern ExcelMaking Excel Dynamicexcel functionsArray Functions in ExcelSimulations in ExcelGašper Kamenšekexcel olympics