Hello everyone! I've a vast experience on MS Excel. I'm going to share some useful Excel Tips and Tricks with you.
Lets start from
#1. Serial Numbers
If you work with large data then it’s better to add a serial number column to it.
For me, the best way to do this is to apply the table to the data and then add 1 in the above serial number, just like attached photo
To do this, you simply need to add 1 to the first cell of the column and then create a formula to add 1 to the above cell’s value.
As you are using a table, whenever you create a new entry in the table, Excel will automatically drop down the formula, you’ll get the serial number.