How To Find Average In Excel

To find the average in Excel, use the AVERAGE function followed by the data range, and the output will be ”.

Excel is a powerful tool that is widely used for data analysis and calculations. One of the most common tasks in Excel is finding the average of a set of numbers. Whether you are a student, a professional, or simply dealing with numerical data, knowing how to find the average in Excel can be incredibly useful. In this blog post, we will explore different methods and formulas that will help you easily calculate the average in Excel, making your data analysis tasks more efficient and accurate. Let’s dive in and learn the essential skills needed to find the average in Excel!

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


Step 1: Open Excel Spreadsheet

To find the average of data in Microsoft Excel, simply open the application on your device, and locate and open the specific spreadsheet that houses the desired data.

Next Step

Step 2: Identify Data Set

To calculate the average in Excel, simply select the desired column or row which contains the data you want to analyze. Excel will then perform the calculation based on the cells you have chosen.

Next Step

Step 3: Click on Empty Cell

Click on an empty cell at the desired location for the average result. It is best to select a cell that is at the end of the row or column containing the numbers to be averaged. This ensures accurate calculation and convenience.

Next Step

Step 4: Access Excel’s AVERAGE Function

Type “=” into the selected cell to start a formula. Then, input “AVERAGE(” after the equals sign. AVERAGE is an Excel function used for calculating the average value in a range of cells.

Next Step

Step 5: Input Range of Data

To calculate the average of a specific set of data in a spreadsheet, select the range of cells that contain the data you want to include in the calculation. Enclose this range inside parentheses after the “AVERAGE” function, allowing you to determine the mean value of the selected cells.

Next Step

Step 6: Complete the Formula

Once the range is specified and the function is closed, pressing the “enter” key or selecting another cell prompts Excel to compute the average of the specified range cells, providing a quick and accurate result.


In conclusion, Excel provides several efficient methods for finding the average of a set of values. Whether you prefer using built-in functions like AVERAGE or the manual approach with formulas, you can easily calculate the average in Excel. Additionally, utilizing the various options like excluding zeros or dealing with errors further enhances the accuracy of your calculations. With these techniques at your disposal, you can confidently analyze and summarize your data with ease.

Table of Contents