AVERAGE Function in Excel
In this tutorial, you will learn about how to use excel AVERAGE formula to calculate median in this spreadsheet software. AVERAGE function in excel has a quite easy usage method which is by inputting all the digits that you want to calculate into the formula to get the result.
Why We Need to Learn About Excel AVERAGE Formula?
In processing digits saved in spreadsheet software, often we need to find the median of some or all of our digits. In the case such as looking to find the general picture of company products performance in a particular segment for a period of time or seeing how much is the profit of our business branch daily in a particular region, then the approach like calculating the median for all of our products performance for the first case or the middle digit of all our company branches profit in the region will be the results we need to get to do further analysis with those data collections.
For this matter, there is excel AVERAGE formula which can be used to make the calculation process easier. AVERAGE function in excel itself is very easy to learn and practice so it is hoped that it can make our work significantly more effective and efficient when we process our digits in this tool.
What is AVERAGE Function in Excel?
Excel AVERAGE formula is basic formula in this spreadsheet software with the usage objective to find middle number from some or all of our digits. By using it, we just need to input all of the numerals that we want to process to the AVERAGE function in excel. This method is actually the basic one in looking for middle number in this spreadsheet. If you want to find result using digits with particular condition, then you can use AVERAGEIF and AVERAGEIFS to help you. The tutorials on how to use both can also be found in this blog.
A brief explanation on the inputs in this formula is as follows:
=AVERAGE(number1, number2, …)
Note:
number1, number2, … = all the numbers that you want to calculate the average from
How to Use Excel AVERAGE Formula?
The following will explain step by step on how to use AVERAGE function in excel. In using this excel AVERAGE formula, we need to prepare digits to be calculated for the median result first, either by putting them in cells or by inputting directly when we write the formula.
Using AVERAGE Function in Excel

Type equal sign ( = ) in the cell where you want to put the calculation result

Type AVERAGE (can be with large and small letters) and open bracket sign after =

Type the numbers or cell coordinates where you put the numbers to be processed are after open bracket sign with comma sign ( , ) between the numbers or cell coordinates or drag cell cursor from the most top left cell coordinate to the most bottom right if the number cells you want to process are close to each other

Type close bracket sign after all the numbers or cell coordinates filled with numbers have already been inputted
 Press Enter

The process is done!
Exercise
After you learn from the excel AVERAGE formula tutorial above, you can practice your understanding about it using this exercise!
Download file from the following link and answer the questions below. Please download the answers if you have done the calculation process and sure about the result!
Link to download file to practice your understanding of using excel AVERAGE formula:
Download here
Questions
 What is the median calculation result for B1:B10?
 What is the median calculation result for C1:C10?
 What is the median calculation result for D1:D10?
Link to download answer:
Download here
Additional Notes
 In using this formula, drag cell cursor and numbers or cell coordinates input with comma sign separation can be done in one writing
 If you want, cell coordinates which are near to each other can also be written manually separated for the most top left cell and most bottom right cell by two dots sign ( : ) (writing example: B1:D25)
 There are some other ways to find median number in this spreadsheet software which is by using slash sign ( / ) manual method, AVERAGEIF, and AVERAGEIFS. These methods can be learned by you on how to use it in the other parts of this Compute Expert tutorial blog!