Lesson 44 – Use the IF function to work out if you are over BUDGET or not in Excel

In this lesson, I’m going to be showing you how to: How to use the IF function to work out, if over budget or not in Excel Manually typing in the full IF function Use the function key to do the IF function Go ahead, open the video below and watch the tutorial at your … Read more

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

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: … Read more