How to Calculate an Average in Microsoft Excel

How to Calculate an Average in Microsoft Excel

In addition to spreadsheets, the primary purpose of Microsoft Excel is to perform calculations in everyday work. Excel can perform all kinds of calculations, from complicated tasks to simple ones, such as calculating averages. We use formulas for calculations in Excel, and the formula for calculating the average is one of the simpler ones.

Watch our video tutorial where we show you how to calculate an average in Microsoft Excel, using Windows 10.

Video Transcript:

  1. How to Calculate an Average in Microsoft Excel
  2. For this we will use the AVERAGE function. Click on the field where the average will be calculated.
  3. In the formula box, type =AVERAGE()
  4. Inside the brackets, we will write from which to which cell the average will be calculated. In our case it is from cell A1 to A4. Type A1:A4, then press ENTER on your keyboard.
  5. It is also possible to enter individual cells from which the average will be calculated. For this, enter cell labels, separated by commas. For the average of cells A1 and A3, type A1,A3
  6. You can enter an unlimited number of cells in this formula


1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)

Share: Share to Facebook to Facebook Share to LinkedIn to LinkedIn Share to Twitter to Twitter

Send: Send to Viber to Viber Send to WhatsApp to WhatsApp Send to Telegram to Telegram Send to Facebook Messenger to Messenger Send to Email to Email

If you enjoyed this article, you might also like...

Leave a Reply

Your email address will not be published. Required fields are marked *