Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Excel Formulas - IF Statements and Logic

Simon Lambourne, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (48m)
    • Introduction to IF Statements

      5:27
    • Creating IF Statements

      14:26
    • CountIF

      12:37
    • SumIF

      8:55
    • AverageIF

      6:46

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:

  • SUMIF
  • COUNTIF
  • AVERAGEIF

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

2

Students

--

Projects

0

Reviews (0)

Simon Lambourne

Microsoft Certified Trainer

I have been an IT trainer for over 8 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 training co...

See full profile