Chart's VIDEO

Good Luck!

Types of Graphs

Here are some types of Charts/Graphs that I use with an idea for their use


Column Graphs:

I would use them because with their esthetic form it is the easiest way to compare numeric amounts.  

Line Charts

I would use it because that way I can see the drop or growth of certain products, considering their selling or how much the costumers like it.

Pie Charts

I would use it because with it is the easiest way to show percentages!

If you don't like these, don't worry! There are many other charts - XY, bar, area, doughnut, radar, surface, bubble, stock, cylinder, cone, and pyramid. It just depends on you. 

How to use formulas and graphs in Excel 2010?

Using formulas is very easy!

First, you need to have numeric information in your Excel cells. Account information, grade books, pays... anything is useful. There are 2 ways of using formulas: 

1. In the upper "menu" inside Home, in the further right side in the Editin subtitle there is an adding simbol. If you press the little arrow beside it, more options will appear, but if you need another formula clicking "more functions" must do it. After selecting the formula you just have to select the cells (clicking with your mouse) you want to be part of the formula. 

2. The second way is easier, but you have to know in what language is your computer. For this way, you just choose the cell where you want and the first thing you will write down is "=". This will tell Excel that you want to activate a formula. After =, you write the first letters of the command you want to give. Automatically, Excel will give you further options and you can select them or erase and write again. 

Using graphs depend on your formulas or information

For using them you need to have information! After, you select the cells with the mouse, and in insert there is a picture for "graphs" you click in it and you can choose from all different options depending on how you want to picture your information. It will appear, and if you are not happy enough you can edit it, by using "chart tools". 

 

Easy and useful formulas I have used in class:

for adding - =SUM()

for average - =AVERAGE()