Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

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

  • Understand, what the INSERT FUNCTION button is for
  • Use the INSERT FUNCTION button to create the following functions:
    AVERAGE function
    MINIMUM function
    MAXIMUM function
    COUNT(A) function
    ROUND function
    IF function

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

Note: a NEW lesson 9 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 10Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Or go back to:

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

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

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

20 thoughts on “Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?”

  1. Thanks for sharing this information. I really benefited from it. Your lessons are easy to follow. I wish everyone explained so good as you do

    • Thank you for this great feedback. I really appreciate it. Your encouraging words have motivated me to make more video tutorials. 🙂

      Best Regards

  2. Yes! An excellent video on how to use the insert buttons in excel. I was looking forward to learning more about this – I remember having a job position where I had to calculate values using some of these shortcuts but I had no idea how!

    Luckily, I had help, but I now know how important it is to use these in daily life. I do need to improve on my function arguments, and I know that they are actually simple to input but my mind is always thinking – why use the insert function button when I can just manually type them in?

    You showed a great example and easy to follow way for anyone to use excel for budget spreadsheets and all else. I will bookmark your page for sure!

    Thank you,

    • Thank you Michael for a detailed comment. Yes, you are spot on about the insert function button, it makes our lives so much more efficient. It does most calculations for us with very little ease.

      My tutorials will always be in this style – easy, simple to follow for anybody.

      Habib (ICT Tutor)

  3. Thank you for another fantastic tutorial Habib. I have found the video tutorials really useful to follow along with as I have been working through each task.

    • Well done for working through each lesson, starting from lesson 1. This will make your learning and understanding of the excel functions a lot easier. The insert function button in excel does make our tasks a lot quicker.

      Habib (ICT Tutor)

  4. I use excel all the time and use some of the basic functions and often forget about what they do.

    I have in the past written programs for Excel to manipulate the data but those days are long gone!

    Excel is such a great application and can be learned by anyone for basic spreadsheets but full of functions that many aren’t aware of until they come across posts like yours.

    Thanks for sharing

  5. Thanks, you’ve just saved me a ton of time! That was a really good, easy to understand walk-through. You are a good teacher. I’ll be back to watch more tutorials. I knew Excel is powerful, but I never really took advantage of what it is capable of doing for you (like functions… cool stuff). I will now.

    • Thanks Steve – I try my best to be the best teacher possible, so my students can benefit the most. Excel is most certainly very powerful and makes your life very easy if you know how to operate it correctly.

      I will be uploading many more tutorials, so keep visiting and taking advantage of my knowledge – it is all for free.


  6. Hello Habib,
    What a wonderful tutorial. I learned something new. Your video is amazing, You are really a good teacher. A few years ago, I took a training course called ICDL in which I master word, excel, PowerPoint, and many other basic computer techniques. But I never study these functions. Thank you very much for this beneficial tutorial
    Have a great day

    • Hi Rania, thank you for the kind words. I try my best to be the best the teacher 😉
      Any skill requires practice, however, I say if you never understood the skill in the first place then you never gained the knowledge in the first place. My advice is always – seek to understand the skill/task before attempting to implement it – then it will stay with you for life.


  7. Wow – I wish I came across your site a long time ago. I have been struggling to understand how to do functions, but no one could teach or explain in a way that I understood. However, your video tutorials are so simple to follow and understand – you must be an amazing tutor. Your students are very luck to have you. I wish you were my tutor 🙂


  8. Hi there,

    Thanks for sharing this information in such a clear and concise manner. There are certainly some tricks in this training that I will use in the future. I often forget some of the functions because I don’t use them often enough.

    Looking forward to your next post.

    Best wishes,

    • Thank you Sharon – All my video tutorials will be clear and concise with good examples. Keep visiting our site and benefit from my knowledge. It’s free, I don’t charge 🙂


Leave a comment

Share via
Copy link
Powered by Social Snap