Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

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

  1. Delete a row containing data
  2. Replicate the formula
  3. Create a SUM function
  4. Differentiate between a function and a formula

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

If I have not covered anything 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 🙂

Thanks for watching!

When you’re ready move onto:

Lesson 3 – Simple Subtraction Formula using Excel

Or go back to:

Lesson 1 Simple multiplication Formula using Excel

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.

Habib Ali – ICT Tutor

Spread the Knowledge & Love

18 thoughts on “Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel”

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

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

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

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


  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?


    • 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


Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.