How to use graphs and charts in Excel 2010

Using graphs is a very important step in Excel, is very useful and also easy:

There are lots of types of charts:

Column

Line:


Pie:


Bar:











Area:


Surface:


and others

So if you want to add a chart, you need to follow this steps:

1. Select the cells that you want to chart, including the column titles and the row labels. These cells will be the source data for the chart.


2.Click the Insert tab and choose the type of graph you want to use:


3. Select the  chart type:



4. Finally it will end like that:



If oyou dont like the design or if you want to change the type of chart, you can do this  in the Chart Tools Layout:








If you need more details about it, see this video: LINK HERE 

How to use formulas in Excel 2010

Here are some simple and basic formulas that are very important in Excel 2010:


There is other formula that is important, this is the percentage formula (=5*5/5)

So for adding a formula there are some important steps:

1. Select the answer where you want the answer to appear:


2. Type the equal sign (=)
3. Type the formula you want to use:


4. Press enter, and the formula will be done

If you want to use a formula with content in any cell you need to do the same steps, but you want to type the name of the cell:





If you want more information, you can see this video, LINK HERE