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

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

1. Multiply in Excel by using the multiplication formula
2. Copy or replicate formulas into other cells automatically

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.

## When you’re ready move onto:

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

## Or go back to:

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

### 68 thoughts on “Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel”

1. Thanks for this very helpful lesson Multiplication Formula in Excel, when I look and listen to your explanation, it seems so simple, and I have sometimes struggled with this multiplication of formulas.
I will definitely come back to your site when I need some specific knowledge from excel because you do this tutorial perfectly by showing examples and guiding us through the whole process.
Friendly greeting,
Nina

• Thank you for your feedback.

Best regards

Habib (ICT Tutor)

2. Hi Habib, thank you very much for making excel look like a walk in the park. I have tried the exercise and was surprised at how well i understood and got through it. Keep up the good job.
Janet

• Lol, I like your park example. 🙂

Thank you for your kind words.

Habib (ICT Tutor)

3. Thanks for the most important multiplication factor. Was looking forward to it since long.

Habib, have you done some PowerPoint tutorials as well. Those would be really great. I could use some.

Luv,
AB

• Hi Aparna,

That’s great to know, I’m glad you’ve found what you have been looking for.

I’m planning on doing the PowerPoint soon as well. So watch this space for that. 🙂

4. This is nice, and to be honest, I can get what you are teaching without misunderstanding. I love how you make excel formula(multiplication) looks not foreign to me since I am always scared of using excel to do calculations. Now, I know how easy it can be to executing so many calculations just with a drag.

Thanks for sharing, looking forward to you next time.
Matt

• I’m truly humbled. I want to share my knowledge with the world, so everyone can benefit from.

Glad to know my video tutorial are helpful for you.

Habib (ICT Tutor)

5. I have always had problems using Excel, some of the functions seem to be really complicated … Thanks for this detailed guide, it’s just a lifesaver for those who are not pro in Excel.

6. Learning how to create a multiplication formula in Excel, combined with scale setting and formula bar components, made this lesson come together very nicely.

You have shown us that Excel is user-friendly, in addition to being a very powerful program. Thank you for teaching us more about it.

• Hey Michael,

Many thanks for stopping by and leaving us a comment. It’s highly motivating for my to keep going and creating more useful content for you all.

Best wishes
Habib (ICT Tutor)

7. Hi Habib,
Great tutorial. You make it very easy to understand and fun to learn.

V/r

• Happy to hear that Benson, it is my pleasure 🙂

Habib (ICT tutor)

8. Wow, you explain so well – I have so easily understood how to do a multiplication formula in excel. My IT teacher tried explaining this to us in class the other day and most of did not understand it. This is why I was YouTube to see if I can get an answer. After watching some other videos, I was confused.

Then I googled to see if I can get an answer and I came across your website, and am so glad I did because you just made me understand it, in literally few minutes. I have subscribed to your YouTube channel and bookmarked your website. Thank you

• I happy very happy to hear you have finally found your answer and are fully satisfied with it. Unfortunately there are some bad teachers out there sadly. But hey, now that you have bookmarked our site and subscribed to our YouTube channel, you have nothing to worry about. You will find all answers you are looking for and if not leave me a comment and I will answer it for you. take care

Habib(ICT Tutor)

9. Hi
It was great and easy to understand.
Thanks

• Thanks. I’m glad to hear that. 🙂

10. Hi Habib, I’ve just completed this exercise.
It was very easy and your instructions were very clear, Thank you

• Excellent work Lucy. Happy to hear you found the instructions for the multiplication formula easy to follow.

Habib (ICT Tutor)

11. Hi Habib,
Great post! You make it very easy to understand how to compute formulas in Excel. Looking forward to your future posts.

Warm regards,
Sonia

12. Great video – so easy to understand!
Cheers,
Gareth

• Hi,

I wish you all the best
Habib (ICT tutor)

13. Hi Habib,

I found this video tutorial really useful and the instructions were really easy to follow along with.

Sam

• Thank you so much!

We appreciate your lovely feedback.

Best wishes
Habib

14. This was very helpful and easy to follow. Thank you.

• You’re very welcome Moriom. Complete all the lessons here and you will become quite an excel wiz. Well done

Habib

15. Hi Habib,

A brilliant website with lots of useful information. The guides and instructions are easy to understand and follow, and I look forward to the tutorial on Databases!

Barbara

• Hi Barbara,

Thank you for you lovely comments and feedback. The good news is that we will be covering all aspects of Microsoft Office including the database.

All the best
Habib

16. It great and refreshing.

Thank you

• You are welcome Mercy. I hope you take away some learnings from these. There are many more tutorials on Excel, Word, PowerPoint and Publisher coming your way very soon.

Kind Regards

Habib

17. Hi Habib,
Eid Mubarak.

This is a great tutorial video. It’s very clear and explained well in detail making it simple for students to understand.
Well done.

• Hi Pharaha, EID MUBARAK to you and your family.
I’m pleased you have enjoyed this tutorial, and was simple for you to understand. I will be making many more tutorials like this for all students to benefit. Take care

18. Great tutorial Habib. I am missing your tutorials in class but this will help build my confidence to know when I am ready to take the exam.

• Hey Alison,

That’s great to know that these videos have been useful and hopefully they helped you as much as I would have taught in the classroom.
Please keep visiting our site at https://lifestyletipsandhacks.com/ for many more useful contents like these.

Kindest regards
Habib

19. WOW Habib.
Brilliant! Your voice is perfect for this, engaging, encouraging and respectful filled with passion and enthusiasm.

I’ll look forward to the powerpiont unit!

Eid Mubarak

• Hey Chris!

Thank you for your lovely and encouraging feedback, I really appreciate it.
I will be sharing more useful videos on various subjects very soon. Please keep visiting our site at https://lifestyletipsandhacks.com/ for that.

Many thanks

Kind regards
Habib

20. A very useful video, easy to understand and follow, will help me in my course.
Thank you for sharing, can’t wait for more videos like this.

21. A really useful video. Very well explained in simple terms. Wish we could have used this from the start of the course in 2019. Looking forward to more video tutorials especially on powerpoint.

• Thank you Irene. Very encouraging words. I shall be doing more video tutorials, so please check out my website at https://lifestyletipsandhacks.com for more useful contents like these.

Many Thanks
Habib

22. I like this way of learning. I have had trouble finding the exercises on Moodle.
I prefer learning this way. I have been stressed out quite a lot studying from home, and this has made learning harder. But after watching this video, I feel like I have some inspiration again.
Thank you Habib.

• Hiya Lisa,

I’m glad to hear that this video is helping you get back into studying again and that you’ve found it inspirational. I will be doing more videos like these, so watch this space! 🙂
Please visit our site at https://lifestyletipsandhacks.com for more inspirational contents, and don’t forget to book mark it.

Many Thanks

Habib

23. Hiya Habib – I loved the video you have done, I think your students will appreciate a little encouragement like this video to confirm how they are doing, I look forward to seeing many more. Thank you

• Hi Monique,

Thank you for your feedback, I really appreciate your encouraging words. The good news is that I will be doing more videos like these and more. So, please visit our site on https://lifestyletipsandhacks.com

Kind Regards
Habib

24. Very helpful. I followed your steps and learnt a few things throughout the video.

Good work. Keep it up!

• Excellent – that’s exactly how we want our visitors to benefit. I will be creating many more video tutorials like this, so keep visiting https://lifestyletipsandhacks.com to get access to these unique video tutorials.

Habib

• Hey Masuma,

Thank you for your feedback that the video has helped you in your learnings.

Best wishes
Habib

25. Very concise, easy to understand tutorial! I learned how to use excel formulas, so thank-you so much!

• I’m happy to hear it was easy for you to understand – my aim is to make all my tutorials simple and easy for everyone. Many more tutorials to come yet…

Habib

26. Thank you for this simple multiplication formula using excel, I am sure like many of your other readers this is very valuable information they will be using often now, thanks to you.

Jeff

• Hi Jeff, You’re welcome. Formulas can be confusing, yet very easy when understood. I plan to upload many more video tutorials like this one to simplify it for my visitors. All the best

Habib

27. A great tutorial Habib well done!

Simple and straightforward to follow at a good pace.

Thanks

• Thanks Amina for your feedback. It’s very useful to know.

Kind Regards

Habib

28. Hey,

Really good video on using excel. I have used excel for years but when it comes to using the multiplications and other formulas, I am rubbish. It’s great that I have come across your article and video because this will help me with my job, and hopefully I can impress my boss by using excel to a much better standard.

Thank you for sharing such an educational and informative article and video. Keep up the great work on your site.

All the best,

Tom

• Hey Tom,

Thank you for your detailed feedback on my excel video tutorial and that it will be useful for you in your job. I am sure you have and will impress your boss with your I.T skills!

Please keep visiting our site at https://lifestyletipsandhacks.com for more educational videos like these, as many more videos tutorials are on their way.

Many Thanks

Kind regards

Habib

29. Excellent and clear. It’s a brilliant toolkit for your learners especially when you are simplifying a topic for independent study. Keep it up ~ Syedul

• That’s useful to know Syedul. I try my best to simplify learnings as much as possible. I am glad to hear you found it user friendly.

Many Thanks

Habib

• Hi Habib, the lessons are very well explained, step by step. I really enjoyed watching them. It refreshed my memory too. Thank you

• Happy to hear that Afshina – don’t forget to continue with the lessons and carry on from Lesson 2. You will go far if you complete all the lessons I have created here. Take care

Habib (ICT Tutor)

30. This is excellent Habib, with clear instructions. Well done ?

• Thanks Helen for your positive feedback. Much appreciate it. Please visit our website at https://lifestyletipsandhacks.com as many more tutorials like these are on their way.

Kindest Regards

Habib

31. Excellent video Habib, very clear and precise info which makes it easy to follow.

You speak so calmly and relaxed Habib, I think this makes learning easier.

Excellent tuition always.

• That’s very encouraging and kind of you Glynis. Please keep visiting our website for many more tutorials like this one.
Thanks
Habib

• Very welcome Habib.

• Hi Habib. I always wondered how my husband do this because it looks so difficult. But I see it is actually quite easy. Great tutorial. Easy to follow. Thank you

Chantelle

• Lol, its just alot of people get put off by Excel thinking that its all about the numbers and therefore its hard work.

It’s a very simple, easy and logical process to follow once you get into it. It’s actually quite satisfying to solve problems on Excel. 🙂

Best Wishes
Habib