Lesson 9: Simple Subtraction Formula in Excel

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

  1. Use the Subtraction formula 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 10: How to use the INSERT FUNCTION command in Excel?

Or go back to:

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

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

76 thoughts on “Lesson 9: Simple Subtraction Formula in Excel”

  1. Hi Habib,

    Thanks for teaching us how to use subtraction for excel reports. You’ve made it comprehensive and easy to follow, and I am sure that excel newbies can get what they like to know when they first land on this post to learn excel subtraction.

    The double click to make the following cells also do the calculation is convenient, so thanks for this lovely tutorial. It helps a lot.

    Cheers,
    Matt

    Reply
    • Hi Matt,

      Many thanks for your stopping by and leaving us a lovely feedback. It’s highly appreciated.

      I’m humbled to hear you are benefiting from my Microsoft Tutorials.

      All the best

      Habib (ICT Tutor)

      Reply
  2. Hi Habib!
    Thank you for the video!
    You explained everything very clear and you must be an expert of this. Actually, I knew about the existence of Excel since it is installed on my laptop but never used it, because the field I’m working is art. But I see how could it be useful. And I will consider to use it when it will be the case.
    Thank you!
    Alex

    Reply
    • This is great to know Alex. Microsoft Excel is highly useful in lots of aspects of your life from budgeting to creating graphs/charts and also for calculation.

      Thank for your feedback.

      Best of luck

      Habib (ICT Tutor)

      Reply
  3. I still do a lot of sums by heart – mental arithmetic was a topic at school, is that still the case? – but it gets harder. Ultimately, there are so many functions in Excel, as you always so aptly describe, that make our calculating life easier.
    I like to be able to choose from both methods, mental arithmetic and using Excel.
    Thanks for the explanation, Habib.

    Reply
  4. Ok I almost made a big mistake by not doing this lesson. I mean come on it’s subtraction right? It’s pretty straight forward, so I thought. But then I thought, “no, this is Habib, he may have some tricks to share so I better do it anyway”.

    And yes, you did have some awesome tips that I have never used in all the years using Excel. I couldn’t believe it, even using simple subtraction you were still able to offer unique short cuts to shave off a little more time.
    Thanks again Habib your lessons are the best.

    Reply
  5. Although I already knew this Excel function, when I watched your video I suddenly realized how I never even thought of using it for certain niches. This can be used for travel and any other activities you want to keep a record of. Excel works perfectly for that. Thanks for this great lesson!

    Reply
  6. Another great tutorial as always. Great to learn a new trick. Thanks for the clear and easy explanation.

    Reply
  7. Hey man
    Thank you for the tutorial. Although I had already known how to use the subtract but some tips you provided here were very helpful. You are really and expert in this space. well done.

    Very well detailed and as I said before this is my go to channel for checking anything for excel

    Reply
    • Hi Thabo,

      Great to hear from you and to receive your feedback. It’s very much appreciated that even you know the Excel but you are still benefiting from my tutorials.

      Wishing you all the best

      Habib (ICT Tutor)

      Reply
  8. Thank you for this lesson on simple subtraction formula in Excel. And also for the reminder to pay attention to the details to make sure that the values are being entered correctly into the formulas.

    I like the handiness of replicating the formula by using the fill handle, as well as double-clicking the cross.

    Another informative and interesting lesson!

    Reply
  9. Thanks for the great explanation of the Subtraction formula in Excel. If you use Excel often, such knowledge and tricks to make your work easier are very useful.
    I like to look at your tutorials because you explain perfectly and show an explanation on a specific case.
    It is also great, and I would recommend anyone who needs to upgrade this knowledge to work with you on one of their own cases, because you remember the most if you try it yourself in practice.

    Friendly greeting,
    Nina

    Reply
  10. Hi,

    I really enjoyed this tutorial, it was explained and broken down well so it was easy to understand. I spent many years working with excel in various jobs with the last being Business Analyst, where I use to use formulas on a daily basis.

    Excel is an excellent tool to use when you get the grasp of it.

    Thank you for an excellent post.

    All the best,
    Adam

    Reply
    • Hi Adam,

      Many thanks for your lovely feedback. Glad to hear you found my tutorials and teaching style easier to understand and follow.

      Regards

      Habib (ICT Tutor)

      Reply
  11. I didn’t actually know this was possible in Excel, and it can certainly help me keep track of sales and profits. I only have Excel 2007 at the moment and I’m sure you’re using a more up to date version. I’ve bookmarked this page so I can come back again and follow your other lessons.

    Reply
    • Hi Kathy,

      Thank you for your feedback.

      I’m using the Microsoft Office 365 but 2007 version is absolutely fine too.

      You can also check my YouTube channel out here for more Excel tutorials.

      All the best

      Habib (ICT Tutor)

      Reply
  12. Your blog is a godsend for me. I try to keep track of all my business affairs in Excel, but sometimes some functions seem complicated to me, I constantly have to read how to do it … I will subscribe to your YouTube channel to look for answers to my questions from you. Very detailed and understandable presentation. Thanks!

    Reply
    • Hi,

      Many thanks for your lovely feedback. It’s very much much appreciated. Glad to hear you are benefitting from my Microsoft Excel tutorials so far. I have a plan to make many more videos around whole of the Microsoft office. So look out for that.

      All the best

      Habib (ICT Tutor)

      Reply
    • Hi Gorjan – this lesson is done now. It is available here on my site and on my YouTube channel. Thanks for your patience 🙂

      Habib (ICT tutor)

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

      Reply
      • Awesome. Thanks for the update.

        I learned that we can double click on bottom right of a cell to duplicate it!
        This is much easier that copying a cell’, information and draging it to paste into the other cells. Very usefull.
        Many thanks 🙂

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

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

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

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

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

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

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

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

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

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

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

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

      Reply
  19. 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,
    Michael.

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

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

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

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

    Reply
    • 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. 🙂

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

    Jeff

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

      Habib

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

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

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

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

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

    V/r
    Benson

    Reply

Leave a comment