We will have an introduction to the SEQUENCE function and understand how it works. And then look at two real-world examples of SEQUENCE in action.
Advanced Excel Formulas – Learn Them ALL Today – https://amzn.to/3Rg87Go
You can download the Excel workbook to follow – https://www.computergaga.com/_excel/files/formulas/sequence.xlsx
These are the times in the video.
00:00 – Introduction to the SEQUENCE function in Excel
02:07 – Rows and columns argument
02:32 – Start and stage arguments
04:50 – TRANSPOSE function with SEQUENCE
06:35 – SEQUENCE to add the values of the last 7 days
09:13 – Add the first N values
Find more great free tutorials at;
https://www.computergaga.com
***Online Excel Course***
The Ultimate Excel Course – Learn Everything https://bit.ly/UltimateExcel
Excel VBA for beginners http://bit.ly/37XSKfZ
Advanced Excel Tips https://bit.ly/3CGCM3M
Simplified Excel formulas http://bit.ly/2ujtOAN
Creation of sports league and tournament tables in Excel http://bit.ly/2Siivkm
Connect with us!
LinkedIn https://www.linkedin.com/company/18737946/
Instagram https://www.instagram.com/computergaga1/
Twitter http://www.twitter.com/computergaga1
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments