In this 1 minute Short video on Excel Tips & Tricks, we discuss the SEQUENCE Function in Excel.
Excel’s SEQUENCE Function is used to generate an array of sequential numbers such as 1, 2, 3, etc.
SEQUENCE(rows, [columns], [start], [step])
rows (required) – Number of rows to fill
columns(optional) – the number of columns to fill. If omitted, the default is 1 column.
Start (optional) – the starting number in the sequence. If omitted, the default is 1.
Step (optional) – the increment for each subsequent value in the sequence. It can be positive or negative.
If positive, subsequent values increase, creating an ascending sequence.
If negative, subsequent values decrease, producing a descending sequence.
If omitted, the step defaults to 1.
The function is an array function i.e. the result automatically spills into the neighbouring cells
Excel’s SEQUENCE function generates a list of sequential numbers in an array, that can be one dimensional, or two-dimensional, controlled by rows and columns arguments, it can also handle different starting points and increments
My other videos on Using Excel 👇
YOUTUBE SHORTS
⚡ UNIQUE Function https://youtu.be/VXcDLOjOuhg
⚡ SORT Function https://youtu.be/kIO0E6vPvis
⚡ FILTER Function https://youtu.be/ha4XoB1JkHw
⚡ SORTBY Function https://youtu.be/NVpO7Voi1ck
⚡ SEQUENCE Function https://youtu.be/HeqMwqWdqyQ
TOP 10 EXCEL TIPS in Hindi/English Series
#1 Quick Access Toolbar https://youtu.be/OOuvqvSH8A8
#2 Keyboard Shortcuts https://youtu.be/tu52UdJR5MM
#3 Custom Sort https://youtu.be/sThclPC2AIU
#4 Horizontal Sort https://youtu.be/DHKrDDYq_1o
#5 Go to Special https://youtu.be/SofqWqJu27E
#6 Advanced Filter https://youtu.be/QD_lCjqI1us
#7 Table https://youtu.be/IVGIBq7tY6I
#8 Subtotal https://youtu.be/AnEfgHP4g90
#9 Consolidate https://youtu.be/WERAbDJ3ga8
#10 Flash Fill https://youtu.be/PpDr4JPdT5U
Excel Tips & Tricks- Hindi
#Pivot Table https://youtu.be/KFJJIRPytPg
#80/20 Rule with Pivot https://youtu.be/N5_oTaD2bJI
Excel Productivity Hacks
◾Autofilter, Flash Fill https://youtu.be/IGjw-YFHvLU
◾Using Tables https://youtu.be/nKJdgFtjZ_E
◾Consolidate https://youtu.be/7AwJLMJ6OeE
◾TEXTJOIN https://youtu.be/o-7uLzl7J6k
◾SUBTOTAL https://youtu.be/01rrV7_fw64
◾SUBTOTAL Outline https://youtu.be/tVhdN9orSQ8
◾Evaluate Formula https://youtu.be/-6iSLH-x8b0
◾ANALYZE DATA https://youtu.be/KnkkVStpr_Q
◾CONDITIONAL FORMATTING-1 https://youtu.be/wAW1v5XlLUI
◾CONDITIONAL FORMATTING-2 https://youtu.be/9L6dmsEGNzY
3 Simple Powerful Tools for Tax Audit 🎯
#1 Excel https://youtu.be/bGzoTGtdNb4
#2 eCAAT https://youtu.be/3vl4KXyuO44
#3 MDA Audit Tool https://youtu.be/V_alqesIUhI
Excel as an Audit Tool https://youtu.be/Ne3w6Jj2ZSU
The Data Analysis Story with Excel https://youtu.be/0ZUxLCDUNsc
Analytical procedures using Excel https://youtu.be/Nd2OnCrl34M
Bank Audit Series
Part 1: How to convert bank reports to Excel
Part 2: How to use Filter in Excel to analyse Loan Balance Report. https://youtu.be/4Z6W40gSWOA
Part 3: How to use the Power of Pivots to analyse Loan Balance Report. https://youtu.be/whdEZDSdoIM
Bank Audit in Computerised Environment
1. Thumbs up, if you learned something new today. 👍
2. Subscribe to get regular updates on Excel.
3. Comment below with your biggest takeaway from this video.
#SEQUENCE ,#Dynamicarrayfunctions, #Exceltips, #Exceltraining, #SEQUENCEFUNCTION #msmehta, #auditwithexcel, #charteredaccountant, #Advancedexceltraining, #Advancedexceltips, #Advancedexceltips, #MicrosoftExcel, #ExcelTipsandtricks
🚩 Connect with me
✅Website: https://www.msmehta.com
✅Email: msm@msmehta.com
✅LinkedIn: https://www.linkedin.com/in/manmeetmehta
🔔Subscribe to my YouTube channel: https://www.youtube.com/c/ManmeetSinghMehta?sub_confirmation=1
