hello and welcome to a new video and in this video we are
going to learn how to enter data but data we entered in
last video so what is different in this video you must have
heard about data entry many times so for data entry we have
to remember that we have to know how to enter data in
English and Hindi and that too in a fast way so this is a
requirement for data entry job so today we will see how to
fill data in a traditional way and how to fill data with
the help of a foam
I will also tell you about foam and along with that we will
also see how to add a tab inside a ribbon so we are going
to do all these things in this video so let's open excel
and we know how to open excel so I will press window plus s
and here I will put excel and I did this enter, excel came
in front of me open now here I bring a file and tell me
what is control plus o we can open file shortcut so I open
this file so inside this file
I have some data and here some subject is written
sociology, total inside this
I have to fill marks simple way to fill marks is to tell us
if we have to go left to right or we have to go top to
bottom so what do we use for this for example
I put 10
I put number now I have to go left to right so I will use
tab
I will not use enter
I put 10, then I press tab 20, tab, 30 tab, 40 tab, 50 then
I enter so one thing you have to notice when I put total 50
it didn't go inside G cell it didn't go inside next cell
inside G column it knows where it has to go back to history
but in this it takes time but we need to fill data fast
I put 20 30, still it takes time to fill data so we have a
solution which is to fill data with the help of form where
will we get form so we have seen what is ribbon so inside
ribbon let me revise what is ribbon this whole portion is
visible what I call this whole portion
I call it ribbon and inside this ribbon file, home, insert
page layout so all these are tabs some tabs are by default
insert tab page layout tab formulas tab but here such tab
is not visible
I can't see form tab with the help of which
I can fill data so first of all
I will add a tab which will be visible after view and after
that what I will do
I will fill data with the help of form let's see how it is
done so what I have to do
I have to go to file
I will remove this data
after removing this data what I have to do
I go to file section on file section let's make it bigger
so that you can see better let's make it this much now
visible and clear
I have to go to file section after going to file section
where I have to go option in the last option
I have to click on this and here I can see one option of
customized ribbon we have seen this ribbon in this ribbon
we have to do customization so I will click on customized
ribbon and here popular commands are written
I don't want all the commands from which
I can find and add a form so what I will do
I will click on all commands after clicking on all commands
what I have to find
I have to find where is the form so where will you find the
form in this section you should find the form so let's go
and here let's see where is the form
here I should find the form
file path full color
here I have found the form so what you have to do you have
to click on this form what you have to do here you can see
these main tabs tab of home, tab of insert tab of page
layout so you have to add the form here what we have to do
first of all we have to create a new tab to create a new
tab here you can see new tab option we can add it here drag
it what you have to do double click on it new tab is added
now I have to change the name of new tab basically you can
put any name here
I am putting Rahul name
I have put the name of this tab let's put it in capital
I have put the name of this tab
Rahul and the group we know the group what is inside the
tab like clipboard so what we have to do we have to enter
the data so we have to rename it and here data entry we
have to write data entry data entry
so here
I have created a group of data entry in which I have to add
the form
I will add the form here you can see there is a tab like
here what is inside it data entry and in that group you
will get the form so what we have to do here you can see a
new tab is added
Rahul name if I open the tab here I can see data entry in
which there is a feature called form let's see what it does
let's click it so now what you have to do you have to tell
what are my headings what are my headers where you have to
fill the data you have to fill the data here so what you
have to do you have to select all
I have selected all now what I have done
I have clicked on form now I have clicked on form it is
showing all the options so now what you have to do you have
to quickly fill the data
I have filled 10 and one more thing you have to remember
when I have filled the data you don't have to enter you
have to press the tab what will happen if you enter it will
leave the data let's close it again
I have to select all these things and from here
I have selected form and see here now what I have to do tab
20, 30 40 50 and now what I have to do
I have to enter so how I will do 1, 3 like this you can
fill the data after that enter again so what is this it can
fill the data in a little speed and which like in history
we have left it empty so there is nothing to worry what it
will do where you have not filled the data it will leave it
empty let's fill the data 8, 9, 7, 6 and enter so what is
this it is a little efficient method to fill the data with
the help of form so we have learned how to fill the data
with the help of form and fill
in a group.
You can fill data in all other cells.
I will do it in this group.
Close it.
We understood how to add tab in a group and how to add a
feature in a group.
So, this is all for today.
Keep practicing and see you in the next video.