How To Do Average In Excel

To calculate the average in Excel, use the AVERAGE function and input the range of cells that you want to include. The average value of the selected range of cells.

Excel is a powerful tool that not only allows you to organize and analyze data but also perform calculations on it. One of the most commonly used calculations in Excel is finding the average of a set of numbers. Whether you are a student, a business professional, or just someone who loves working with numbers, knowing how to calculate the average in Excel can be incredibly useful. In this blog post, we will explore the different methods and formulas you can use to calculate the average in Excel, and provide step-by-step instructions so that you can master this essential skill. So let’s dive in and learn how to do average in Excel!

How To Do Average In Excel: Step-by-Step


Step 1: Open Microsoft Excel

To calculate an average in Excel, locate and open the Excel application on your device. Then, either create a new document or open an existing one.

Next Step

Step 2: Input Data

To calculate the average of a set of data, input the values you want to include in the average into a row or a column (e.g., Column A). Then, use a formula like “=AVERAGE(A1:A10)” to get the average value.

Next Step

Step 3: Select Empty Cell

Select an empty cell where you want to display the average calculation result. This cell will serve as the location to present the calculated average value based on the data you input.

Next Step

Step 4: Start Typing Formula

In the selected cell, start typing =AVERAGE( to signal to Excel that you are starting a mathematical function. Then, you can provide the range of cells or values you want to average, and close the parenthesis to complete the formula.

Next Step

Step 5: Select Data Range

After opening the parenthesis, you need to select the cells you want to include in your average calculation by clicking and dragging. This will fill the formula with the range of cells you have selected, such as A1:A10.

Next Step

Step 6: Close Parenthesis

In order to properly evaluate a formula, it is essential to close the parenthesis, ensuring that the calculations within it are executed correctly and the overall equation yields the desired result.

Next Step

Step 7: Press Enter

After pressing the enter key, the selected cells will calculate and display the average in the chosen cell. The software will automatically perform the calculation and present you with the result.


In conclusion, calculating the average in Excel is a simple and essential task that can greatly improve data analysis and decision-making. By following the steps outlined above, you can easily calculate the average of a range of values or selected cells. Additionally, Excel provides various functions, such as AVERAGE, AVERAGEIF, and AVERAGEIFS, that offer more advanced ways to calculate averages based on specific criteria. Understanding how to use these functions effectively will enable you to extract valuable insights from your data and make informed decisions. So, next time you need to find the average in Excel, remember these tips and make the most out of this powerful spreadsheet software.

Table of Contents