Course details

Excel Office 365: Using Conditional Formulas

Excel Office 365: Using Conditional Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.



Expected Duration (hours)
0.7

Lesson Objectives

Excel Office 365: 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
  • using reference positions in conditional formulas
  • keeping your table up to date with conditional formulas
  • Course Number:
    ds_msex365_18_enus

    Expertise Level
    Intermediate