This video looks at the dynamic arrays SEQUENCE function and how you can use this to generate a sequence in Excel. Dynamic array functions are available in versions of Excel from 2019 on. This easy beginners tutorial will help bring your spreadsheet knowledge up to the next level.
0:00 Introduction
0:24 Excel SEQUENCE function / excel sequential numbering
1:55 Excel sequence of numbers with negative values
2:12 Excel sequence numbers and letters (concatenate)
3:35 Excel sequence dates
4:51 Excel format date in formula
You can follow along with this video starting from a blank workbook!
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our playlist on dynamic array functions and formulas: [ Ссылка ]
Or check out the following videos:
- TEXT function: [ Ссылка ]
- DATE functions: [ Ссылка ]
- UNIQUE function: [ Ссылка ]
- CONCAT or TEXTJOIN: [ Ссылка ]
