 Tweet

# Basic Excel 2013 Functions Tutorial

## What is a Function in Excel

A Function in Excel is pre-defined formula, as like other formulas in Excel. A function starts with an equal sign = and after that function name and then argument or parameters are written. Excel knows what to do with this function by its name. Argument or parameters of function are written in round brackets.

## Creating a function in Excel 2013

Excel 2013 has broad verity of functions, in this tutorial you will see some common functions.
Sum: Sum function calculates the Sum of all values of cells given as parameter.
Average: Average function calculates the sum of values of cells given as parameter in function, first it calculates the sum of all values then it divide that sum with number of values given in parameter of function.
Count: This function calculates the count or number of cells with numeric values from all cells given as parameter. This function is very helpful while counting number of items.
Max: This function is used when we have to calculate highest value from number of cells given as parameter.
Min: This function is used when we have to calculate lowest value from number of cells given as argument or parameter.

## Creating our first basic function

Now we will create our first basic function that will calculate average of some given values using AVERAGE function.

1. We need some values in our Excel sheet before. In image following we have entered few values with scores of some super heroes that we supposed by ourselves. We have to calculate average of these scores

2. 3. Now we need a cell that will contains the function of AVERAGE. We select B8 for this purpose.

4. 5. Now Press = and some function suggestions will show you can select you desired functions from them. We selected Average.

6. 7. When you click on AVERAGE function, AVERAGE formula or function will selected, and it will be shown like this =AVERAGE( now you have to Select Cells to pass as arguments in function. Mean you have to select those cells which contains values. When you select Cells they will be shown as parameter in cells which contains functions.

8. In our example we have selected cells from B1 to B7. 9. When arguments or cells are selected, close the round bracket and press enter. Then AVERAGE of your required values has been calculated and being shown in cell B8, as shown in image below.

10. ## Using AutoSum Command to Create a Function

AutoSum Command is very useful while working with Excel. This Command helps you to include most common function in your formula, the most common function for example SUM, AVERAGE, MIN, MAX, COUNT. In this example we will calculate the total scores of some superheroes we used in above example. We will use SUM function for this purpose.

1. Select the cell in which we write function and sum will also appear in that cell, we have selected B8.

2. 3. Now in Home tab, on the right side there will be a tab of AutoSum, click on that a dropdown will show with some functions, you can select any function you want. In our example we have to calculate total score of all superheroes, so we will select SUM.

4. 5. When we click on SUM it will automatically add Sum function into cell we have selected before, and it will automatically select cells as arguments, or you can manually select cells you desire to pass as argument to calculate the sum of. >

6. 7. Now we will press enter, and our desired SUM will be calculated in cell B8, as shown in image below.

8. You can also find AutoSum command in Formulas Tab in Excel 2013. So this was the basic introduction to functions of MS Excel 2013. Hope you have enjoyed it and it was helpful for you.    