One of the options that Microsoft Excel has is to calculate the average of several numbers. This function can be useful in a great number of occasions and just a little further down, we are going to show you a very simple method so that you can put it into practice..
We have already taught you several things related to Microsoft Excel such as saving a graph as an image, crossing out text, dividing cells, protecting our files with a password, etc. We have many guides related to this interest and above all, a useful program.
In this article, we will see how to calculate the average in the fastest and most effective way possible. Every time we use Excel, one of the things we need the most is to save time and we can perform our tasks quickly, this guide is designed for just that..
What is the average?
The average of the numerical values is calculated by adding all the numbers and dividing the sum of them by the count of numbers.
We are going to give an example so that they are better understood, if the numbers are 10, 15, 20, 25 and 30, the first thing will be to add all those numbers and then divide that sum by 5 because obviously, we have a total of five numbers. Basically it would be 10 + 15 + 20 + 25 + 30/5 = 20
By default, when Excel performs the calculation it ignores those cells that are blank, it will also ignore cells that have zero..
How to calculate average in Excel
The first thing we will have to do is open the spreadsheet that contains the numbers in Excel. In the spreadsheet, we are going to have to choose the numbers for which we want to find the average.
In the Excel toolbar, we are going to go to the "Home" tab.
Next, we go to the "Edition" section and we will have to select the icon with the down arrow next to "Sum".
A new menu will expand where we will have to look for the option that says "Average" to be able to find the average of its numbers.
At the end of the selected cells, we will be able to see the average of the numbers that we have previously selected.