Hi, everyone, in this video, we are going to cover basic mathematical operations and by the end of
this video, you will be able to appreciate the fact that Excel makes it very easy to do repetitive
mathematical operations.
Let's start.
Modeselektor, I'll be working on this workbook.
We have a table here of two columns containing numbers.
Here are the tasks that I have to perform.
My first task is to add the two numbers and write them some in the column by some.
Then in the fourth column, I will add the two numbers and I will add a constant as well.
This is the content that will be adding along with these two numbers.
In the fifth column, we will multiply these three numbers and in the last column we will find the average
of the three numbers.
All in all, for these 10 rows of numbers, I have 40 cells to be filled.
Looks like a big task.
Even if we use a calculator, it may take us 15 minutes to do this, maybe even more.
Don't worry in it, it won't take that long.
Let's see how.
First, we want to add two numbers for this, we need to write a formula because a calculation is to
be done.
A formula starts with an equal to Simbel.
This symbol is Excel, that the calculation is to be done in this cell, so we rate is equal to click
on the fossil for the plus symbol and then click on this.
You can see that the two cells part of this formula are highlighted in colored boxes.
Now, when I hit Enter, Excel will calculate the value from the formula and it hit.
If you click the cell, you can see that formula is still showing the actual formula, but this certainly
showing the calculated value of the formula.
If you want to edit the formula.
You can either do it in the formula bar or double click on the cell and then edit the formula.
Now, you may have this question in mind.
Why in the formula did we add two cells?
Why is it A two plus B two and not five plus six?
Well, if we write five plus six, even then we will get the same answer.
But using cell reference that is writing A two plus B two gives us additional benefits.
The first benefit is that this makes the cell dynamic changes.
For example, if you update this number, 250.
Then you need not correct your formula in your formula will add the updated content of these two cells
and to you, the new ones that had you written five plus six initially, you would need to rectify this
formula every time you make any changes to these two numbers.
The second benefit is simply amazing.
Exxon offers a functionality of extending cities and formulas from one cell to the other.
If you go to the bottom right corner of this cell, you will see that the cursor changes to a small
symbol.
Click and hold and no drag don't you'll see this black border extending to the next cell, you can extend
it as far as you like to.
But first, let's see what happens with this one cell in this cell.
You can see that the sum is calculated in the formula, but you see that automatically it is adding
A3 and Betadine not.
We entered the formula in C2 four, adding A2 and B2, but when we extended the formula, it was automatically
updated to A3 and beat.
The logic followed is that when you extend the formula to the next row, all these references are updated
or the next group.
Same holds four columns.
If I extend the formula to the right, that is to the next column.
All references will point to the next column in the new formula.
Let's see this and they in the right.
Here, the formula in today's E3, plus I thought if I extend this formula to the right.
The new formula states Dadri plus G4, that is when they extend the formula to a decent cell, which
has a new column number, all the cell references in the formula are changed accordingly.
So can you see the power now to fill this entire column?
I need not add 10 times.
Just write the Formula One and drag it to all the other cells and it's done.
You can see this column is very.
For the next column, we have to add three numbers.
Number one, number two and the constant.
Let's state the formula for that.
Is equal to Itou plus BE2 plus this constant.
I would like to extend this formula to other cells in this column, but we may extend it.
The road reference is updated for all the cells, it becomes a tree.
We do because we try and be 13 will be 14.
Two becoming three is OK for me here, but I do not want this 13 to increase to 14 because my constant
stays in cell B 13 only.
To stop this from happening, that is to stop the differences, to be updated, we can use dollar symbols.
Let me show you how in this formula A is referenced using Collum name and Ronney, if you track the
formula down through the name is updated rule name is the number.
So two becomes three.
If you put a dollar symbol, dollar symbol as the symbol that you find over the keyboard.
Number four.
So if you press shift and then press presto, you'll get a dollar symbol if you add a dollar symbol
in front of the name.
And then break down the formula.
You will notice that that cell reference, which has a dollar symbol in front of it, will not be updated
and will be logged.
So if you compare the formula in to Andrew three, it becomes Edri veto becomes Vetri, but B 13, status
B 13.
This is because 13 was logged with their dollars and.
Let's extend it to all the cells in this column.
You can check it is working fine for all the things we can do the same thing for Collins, also for
columns, then we drag the formula from left to right.
Column names are changed.
Putting a dollar symbol in front of column name will block it.
So now if I extend this horizontally, you'll see that it becomes Dadri.
Ifour becomes G4 A six becomes G six.
I want A6 to remain as A6 and not become desex.
So I will put a dollar symbol.
Here in front of A6.
This means I will be locked, so when I extend this formula horizontally.
Here you will see J3 plus dofor plus icings.
What if we put a dollar bill on board?
Probably you guessed it right, if you put a dollar bill on board, the wrong name and the name board
will not change regardless of where you move the formula.
Now, in the next two columns, we know what to do, let's write the formula first for product, we
will select the first number.
The multiply symbol is the aesthetic, which can be found on number eight in the keyboard with number
two.
Multiplied with the number three with dollars and, well, in front of the low number.
And in the average column.
We need to add the three numbers first and then divide them by three to the average.
So since we have to add the three numbers, first, we will write some in the brackets, so within bracket
number one.
Plus number two plus.
This constant symbol.
We'll close this bracket and divide this total sum that three.
Now, in this fourth column, we can also use the sum calculated in the column B in the column, we
already have this so we can straightaway use this value and divide it by three.
So instead of writing this formula, we can also write is equal to the two, divided by three.
So the formulas are written in these two cities.
Now, here's another handy trick you can select, but this is.
Go to the bottom right corner and double click.
When you double click, it automatically fills it up for the entire table so you don't have to click
and hold the bottom right corner and drag it to the entire table.
You can just go to the bottom right corner and double click and the entire table will be.
I hope you can now see how it increases productivity in tasks which involve repetitive calculations
in the coming videos.
We will see other functions, mathematical textual logical functions that are commonly used to perform
complex tasks in.