1.3- Entering and editing formulas

Hello Excel-lent,

I can't help you reduce Lagos traffic but i can help you work faster and be efficient at your workplace using Ms Excel. There is no reason why you shouldn't be excel-lent at work and that's the more reason why you should be part this and subsequent sessions of our Excel online training as we would be talking and discussing "FORMULAS".... the engine room of Excel J

In today's session, I would be introducing you to "how to enter and edit formulas" in Excel. There exists about over 500 formula in excel ranging from Statistical, Mathematics and Trigonometry,Financial, Engineering, Text, Date & Time, Lookup and Reference, Information, Database, Cube and Logical functions. You don't need to know them all but you need to be able to use the ones that speaks to your daily operational workplace need.

Excel Formula Overview

Formulas are one of the most commonly used features of Excel. They can be used to carry out simple addition and subtraction or far more complex mathematical calculations.

All formulas in Excel, no matter how complex, always begin with the same two steps:

1.  Click on the cell where you want the formula's result to be displayed.
2.  Type an equal sign ( = ) to let Excel know you are creating a formula.

Many formulas in Excel perform basic mathematical calculations such as subtraction and multiplication.

For these formulas, after the two steps listed above, we only need to add, in the correct order, the data to be used in the calculations and the mathematical operators that tell Excel which mathematical operation to perform.

Using Cell References in Formulas

Rather than enter the data directly into a formula, it is better to enter the cell references where the data is located into the formula.

The advantages of this are that:

1.  If you later change your data the formula automatically updates to show the new result
2.  In certain instances, using cell references makes it possible to copy formulas from one location to another in a worksheet

The easiest and best way to add cell references to a formula is to use pointing, which means to click with the mouse pointer on the cell containing the data you want added to the formula.

Click " Join Excelgist " to receive Excelgist discussions directly to your mail box.

Excel-lently yours,

Oladapo Sorinola
07014282477, 07062932708
BB Pin 52E9802D