Basics of Excel 2007

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

Create new Excel document and enter some informations.

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

Select your table.

Select arrow next to the table icon.

On list select option All Borders.

Select names of informations in your table.

I selected months and Total.

Now you can customize design on your table.

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

Now select first box in Total tower.

In my case, i selected box F5.

In top menu go to Formulas and select AutoSum.

Program will automaticily create you a formula.

Then just press Enter.

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

I calculated number of tutorials for all three categories.

I dicided to add new line in my table.

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

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.

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. ;)