SEQUENCE Function in Excel - Introduction + 2 Awesome Examples
11.8 هزار بار بازدید -
3 سال پیش
-
In this video, we look
In this video, we look at the SEQUENCE function in Excel, a truly brilliant function.
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 along - https://www.computergaga.com/_excel/f...
These are the timings in the video.
00:00 - Introduction to the SEQUENCE function in Excel
02:07 - Rows and columns argument
02:32 - Start and step arguments
04:50 - TRANSPOSE function with SEQUENCE
06:35 - SEQUENCE to sum the last 7 days values
09:13 - Sum the top N values
Find more great free tutorials at;
https://www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1
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 along - https://www.computergaga.com/_excel/f...
These are the timings in the video.
00:00 - Introduction to the SEQUENCE function in Excel
02:07 - Rows and columns argument
02:32 - Start and step arguments
04:50 - TRANSPOSE function with SEQUENCE
06:35 - SEQUENCE to sum the last 7 days values
09:13 - Sum the top N values
Find more great free tutorials at;
https://www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► LinkedIn: 18737946
Instagram ► Instagram: computergaga1
Twitter ► Twitter: computergaga1
3 سال پیش
در تاریخ 1400/08/13 منتشر شده
است.
11,873
بـار بازدید شده