Welcome friends, in this video we are going to learn some
basic formulas of excel we do right, we do sum, we do
subtract, we do multiply, we do divide so we are going to
do all these things in this before that what we are going
to see is like we saw this cell in the last video we
understood what is a cell in these cells what we are going
to do is we are going to enter the data after entering the
data we are going to perform some operations on it right,
so first of all we understand that suppose
put some data here 1 after that what you have to do is you
have to press enter if you press enter then you will
automatically come down if you put data again in the second
cell and then enter then you are in the third cell put 3
and enter, put 4 and enter put 5 and enter what is this
going on? this is going from top to bottom now suppose I
have to go from left to right
I have to go from column A to column B so what should I do?
we saw this row that I have to come from the first row to
the second row so I entered like now I am in the 6th row in
the 6th row I put 8 now what I have to do is
I have to come to the 7th row so how will I come to the 7th
row?
I entered, the symbol came now I have to go from column A
to column B so what should I do? so in your keyboard there
will be a tab button you click that button if you click tab
then what will happen that you will come to the second
column from the left column or the first column like I came
to the B column here I put some data here I put 8 after
that what I have to do
I have to go to the C column so how will I go to the C
column?
I tab again understood when to use enter and when to use
tab when I have to come from one row to another then what
will I use?
I have to come from this row from the 7th row to the 8th
row what will I do? I will press enter
I will click enter when I have to shift from one column to
another then what will I do?
I will press tab these two things are clear after this what
we see
I will tell you a shortcut what we saw in the last video
that I had some recent files now if I want to open those
files then how can I do?
I will tell you a shortcut control plus o when you open
control plus o what it shows you? it shows you those files
we have seen these files earlier roll number file, book
file how to create a backup file where we have seen these
files? we have seen this in recent so what we can do by
pressing control plus o we can open these files directly
after that we go back we open the roll number file we open
it
After this, I have two things If I go to the file tab
What is the difference between save and save as?
When I put any data
Let me show you
This is the data I have put I save it as 6
And then I enter it as 7 Then I enter it
So, all the data I have put
If I save it directly
Then what happens is
The file with the roll number
Which is my existing file
In that, I save the data But what I want is
This should be the data
But there should be a little more detail
Like what I do in this file I also write the name
So, everything else was the same
I know that everything is same 1,2,3 accounts are same but
in this file I have added one more name so now if I save
this file it will be saved in first file but I don't want
to save in first file, I want to save a new file so I will
go to save as option it will be saved in first file now it
will ask you where do you want to save this file you can
save it in one drive or in your pc or you can browse if you
want to save your file online then you can do it in one
drive here you can see your drive
You can store your files in these drives
For example, if I want to store it on the desktop
I will do it for the desktop
Here I change the name of this file
Okay And what I do to this file
Rahul.xlsx So what happened here? I saved it.
so now what happened now let's do ctrl-o again and see if I
have that file or not
I did ctrl-o so see I have file of roll number and file of
Rahul
I open the file of roll number so this is the data and when
I open the file of Rahul so what will happen this data will
be there and
Rahul will be there so we understood that how we copied one
file and in that copy file we put some more data ctrl-o
again if I press here let's see the Rahul file
Rahul is there so we understood the difference between save
and save as now here you can see these columns like this if
you want to enter data in any cell so what you will do you
just have to click on cell you don't have to double click
you just have to single click and you can remove the data
like this cell B if I want to write my full name when you
will edit in this cell when you will double click if you
will write for the first time then you will single click
like I want to write my full
so when I will write my full name
so what is this? we can see that the size of the cell is
going out of the size of the cell so how will we solve
this? so let me tell you that this cell or this column like
this is column B in column B this cell is A1 in this A1
cell the name is written is going out of the cell so I can
increase or decrease the size of the cell so what I will do
I can increase or decrease this column or I can increase or
decrease this row so how will I increase or decrease the
column see in between B and C when you take the cursor of
your mouse an arrow sign appears what you have to do you
have to press the left button of your mouse and drag it to
the right hand side the size of the column B has increased
now the whole data is coming out in the same way if I want
to increase the size of the rows so what I will do
I will take the cursor of my mouse in between the rows
again the arrow sign will appear
I will click it and drag it you have to press it you will
see the size of the row has increased so I can increase the
size of the row
I can increase the size of the column
I can increase the size of the column in the same way if I
want to decrease the size of the row so how will I decrease
similar here
I have decreased the size of the row and here again in
between the rows in between the rows what I have seen
I have seen the arrow
I have held it
I have pressed it the left button of my mouse and I have
moved it up and I have seen that it has come in the same
size so we have understood that we can increase or decrease
the size of any row or column now I will remove this data
we had discussed that we will discuss the basic formulas ok
you watch
I will delete all this and enter the data again
So, what you have to do, when we are on the home tab, you
will see this option of O2Sum
If we see the rest of the options on the side of O2Sum, you
will see Sum, Average, Count Number, Maximum, Minimum and
More Functions
In More Functions, you will see Count, Sum, F, Sin and many
other functions
So, let's see these functions one by one
I will show you 2-3 functions and then you can try the rest
of the functions Suppose, I have put the data here, I have
to sum it, so I have put the data 23
What I have to do, I have to enter, remember, because I am
coming to the next row
I entered, then I put 34, then I put 56, then I put 67
Now, I need the sum of the data that I have put in these 4
rows Where do I need the sum? I need it in a cell, so you
have to leave one cell empty
We came to this cell, now what I have to do, I have to go
to this option and do O2Sum See, it will automatically do
O2Sum and what I have to do, I have to enter
What did I get? I got the result, 180
Did you understand how to do it? Now, let's see more
Now, I came down, I came from Enter to the 6th row
Now, I see the options here, what else do I have? I have
Average How many numbers do I have? I have 5 numbers
We know the formula for 5 numbers, what is the formula for
Average? Whatever 5 numbers I have written, sum those 5
numbers and divide by 5
So, what I will do, I will click on Average
So, what will it do automatically?
It will select those 5 cells and it will give us the Average
What do we have to do? We have to press Enter
We pressed Enter, we got 72 Average
We understood how to do things
Now, see here, in the formula bar, Average is written, A1
is written, colon A5
We will understand what is this thing and how can we do it
manually
right now we are trying to do with options so we understood
these things that what we do now next
I pressed enter I came to next cell let's see what options
are there in next cell let's see count numbers count number
is basically whatever data is there in my cell it will
count and tell 23 is one data 24 is second data 56 is third
data 67 is fourth data 180 is fifth and 72 is sixth if I do
count number what should I get? 6 let's see what number I
got? 6 so we understood what does count function do what
does sum function do what does average function do after
this max and minimum what does
and minimum do
I come here now in any cell you can show your data like I
show you in this cell now here I know what is maximum? 180
now what I do let's see maximum so I went to option and
clicked on max so what should I get in result? I should get
180 in result and what I got in result 180 now I have to
see minimum what is minimum? 6
I came to this cell suppose you came to this cell you came
to this cell you have to see in this cell what is minimum
so you came here
remember that it is not showing on this cell why it is not
showing? because it is not in this column so you have to
remember this thing that where your functions will work
automatically in which cell you are so I can't write here
let's remove it
But I know that
in this column A in this column A like in this cell it will
work here but here it will not work on other cell
I went here
I know this is my column A in this column A this cell will
work if I want to know minimum so what I will do, I went
here again
I clicked on min and it is taking me from A10 to A13 it is
taking me from A10 to A13 what I want, I want minimum so I
will select it again
I will remove it
you can also do like this by selecting all these you have
selected all now by selecting with mouse and here again I
have clicked on minimum so I have got 6 so it is clear that
we have auto sum functions auto means to do things on your
own now automatically what all things we have done we have
done average we have seen count numbers maximum and minimum
here are more functions you can explore these more
functions if you want to know other functions what are the
functions of mine you can see here
but there is an exception in this you have to remember that
suppose this is my data it is working on numbers now I used
my brain and I thought let's put an alphabet here so I put
R and what I do is
I selected all these and now I put SUM on it ok for this I
have to take a cell and an extra cell ok so I took an extra
cell and what I did is
I put SUM on it now it is showing me a 6 it is not a 6, it
should be a whole number ok so it showed me the results
because I have taken an alphabet so you have to remember
this you have to put a numerical number if you want SUM
because all these functions don't work on alphabets they
will work on average and my average function will work on
when my numerical data is written ok so I hope you
understood how functions of O2SUM work that's all for today
in the next video we will see other things
then keep practicing [Powered By Dubverse]