Excel - IF, CountIF, SumIF and AverageIF | Simon Lambourne | Skillshare

Excel - IF, CountIF, SumIF and AverageIF

Simon Lambourne, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (49m)
    • Excel IF, CountIF, SumIF, AverageIF Course Outline

    • Introduction to IF Statements

    • Creating IF Statements

    • CountIF

    • SumIF

    • AverageIF


About This Class

IF Statements are powerful formulas used to perform a test against a cell or value. They can then give an answer based upon the result of that test. Check out this course to learn what IF Statements can be used for, how to set them up, the logical operators and much more.

We'll also explore other useful formulas that work with IF Statements, such as:


These are great when you need to summarise large amounts of data, into a manageable, easy to understand report.





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Simon Lambourne

Microsoft Certified Trainer

I have been an IT trainer for over 9 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it is important to enjoy attending each t...

See full profile

Report class