Build Excel Formulas

Microsoft Excel is very good at performing calculations. Everytime we use Excel we typically use a combination of cells with numbers and cells with formulas.

Here's a step by step guide how to write your own formulas in Microsoft Excel.

1. Put the cell pointer in the desired cell.
2. Type in equal sign. The equal sign tells Excel that we are starting a formula
3. Type in your equation just like in any calculator. If one of the terms in our formula is already stored in a cell in Excel, we can point to that cell's address instead of typing in the number of that cell. This method allows us to change the value in one cell and then watch all of the formulas recalculate.

Tip: Use + to add. Use - to subtract. Use * to multiply and use / to divide.

4. Press Enter. Excel calculates the formula in the desired cell.

Watch the video for more details.





Until my next video.

Pinoy Excel Guru,
Elvin Peria