Excel 2016: Using Conditional Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.

Expected Duration (hours)
0.7

Lesson Objectives

Excel 2016: Using Conditional Formulas

  • Inserting a conditional sum formula
  • Inserting a conditional message formula
  • Performing complex conditional formulas
  • Creating multiple conditions
  • Using IF & OR in conditional formulas
  • Using conditional formulas to count up value occurrences
  • Translating data in your worksheet
  • Using reference positions in conditional formulas
  • Keeping your table up to date with conditional formulas

    • Course Number:
    ds_msex2016_15_enus

    Expertise Level
    Intermediate