In this video, I will show you everything you need to know about the sequence function in Excel. I'll also cover eight different scenarios where you can combine the SEQUENCE function with other Excel functions to do some amazing things.
00:00 Intro
00:34 SEQUENCE Function in Excel
03:54 Getting Dates (with gap/repetition)
06:36 Getting Workday Dates
09:46 Get List of Specific Weekdays
11:07 Get 30-Min Time Slots
12:40 Filter Every Nth Row
14:49 Sum Top N Values
16:07 Repeat Lists
19:00 Create One Formula Calendar
➡️ Download File: https://www.dropbox.com/scl/fi/wrve41xw91so2gai8z50n/Sequence-Function-in-Excel.xlsx?rlkey=3wv1my9ekrh8apelmgt6gk63t&dl=1
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://trumpexcel.com/excel-vba-course/
✅ Free Power Query Course - https://trumpexcel.com/power-query-course/
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial #SumitBansal