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: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

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

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

  1. As usual a well-presented tutorial on the functions of excel. Albeit it’s a very basic function to carry out, there are many various ways of performing this function which you covered exceptionally well. Perhaps this is the first lesson I did not learn something new because it is such a basic and widely used function. I still enjoy watching just to make sure I didn’t miss anything and if at all else as a refresher. Thanks again Habib your tutorials are awesome to learn from.

    • Most definitely agree with you. The sum function is the most commonly used.

      Many more lessons are coming. So keep an eye out for those. 🙂

      Wishing you all the best

      Habib (ICT Tutor)

  2. Great lesson on the SUM function in Excel!

    You have explained how to use this particular function in various ways and have done so in such a way that makes it very easy and clear for us to understand. Thank you for that.

    Also, thank you for all of the time, effort, and work that you put in to deliver these valuable and informative lessons to us. It is very much appreciated.

  3. I love using excel. I have used it for as long as it has existed. I still struggle with it every day. The lessons I have read so far, have already solved two issues. Thank you and I have signed up for the lessons, This is great!

    • Excellent Rob, happy to hear you have resolved 2 issues so far. Once you have completed the full 62 lessons I have on Excel on my website and YouTube channel, so far, then you will have learnt many new skills and probably solve many more issues you face when using Excel.

      I recommend you subscribe to my YouTube channel to get alerts for all new lessons. I have big plans for many lessons on the full suite of Microsoft Office 365. All the best 🙂

      Habib (ICT tutor)

  4. A really good, precise, step by step tutorial for anyone who wants to learn more about Excel. I do use Excel a lot, but I just remembered It wasn’t so easy to learn it when I just started. I find your way of braking it up and explaining every little detail way much better than the book I used to read than, back in many years. You make it very clear, very understandable and very followable (hmm, is that a word or I just made it up?)
    Anyway, keep up the excellent work, I’m sure I’ll be back to see how it goes on!

    • Thank you for your feedback Kerryanne. I have and will always make all my lessons of great quality and easy to understand. Don’t forget I have a YouTube channel, where you can subscribe for all future lessons too.

      Habib (ICT tutor)

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

  6. Hi Habib,

    The tutorial about the formula_SUM is super clear that everyone could understand it easily without confusion. I love that you also attached the exact excel file you demonstrated in the video here, so we can practice it after finishing watching this video. I can see that you put lots of effort and time for excel training, and it does provide me value and help.


    • Thanks Matt. I want all my visitors to benefit to the maximum, hence my lessons are very clear and they include the working file, like you said so everyone can practice after watching the video.

      I wholeheartedly believe – if you give value to the best possible, then you will automatically receive the value back in may different ways.

      Take care 🙂

      Habib (ICT tutor)

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


  8. Hi Ali,
    This is very informative we already know this only because we are going to school right now and we are learning this and you have shredded more light on the subject.
    Thank you for teaching us more than we know. We are glad to see the video is helpful as well showing you what is needed to know and how to do it.
    This is going to be a very beneficial site to others that have no idea what excel can do for them and Microsoft 360. This program has helped us out so much for the right projects.


  9. 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.


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

  11. 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)

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

  13. 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

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


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

  16. 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!

  17. 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