In this lesson, I’m going to be showing you how to:
- Understand, what the INSERT FUNCTION button is for
- Use the INSERT FUNCTION button to create the following functions:
– AVERAGE function
– MINIMUM function
– MAXIMUM function
– COUNT(A) function
– ROUND function
– IF function
Go ahead, open the video below and watch the tutorial at your own pace:
Note: a NEW lesson 9 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 🙂
Thanks for watching!
When you’re ready move onto:
Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?
Or go back to:
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