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

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

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

    V/r

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

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

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

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

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

    Thanks!
    Lisa

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

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

    Tom

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

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

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

    Reply

Leave a comment

Share via
Copy link
Powered by Social Snap