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

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

  1. Understand what is the SUM function
  2. How to insert the SUM function
  3. Entering text and numbers in Excel

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 3 – Simple Subtraction Formula using Excel

Or go back to:

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

42 thoughts on “Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons”

  1. Many thanks for sharing your knowledge in a way that is so easy to understand. Iv’e tried to learn before from lessons on youtube, but because of my lack of understand about excel, I often didn’t know how to ask the right questions to find out how to do what I was trying to achieve.
    I think I had better go through your lessons one by one, and put the information into practice so that I will remember it.

    Many thanks,

    • Hi Andrew,

      I’m glad to hear you have come across my lessons on YouTube at last, that are beneficial for you! Yes definitely, watch the videos and then practice them to reinforce the learning.

      All the best.

      Habib (ICT Tutor)

  2. Hi Habib,
    The sum function is one of the important functions of excel. I really learned new ideas.
    I saved your website so it will be a reference for me whenever I need a solution for any query. moreover, the lessons are labeled so I can find easily what I want.
    I expect great success for this site
    Have a great day

    • Hello Rania,

      Many thanks for liking my Excel tutorial and making a good use of them. I want the whole world to get access to a good and legit education. Hence, created these tutorials.

      Thank you for your best wishes. I’m truly humbled.


  3. Hi Habib,
    Thanks so much for this post. You just saved me so many hours of struggling with deleting a row from an excel product list.
    This is so far the best place of understanding using excel.


  4. Hi Habib
    Great work. This is second time in this exercise, you make it easy for me to understand.

  5. Hi again Habib, Thank you for these two lessons. This was my first time using spreadsheets, Formulas and functions. I have completed both and have learnt a lot.

    • You are going through the lessons very fast. Keep on learning and repeat the videos as many times as you need to. Great work. SUM function is used for adding only, please remember that. Well done

      Habib (ICT Tutor)

  6. Hi Habib,
    Another great video! I appreciate you walking us through how to complete a sum function in Excel. Keep up the good work.

    Warm regards,

  7. Hi Habib,

    Thanks for this video – Excel is a key business tool but there are a lot of nuances to trip people up. Understanding the differences between functions and formulas is such a key element of using data tools effectively.

    Have you considered showing differences between Excel and Google sheets?


    • Hi Lisa,

      Thanks for your lovely feedback. I just wanted to create a demonstration to excel as user friendly as possible. I will be making many more videos in the upcoming days. So please keep an eye out on that.

      Kind Regards

  8. Hey,

    Really understood the video and I like how you have put your website together.

    Keep going with your articles and videos and keep inspiring us.

    All the best,


  9. Any special motivated post will always be successful, such as this one. Please carry on making these tutorial videos, they are very beneficial.

  10. Very straightforward video to help young students like myself with their work.
    Very clear and you made it look so simple.
    Keep up the good work!

  11. In this video Habib explains how to replicate the formula, when to use SUM function and what is difference between formula and function. Excellent explanation!


Leave a comment

Share via
Copy link
Powered by Social Snap