Using Formulas in Excel - Image Tutorial

Formulas can be really simple or complicated in Excel but we will stick to simple now. There is plenty of time to look at more advanced formulas. We will look at some of the most common easy to use functions.

How to Add Cells in Excel:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on the cell where you would like to add the formula.




3. Press "=" on the keyboard.




4. Click on the first cell you would like to add.




5. Press "+" on the keyboard.




6. Click on the second cell you would like to add.
7. Click on the green checkmark beside the formula bar.

*You can add more than two cells together using the same process but repeating from number 5.

How to Subtract Cells in Excel:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on the cell where you would like to add the formula.




3. Press "=" on the keyboard.




4. Click on the first cell (with the number you would like to subtract from).




5. Press "-" on the keyboard.




6. Click on the second cell (the cell with the value you would like to subtract).
7. Click on the green checkmark beside the formula bar.

*You can subtract more than two cells using the same process but repeating from number 5.

How to Multiply Cells in Excel:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on the cell where you would like to add the formula.




3. Press "=" on the keyboard.




4. Click on the first cell you would like to multiply.




5. Press "*" on the keyboard (shift+8).




6. Click on the second cell you would like to multiply.
7. Click on the green checkmark beside the formula bar.

*You can multiply more than two cells together using the same process but repeating from number 5.

How to Divide Cells in Excel:

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Click on the cell where you would like to add the formula.




3. Press "=" on the keyboard.




4. Click on the first cell (the cell with the value you would like to divide).




5. Press "/" on the keyboard.




6. Click on the second cell (the cell you would like to divide by).
7. Click on the green checkmark beside the formula bar.

If you had any problems completing this module or think some details need more explanation, please let us know. We also welcome any other feedback.
Send Feedback