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

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

  • Understand, what an AVERAGE function is
  • Insert an AVERAGE function
  • Understand the meaning of Average

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 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Or go back to:

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

38 thoughts on “Lesson 5: Average Function in Excel | What does Average mean”

  1. I like the way you teach step by step. It makes understanding the different concepts in Excel quite easy especially for beginners like me. Thank you for sharing your knowledge.

  2. I must say that you have mastered the art of teaching step-wise. It’s so easy to follow your tuts. Grateful for all this free stuff Habib. People charge a lot for such detailed classes.

    • Thank you for you feedback. I’m glad to hear these video tutorials are useful for you and you are enjoying the teaching style. I want give the value to those who want to learn.

      It’s amazing to know that this is working so far.

      Best Regards

      Habib (ICT Tutor)

  3. I love this excel function! It saves me so much time, and once you get the hang of it, it is quite easy to use. Thanks for this great explanation!

    • Yes Christine, you are right! Once you get the hang of the formulas and functions in Excel, it’s quite straightforward to use Microsoft Excel.

      Best Regards

      Habib (ICT Tutor)

  4. Hey Habib,

    The Average function in Excel is a huge time-saver when compared to manual calculations. I appreciate you explaining the concepts and providing the instructions in a clear manner.

    Thank you for another great lesson.

  5. Hi Habib,

    I love to be here again to learn the average function in excel. This works well to know the average sales made for each product each month, and I cannot express my appreciation for today’s lesson.

    With the previous lesson 2-4, I can now make a sales report to help my managers know how good we are doing for each product and compare it with other months. It’s a plus for my job. Thanks a lot!


    • You’re very welcome Matt – I’m very happy to hear you’re benefitting hugely from my lessons. This is the main reason I’m creating these free lessons, so individuals like yourself can benefit on a personal and professional level.

      Habib (ICT tutor)

    • Hi Gareth,

      That’s very useful to know. That was the main purpose of me creating these tutorials in the first place so everyone including my regular students can benefit from it too.

      All the best
      Habib (ICT tutor)

  6. Another excellent tutorial. I’m sure students can easily understand
    and complete their tasks by watching these videos.

    • Thank you for the compliment Pharaha – that is my aim, for any student to be able to watch my tutorials and understand, then carry out the necessary skills. The average function is very beneficial to workout the mean or average of a range of numbers within cells.

      Habib (ICT Tutor)

  7. Great lesson, Habib! Very informative. You make it very easy to understand and follow along with. Thank you.

    • Thank you Samantha. I try my best to make it as easy as possible, so all you have to do is follow the tutorial and keep on gaining valuable knowledge on all the excel functions.

      Habib (ICT Tutor)

  8. Awesome tutorial! Your slow and clear explaination makes people easily understand how to use an average command.
    Practice makes perfect – real knowledge.

    Thank you very much.


  9. Great tutorial, the video really helped too. I can’t wait to see what else you have in store – Excel can be a bit of a minefield to navigate, especially when following the instructions and it still doesn’t work!

  10. You are correct that if we practice writing the commands, then we will remember how to do them easier.
    Thanks for showing how to use the average function. I really like the step by step videos. Keep it up.

    • Yes Greg, practice and understanding is the key to knowledge – I always tell my students this. I’m also sharing the same advice to all my visitors to our site.

  11. Hi Habib, great to divide the endless possibilities of Excel in little, understandable bites. Thank you so much and take care,

    • Great to hear you’ve enjoyed the short, but thoroughly explained tutorial. Many more to come, keep coming and making use of these tutorials. You take care too.

  12. Uhhh… Excel has always been a rocket science for me. You have made such complicated things simple!

    Good job! I’ll bookmark your website to come back next time when I have an Excel puzzle.

    Best Wishes,


    • Many people see Excel as something complicated. But all it needs is simple explanations like this tutorial.

      Keep coming for many more amazing tutorials.


Leave a comment

Share via
Copy link
Powered by Social Snap