‘Basic Excel’

How to use average in Excel, =AVERAGE()


In Excel you can calculate the average of a specific range of numbers or individual cells by using the =AVG() formula. For example you would like to know the average salary of the group of people shown in the image. ¬†You can then type =AVERAGE(C2:C6), or select the range by clicking with the left mouse… Read More

How to SUM in excel

In excel you can sum cells automatically. For example you would like to get the sum of cell A1, A2, A3 and A4. You can select any specific cell to see the sum of these before mentioned cells and use the function =SUM(). Go to the cell where you would like to see the result… Read More