How To Create Formulas In Excel
The video is a tutorial on how to do basic arithmetic operations in Microsoft Excel. This video illustrates in detail about how to perform addition, subtraction and division using Microsoft Excel.
Hi, my name is Ghamza Jacobs and I'm an IT trainer with New Horizons in London, and I'm here today just to show you a couple of cool little tricks and tips on Windows 7 and Office 2010. How to do basic calculations in Microsoft Excel? When calculating in Microsoft Excel, one of the most important things to remember is you should always start with the equals sign on the keyboard. The equal sign lives next to backspace on your keyboard.
So we position our active cell, that's with dark border to the cell that is like the result to be intending, because you can see up the profit there. I hit equal, now it all works with cell references. Now I could enter 120-115, that would work but instead what we do is as soon as you hit the equals sign, I use my mouse and select the cells on the, say that, by clicking on it, that I then hit the hyphen which is the minus sign and click on the cell I would like to subtract from that one and simply hit enter and that gives me 5.
Doing that one more time, equals, click on the cell, I'd like that minus that clicking on it and click enter, equals, B4, minus, it picks up the cell as soon as you click it minus that, enter. Simple subtraction, now subtraction is the minus sign. Your multiplication in Excel is your asterisk or the star on the number pad.
Shift and 8 on your keyboard will do a similar thing. Your addition is your Plus sign. I'll now do a basic addition at the bottom of the cells.
I hit the equals sign once again, click on my first cell, addition sign Plus ,click on the next cell, addition sign Plus, and the next one, enter. To do a simple division, I'm just going to move one cell below that, again I hit equals sign once again and of course, you remember always hit the equals first. I click on my total value and I can say divide by.
Now divide is your forward slash, you can see that, a forward slash. Now I can say take that total and divide it by 3. Now that gives me 545 divided by 3.
A little note there, when working with formulae in Excel, note that Excel returns the calculation result into the cell. To see the formula, you have to look into the formula bar at the top. As you can see where I intend to, that's where I can see the formula, the formula bar at the top similarly with all the others.
That's how to do a basic subtraction, a basic addition and basic division in Microsoft Excel. .