Lesson 3 – Simple Subtraction Formula using Excel

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

  1. Create a subtraction formula
  2. Insert a new row
  3. Replicate a formula
  4. Why we use cell references
  5. Display the formulas/functions on the screen to print off
  6. Save an Excel file as a Template

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

Note: a NEW lesson 3 VIDEO is coming soon – sorry for the inconvenience

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 4 – What is an AVERAGE function, and how to insert it in Excel?

Or go back to:

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

44 thoughts on “Lesson 3 – Simple Subtraction Formula using Excel”

    • Hi Andrew,

      I’m in the process of uploading it. So hopefully by the end of this week. In the mean time, continue from lesson 14.

      All the best

      Habib (ICT Tutor)

    • You’re welcome Benson – you are our regular visitor and I always love a comment from yourself. So, thank you and keep on learning – there are many more lessons to go through and a wealth of knowledge waiting for you 🙂

      Habib (ICT tutor)

    • Thank you Peter – hope you have understood the subtraction formula thoroughly, if not please watch the video as many times as you like. Take care

      Habib (ICT Tutor)

  1. Hi
    Great teaching. I have been going through all lessons over and over and it’s been really great.

  2. Nice Job, thank you so much for sharing these tutorials with us. They are very helpful, as at this moment our classes are closed in college, so I am learning so much from your amazing tutorials.

    • You’re very welcome Bola. I’m happy to help and allow you to continue with your education by you following my video lessons. If you need any further help or have a question, just leave it in the comments section and I will get back to you. Take care

      Habib (ICT Tutor)

  3. Hi Habib. This tutorial is very easy to follow. You explain everything very clearly, you don’t move too fast. You also don’t speak too fast. That’s great and it gives you time to take everything in. I enjoyed it. Thanks

  4. Very well explained tutorial. I now understand why we save spread sheets as templates and the difference between a workbook and template.
    Thank you for this explanation.

    • Happy to hear you have understood the difference between a workbook and a template in Excel. This can be confusing, but I hope I have made it crystal clear for you. Take care

      Habib (ICT Tutor)

  5. I Have just watched the subtraction video. It is simple and very practical. I like the way you present it – the word doc makes it easier to follow. I use this formula on a daily basis and it is really important if you want to work with excel. Everybody in on point needs to use it. Well done and keep sharing.

    • Having a question faced to the viewer makes it easier and puts yourself in a scenario and then tackle the issue by showing and explaining how a simple subtraction formula is the solution. Thanks for your comment.

      Habib (ICT Tutor)

  6. Hey Habib,

    Great video and article. I am really learning a lot about excel and it’s great that I can now use excel in my job as a project manager. My role is to keep on top of the budget and the hours that my team are doing each day. Using the excel formula’s I have learned from you, that part of my job has become a lot easier. I have even helped other members of my team with their excel work too

    Thank you for sharing and keep up the great work.

    All the best,


    • Tom, I am so happy to hear that I have helped you so much with my tutorials. Your job is easier and you’re helping your colleagues at work. This is main aim of these tutorials. Many will follow, so bookmark my site and keep coming. Have a great day. Habib

  7. Been a while since I have used spreadsheets and this was great little refresher.

    You explain things relly well, like a school teacher would, so that anyone can understand but also not holding hands.

    Excellently written and planned.

    This site has been bookmarked and I will be coming back for reference when I need it.

    Thank you,

    • Thank you for your feedback Michael. I am an ICT tutor, hence it’s in my nature to explain and demonstrate in a method that anyone would understand instantly. Good thing you’ve bookmarked our site, as many more tutorials are on their way. See you soon on our site. Take care

  8. What a wonderful idea, to make a series of tutorials on Excel! Even more so, as you do explain very clearly, very understandable, with an example right away. You take out all the uncertainty, so I can imagine it being very easy even for an absolute beginner. I’ started learning Excel decades ago, from a 1000 page book, which was so complicated, that I went on on my own, making a ton of mistakes, correcting them and learning from them. I’m in peace with the program now, but I wish I had access then to such a good tutorial as yours is. Thanks for doing it so well.

    • Thank you so much Minaher for your kind words. You’ve touched my heart and have motivated me further to keep going and creating such tutorials, so people like yourself will continue to benefit from our site forever. Take care
      Habib (ICT Tutor)

  9. Wow I love Excel, and because I don’t use it regularly I always forget how to do the formulas. They are one of those things that are necessary to remember, so thank you for the refresher.
    I really enjoyed the tutorial. Great job.

    • Hey Cory, pleasure to help you out. We all need a refresher now and again. Thank you for the compliment. Don’t forget to visit us, as many more tutorials are coming. 🙂

  10. Thank you for sharing this lesson on Excel, I learned so much since I have never had any experience with Excel other than the name. How long do you think it would take someone with no prior experience to learn a program such as Excel, so how long have you been using this program?


    • Excellent, I’m happy to hear you have learnt so much – that is our aim of our website.
      If you follow and complete all my lessons, starting from lesson 1, then it wont take you long. When you come to the end of the lessons, you will be quite a pro.
      I am an ICT tutor Jeff, and have been using Excel for a very long time – since my school days. I love it!


  11. To be honest, I didn’t know the first thing about doing a simple subtraction formula with the help of Excel.
    I feel like I know enough now!
    The way you explain it made everything so easy and simple.
    Great job, I’m bookmarking the page for future reference.
    Thanks for sharing!

    • You’re very welcome Boby – now that you have bookmarked our site lifestyletipsandhackslifestyletipsandhackslifestyletipsandhacks, you will find many more helpful tutorials that you can follow and learn many more skills on Excel and other Microsoft programs.

  12. Thank you, for your explanation. I always had so much problem with excel. I always wanted to use excel for my own money counting to control my spending’s. I hope future lessons will be as easy and interesting to understand.

    • Many people like yourself have problems using excel as it is a technical package, however, if explained correctly one can understand easily. I’m happy to hear you found the lesson easy and interesting to follow and understand. Don’t forget to bookmark it, as many more are on their way.

  13. Hi Habib,
    Wow!!! amazing tutorial of doing simple subtraction formula with using Excel Spreadsheets. You made it so easy to understand especially for someone who has no clue with Excel usage. The recording is also very clear.
    Great job and thanks. I will be sharing this post with friends to help them out.



Leave a comment

Share via
Copy link
Powered by Social Snap