In this lesson, I’m going to be showing you how to:
- Understand what is the SUM function
- How to insert the SUM function
- 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
Another great tutorial, where would I be without you and all videos.
Thank you again. Very helpful.
Thank you very much for your feedback. It’s appreciated. Glad to hear my lessons are helpful for you.
Habib (ICT Tutorial)
Hi Habib,
This lesson was very easy to follow and understand! You’re saving me a lot of time in Excel teaching me these skills 🙂
Hi Christine,
I’m glad to hear it. I’m uploading many more lessons regularly on my YouTube channel. So, please check it out.
Best wishes
Habib (ICT Tutor)
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
Thank you very much for the very kind words, and I’m happy to hear you think our site is the best for excel learning. Benson, we also have an YouTube channel, that you might like to check out 🙂
Habib (ICT tutor)
Hi Habib
Great work. This is second time in this exercise, you make it easy for me to understand.
Thanks
That’s great feedback Peter! Thank you! 🙂
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)
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
Hi Sonia,
Thank you for your comments and feedback and that you found these tutorials on Exel useful.
All the best
Habib (ICT tutor)
I’m following the whole course – a great step by step approach!
That’s great. There are many more useful contents on our YouTube cahnnel at https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg
Best Regards
Habib (ICT tutor)
Very clearly explained.
Thank you Pharaha – I hope you have understood the SUM function clearly.
Habib (ICT Tutor)
This is a great tutorial. Very helpful. Thank you, Habib.
Thank you Samantha – happy to hear you have benefitted from this tutorial.
Habib (ICT Tutor)
Very simple, concisely done and slow paced which will suit all audiences. Good job.
Thanks Imran for your positive feedback.
Kind regards
Habib
You explained this lesson really well. Thank you Habib
Hi Alison,
Many thanks for visiting our site at https://lifestyletipsandhacks.com/ and sharing your views. There are more contents like these are on their way soon. So, keep a look out for that.
Thank you
Habib
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
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
This a truly special motivational post. Thank you so much for this help.
Thanks nati for your lovely feedback. There are many more contents like these are on their way soon at https://lifestyletipsandhacks.com/
Kind regards
Habib
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
Thanks Tom for this encouraging feedback.
Plesse visit our website at
https://lifestyletipsandhacks.com/ for more contents.
Best wishes
Habib
Any special motivated post will always be successful, such as this one. Please carry on making these tutorial videos, they are very beneficial.
Thanks nati. I shall I take your advice on board!
Kind regards
Habib
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!
Hey dear Ibrahim,
You’ve made my day with your feedback. It’s very encouraging.
Thank you
Habib
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!
Thanks for your lovely explanations about this video Irina. I appreciate all your support and kind words.
Kindest regards
Habib
Excellent tutorial and explained well. Thank you
Thanks for your lovely comment Justine.
Kind regards
Habib
Hi Habib. This is a great tutorial for anyone struggling to understand all these technical features of excel. If I ever struggle again I will watch this again. Thank you
Hi Chantelle, Yes, I have made all my tutorials very easy for anyone to understand. Feel free to start my lessons from lesson 1, and keep on learning.
Habib (ICT Tutor)