|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Excel 2007 Tutorial for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories
- Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,
|
Microsoft Excel Tips and Tricks for beginners |
|
|
| |
Written by Upendra Kumar
|
|
Saturday, 07 July 2007
Category MS Excel 2007 - Formulas.
|
| |
| General Information |
| |
 |
| |
Inserting a formula
Working with cell's references
Working with functions
|
| |
|
| |
|
Excel is an effective tool to work with numbers and to do mathematical operations. Sometimes, for do these operations are necessary to insert formulas. |
| |
| Inserting a formula |
| |
| 1) Open the Budget.xlsx Sample. |
| |
|
| Illustration 1: Budget sample excel file. Click here to view larger image. |
| |
| 2) You will sum cells E4 and E5 and put the results in the cell E6. |
| |
| 3) To write a formula (or some text), click on the target cell. When you write, the results will be displayed in the formula bar. |
| |
|
| Illustration 2: Writing formulas. |
| |
| 4) Another way to write formulas is clicking in the target cell, write an equal (=) sign, then click the first operator, click in the plus (+) sign,
click in the second operator and press ENTER to accept the formula and display results. The formulas of Excel always begin by an equal sign. |
| |
| 5) If later you wish to know how excel has obtained the results, the formula will be visible in the formula bar. |
| |
|
| Illustration 3: Viewing formulas. |
| |
| 6) Bellow is the mathematical operations list: |
| |
| Within each formula it can use more of a mathematical operator. |
| |
|
| |
|
|
|
|
|
|
|
|
| |
