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 https://www.youtube.com/playlist?list=PLh9toghm2mYaXDax0HN-Cr4EMjQ31cQSa Excel: Check this playlist for Excel-related things https://www.youtube.com/playlist?list=PLh9toghm2mYbPBpxYyfUeW_l3WoNndRGV Keyboard Shortcuts: Check this section to save some time in everyday excel work https://www.youtube.com/playlist?list=PLh9toghm2mYbDImYvh3s-t5f-3CsNEJOP Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports https://www.youtube.com/playlist?list=PLh9toghm2mYaet-gozKg2hiyJ5M_Ypn7G Power Query: Check the Power Query playlist for Data Preparation & its Automation https://www.youtube.com/playlist?list=PLh9toghm2mYaoWN8xwis8aWlU0lpUUQoy Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations https://www.youtube.com/playlist?list=PLh9toghm2mYZH_Kohxk_-LCdS4UnwpK0o Please subscribe to our channel and Follow us on other social media platforms for regular updates : Tiktok https://vm.tiktok.com/ZSH28XEt/ Facebook https://www.facebook.com/datacense Twitter https://twitter.com/datacense LinkedIn https://www.linkedin.com/company/datacense Instagram https://www.instagram.com/datacense32