Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

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

  • Understand, what an AVERAGE function is
  • Insert an AVERAGE function
  • Insert a new row

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

Note: a NEW lesson 4 VIDEO is coming soon – sorry for the inconvenience

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 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Or go back to:

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

28 thoughts on “Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?”

    • 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)

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

    Reply
    • 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)

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

    Reply
    • 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)

      Reply
  3. 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.

    Miranda

    Reply
  4. 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!

    Reply
  5. 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.

    Reply
    • 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.

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

    Reply
    • 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.

      Reply
  7. 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,

    Natalie

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

      Keep coming for many more amazing tutorials.

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap