
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. 










