In this lesson, I’m going to be showing you how to:
- Understand what is a formula in Excel
- Understand what is a function in Excel
- Understand what is the difference between a formula and function in Excel
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 🙂
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 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?
Or go back to:
Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel
Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel
Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel
Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?
Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?
Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?
Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?
Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?
Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?
Lesson 8 – What is the IF function, and how to insert it in Excel?
Lesson 7 – What is the ROUND function, and how to insert it in Excel?
Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?
Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?
Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?
Lesson 3 – Simple Subtraction Formula using Excel
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
Hi Habib,
Thanks for this explanation for another of Excel’s functions. Your lessons are great and easy to understand.
I keep coming back to your tutorials whenever I get stuck. They are a wonderful reference.
Thanks so much for creating all of these,
Suzanne
I’m happy to help Suzanne – keep coming to our site anytime you need help. Don’t forget to bookmark our site to make it easier for you to access 🙂
Habib (ICT Tutor)
Hi Habib,
Thanks for the series of excel tutorial, it’s quite helpful & useful for people who like to master excel no matter for work or just to manage personal stuff.
I am not very good at excel, so I will bookmark this page and come back often to learn the tips if I got the chance to use it.
Thanks for sharing,
Matt
Yes Matt, it is useful for everybody wanting to learn excel as it is a valuable software, which is needed in every part of our life whether its personal or business. Happy to hear you have bookmarked our site as many more tutorials are on their way.
Habib (ICT Tutor)
Hi there,
Super useful tutorials as always. I have to review some lessons that I’ve forgotten.
It’s easy to understand. 🙂
Thanks and all the best
Kumponchai
We all need to review and revise on our knowledge and skills – my tutorials are perfect for new learners or existing learners wanting to brush-up on their skills. Thank you for the compliment Kumponchai 🙂
Habib (ICT Tutor)
Thanks for the information. While I don’t use Excel too much myself, I know someone who does and this article will be very useful.
You should train yourself up too John, you don’t know when you will need the excel skills. But by all means help the person out and pass my website and YouTube channel to them. Here is the direct link to my channel: https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg
Habib (ICT Tutor)
Very informative content and the website is well organized, it is so easy to find the right content and navigate through. You explain everything in-depth and in the easiest way possible, Thanks!
Happy to help and thank you for the kind words – I am doing my best for everyone to get free knowledge and skills. Take care
Habib (ICT Tutor)
This clarified so much, thank you for your help again!!! SO happy I found your page, please keep the videos coming!
You are welcome! Please keep visiting our site at https://lifestyletipsandhacks.com/ and YouTube channel here https://www.youtube.com/channel/UCBfGJLMmTIA3ESh9DFYWLIg?view_as=subscriber
Many Thanks
Habib (ICT tutor)
Thanks again, Your lessons (and their titles) make it really easy to find the answers to excel user issues. I personally use Numbers on an Apple Macbook, but the functionality has similarities! Thanks again.
You’re welcome Angelique. Thank you for the compliment. I am doing my best to make the navigation to the lessons and the lessons themselves to be as simple as possible, for anyone to understand. Take care
Habib (ICT Tutor)
Those formulas in Excel make everything so easy! It saves you from doing maths 😉 I often used these formulas at a previous job. Once you get the hang of it, it becomes simple and straightforward to use it.
Yes Christine, most mathematical calculations are done and automated for you via functions and formulas in excel. Thanks for sharing your comment.
Habib (ICT Tutor)
This is great. I took an excel class in college and I had a hard time with the simple things, I basically faked my way thru the assignments ha! This broke it up so simply. Thank you!
I’m happy to help. Well now you won’t be faking through it, if you had to study excel again 🙂 Take care
Habib (ICT Tutor)
Hi
Thanks for this. I have used formulae and functions in Excel for years and never known the specificity of the difference. I have found POWER to be a useful function for doing net present value and compound interest calculations. I’ve seen though that there are a vast number of formulae. It seems such a shame that there is so much power out there that is so little used. Thanks for this. Best regards, Andy
You are spot on Andy. I want to bring this power of knowledge to peoples attention and make them realise how much they can do with excel, and so easily. Thanks for your lovely comment.
Habib (ICT Tutor)
This is really great! Nice and easy to understand! Whether you are a novice or if it is just to refresh your memory, this is a great tool!
Thank you for sharing your comment with us. Take care
Habib (ICT Tutor)
A really useful lesson Habib. Thank you very much. I use Excel regularly but a refresh is always useful. I will check out the rest of the posts as well 🙂
Refreshing our skills always helps. Start from lesson 1 to make the most of my tutorials. Take care
Habib (ICT Tutor)
A useful tutorial Habib. My Excel skills are limited at best (I always use to hand it over to one of my Actuarial colleagues) so apart for the basic adding up cells the whole function concept is new to me. Thanks for the clear understanding – very helpful.
Welcome Jason – happy to help. Now you know how to do the formulas and functions yourself, you won’t need to rely on anybody else. Keep following my tutorials and you will go a long way. Take care
Habib (ICT Tutor)
I’m not good at math, haha but this video made it really easy for me to make formulas. And I did in fact did the whole (=E2+ E3 + E4 etc) since I didn’t know how to make heads or tails on excel haha. So this tip is a real time saver!
Another great tutorial vid Habib Ali!
A lot of people do that Kevin – this is why it is so important to understand when to use a formula and when to use a function. Take care
Habib (ICT Tutor)