7 ways to insert Automatic Serial Numbers in Excel

DataCense
DataCense
11.2 هزار بار بازدید - 3 سال پیش - In this video we talk
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 Facebook: datacense
Twitter Twitter: datacense
LinkedIn LinkedIn: datacense
Instagram Instagram: datacense32
3 سال پیش در تاریخ 1400/05/19 منتشر شده است.
11,285 بـار بازدید شده
... بیشتر