Lesson 62 – The AverageA function in Excel | Why and When to use the AverageA function in Excel

In this lesson, I’m going to be showing you how to:

  1. Understand, what the AVERAGEA function is used for
  2. Insert an AVERAGEA function
  3. Know, why and when to use the AVERAGEA function
  4. Include text data in your average calculations
  5. The difference between the Average function and the AverageA function

Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 63 – coming soon 🙂

Or go back to:

Lesson 61: AVERAGEIFS function in Excel | Find the average value by using many criterias in excel

Lesson 60: What is the AVERAGEIF function in Excel | How to insert the AVERAGEIF function in Excel?

Lesson 59: FORMULATEXT function in Excel | Display formulas or functions of individual cells only

Lesson 58: SUMIFS function in Excel to ADD multiple CRITERIONS from different columns

Lesson 57: SUMIF function used to ADD up MULTIPLE different items in one column in Excel | SUMIF+SUMIF

Lesson 56: SUMIF function in Excel | What it is & how to insert the SUMIF function in Excel?

Lesson 55: COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel

Lesson 54: COUNTIFS function in Excel with 2 examples | How to use Data Filter in Excel

Lesson 53: COUNTIF function used to COUNT MULTIPLE different items in a column in Excel | COUNTIF+COUNTIF

Lesson 52: COUNTIF function in Excel | What it is & how to insert the COUNTIF function in Excel?

Lesson 51: How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than

Lesson 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

Lesson 49: How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

Lesson 48: How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

Lesson 47: How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

Lesson 46: Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

Lesson 45: How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

Lesson 44: Use the IF function to work out if you are over BUDGET or not in Excel

Lesson 43: How to change a DATE to different FORMATS in Excel

Lesson 42: How to set and print rows & titles automatically at the top of each page in Excel

Lesson 41: How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 40: How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel

Lesson 39: How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 38: How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 37: How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

Lesson 36: Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Lesson 35: How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Lesson 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33: How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32: What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31: Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29: Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28: A simple DIVISION formula in Excel | How to DIVIDE in Excel

Lesson 27: What is the thousand separator in Excel | How to use the thousand separator in Excel

Lesson 26: Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

Lesson 25: Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24: How to SORT data in ASCENDING order in Excel

Lesson 23: Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22: How to RENAME a worksheet in Excel

Lesson 21: How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20: How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19: What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18: What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17: How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16: What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15: Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14: How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13: How to Format cells as Currency, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

22 thoughts on “Lesson 62 – The AverageA function in Excel | Why and When to use the AverageA function in Excel”

  1. I have been using Excel (or the OpenOffice version, Calc) for almost 20 years now, and it becomes apparent all the time that there will always be SOMETHING it can do that I don’t know about.

    I don’t actively learn it to know the whole program, but I do search for functions that solve what I’m working on, and your tutorial did that.



    • Hi Tyler,

      You are right, there is so much to learn in Microsoft Excel. Hence, I’ve ended up make 62 videos on Excel. The interesting thing is that, this not not the end of information on Excel. I could go on forever, (which I probably will, lol!;-)). But I am also going to be making tutorials on other areas of the Microsoft Office such as Word, PowerPoint, WordPress etc. So keep an eye out on our YouTube channel for those.

      Wishing you a great learning experience.

      Habib (ICT Tutor)

  2. I’ve been following your turorials on Excel for a while now and all I have to say is awesome work, man. I’m learning a ton from you. Although a lot of these functions are new to me, your guides are newbie-friendly, which is something I really appreciate. Keep up the good work!

  3. Hi Habib,

    Thanks for this great lesson!
    I didn’t know about the AverageA function before, but know I understand how to use it in Excel. You give a clear explanation in the video!

    • Hi Catherine,

      I’m happy to hear you have learnt something new from my Excel tutorials. I have many more lessons on our YouTube channel if you would like to learn more about the Microsoft Excel.

      All the best
      Habib (ICT Tutor)

  4. Thanks Habib, another difficult function explained. 🙂 I am not sure I have data in which to use this. But once a function is clear, there are bound to come situations in which it is useful. (Not sure if this is proper English?)
    What I love most is that all explanations of the functions have their own video. So I just have to browse through the list if I am looking for a specific function. (I wouldn’t browse of course, I would use command-F, but as a matter of speaking).

  5. I remember back in the days when I wanted to learn Excel, I could hardly find free lessons to help me get by. I must commend you for sharing so many lessons. Right now, I only use Excel for the mere basics, but I have friends who use it daily. Considering that you have some in-depth lessons, they may very well show some interest. I will therefore share this link with them.

    • Hi Carol,

      Thank you very much for your feedback and also sharing my Microsoft Excel lessons with your friends, so they too can benefit from them. I have many more videos coming up on Microsoft Office on our YouTube channel.

      Best Regards

      Habib (ICT Tutor)

  6. This is another excellent lesson. I used to confuse the AverageA with the Average function sometimes, but after seeing this and the last lesson, it is perfectly clear to me now. It will be very useful for me, especially if I want to get some statistics.

  7. Thankyou for a very clear explination of the difference between the average and the averagea functions. Your teaching style is very good. I’m going to go back to some of your previous lessons to learn how I can get more benefits from using excell.
    Have a great day 🙂

  8. Learning so much from your videos, your breaking down of each section is really helpful. I’m actually in the process of putting a production sheet together for my work and your videos are really helping with that.

    I’m sure I’m going to be asked to create more spreadsheets once I’ve been through your training.

    Have you got a video which could help me maximise my production planning for a work load?

    • Excellent Damon – keep on learning, there are many many more free lessons coming your way.

      You will have to give me more information about your production planning work, then I can recommend which lessons to refer to. Hope this is helpful. Take care 🙂

      Habib (ICT tutor)

  9. Very Cool! At first I was like ok so they are the same and then BAM you surprised me! That was a really neat demo. Once you explain everything it seems so easy! Thank you for a great lesson!

  10. That is a very interesting way to handle mixed data. I always avoided using charactors in placements for numbers because they always either got ignored or gave me an error. AverageA does take care of this problem however I don’t see it being used very often especially for my self. Another awesome lesson to learn from. Looking forward to your next lesson.

    • Hi Rick,

      Thanks for stopping by and leaving us a feedback. AverageA is one of the many excellent functions in Microsoft Excel.
      I have made quite a few video on this and will continue to expand on these. You can check them out on our YouTube channel.

      All the best

      Habib (ICT Tutor)

  11. Great lesson Habib, I have gained so much since I started reading your posts and going through all your excel training. It’s a wonder how much you know, and beautiful that you want to teach others too.

    • Thank you for your encouraging feedback Aparna. It’s fantastic to know how much you guys are learning from y teaching.

      All the best

      Habib (ICT Tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap