Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Basics of Excel 2007
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Basics of Excel 2007

This is tutorial for all, who are ready to learn more about Excel, but they never used it before.

 
  Author: Realife | Version: 2007 | 14th February 2011 |  
 
 
1.
 

Create new Excel document and enter some informations.

I decide to create a simple statistic table with informations about tutorials on Dreevoo.

 
 
2.
 

Select your table.

 
 
3.
 

Select arrow next to the table icon.

 
 
4.
 

On list select option All Borders.

 
 
5.
 

Select names of informations in your table.

I selected months and Total.

 
 
6.
 

Now you can customize design on your table.

 
 
7.
 

I designed simple table with 4 background colors and 2 diferent font colors.

 
 
8.
 

Now select first box in Total tower.

In my case, i selected box F5.

 
 
9.
 

In top menu go to Formulas and select AutoSum.

 
 
10.
 

Program will automaticily create you a formula.

Then just press Enter.

 
 
11.
 

Then select second box in Total tower and repeat previous two steps.

 
 
12.
 

I calculated number of tutorials for all three categories.

 
 
13.
 

I dicided to add new line in my table.

I name it Total and put it to two last towers.

 
 
14.
 

Again go to Formulas and select AutoSum.

Then select informations in last tower.

I selected number of computer tutorials, recipes and do it yourself tutorials.

 
 
15.
 

Here is my final result. I can change any number in this table and it will automaticaly refresh with new informations.

If you have any problems, feel free to discuss on our forum. You can also view other tutorials and learn something new. ;)

 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO