Introduction and Unit Objectives

Excel is the best tool non programmers have in order to write code, that’s why it wins.” — antirez on HackerNews


Nothing puts a shiver down a new Excel user’s back like conditional formulas. In this unit we will take our time and explain conditional formulas, the IF, SUMIF, AVERAGEIF, and COUNTIF in a easy to understand way. Before we are done with this unit you will be able to use, with confidence, these powerful tools that scare so many. 

Unit Objectives: 

  • Describe and use the IF function to perform a basic logical operation
  • List the proper structure of a nested IF function
  • Describe and use the SUMIF function to perform a basic logical operation
  • Describe and use the AVERAGEIF function to perform a basic logical operation
  • Describe and use the COUNTIF function to perform a basic logical operation

Download
Discussion

0 comments