7 ways to insert Automatic Serial Numbers in Excel
In this video we talk about 7 different ways to add serial numbers in excel.
Serial numbers are like salt. You never feel their presence but their absence makes your data tasteless.
Because with a serial number you can have a unique identity to each entry of your data and you also get a sense of how big or small is your dataset.
But the sad news is, adding them manually is a pain. It’s really hard to add a number in every row one after another.
The good news is, there are some ways which we can use to automatically add serial numbers in a column.
Download the practice file from the link below
https://bit.ly/2VKThRl
Chapters in the video
00:00 Intro
00:58 Fill Handle
01:27 Fill Series
02:11 Add 1 to the previous cell
03:00 ROW Function
03:48 COUNTA Function
04:35 SUBTOTAL with COUNTA
05:45 SEQUENCE Function
07:13 Subscribe, Like , Share
Also, check these videos if you want to learn more
1 Min Excel: If you enjoy short videos check this section
• Shorts : Random
Excel: Check this playlist for Excel-related things
• Excel
Keyboard Shortcuts: Check this section to save some time in everyday excel work
• Excel Keyboard Shortcuts
Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
• Pivot Tables
Power Query: Check the Power Query playlist for Data Preparation & its Automation
• Power Query
Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
• Power BI
Please subscribe to our channel and Follow us on other social media platforms for regular updates :
Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook / datacense
Twitter / datacense
LinkedIn / datacense
Instagram / datacense32
Watch video 7 ways to insert Automatic Serial Numbers in Excel online without registration, duration hours minute second in high quality. This video was added by user DataCense 10 August 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 18,085 once and liked it 163 people.