1
00:00:01,600 --> 00:00:05,600
Hey this is puneet back again and in this 
video we will looking into three options 
that can save your lot of time while working 
in excel and let me tell you I personally 
use these tips every single day while working 
in excel so let's get started

2
00:00:05,700 --> 00:00:09,500
all right so the first option is aoubt using 
custom list custom list is basically a predefined 
list of values that you can save in excel 
and than you can use those values just by 
entering the first entry from the lsit so 
for example if I type and than if I drag 
this cell upto the row 16 I'll get rest of 
the enteries from this list so this list 
basically a list of names and the first entery 
is the first name that I can use as a header

3
00:00:10,600 --> 00:00:15,400


4
00:00:15,500 --> 00:00:20,300