Course details

Excel 2019 for Windows: Using Conditional Formulas

Excel 2019 for Windows: 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 in this 8-video course. Key concepts covered in this course include how to insert a conditional sum formula to perform a sum calculation on certain data values in your range; how to insert a conditional message formula which can be used to display one message if a condition is met, and another if a condition is not met; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. Learners will continue by observing how to create multiple conditions; how to use IF & OR in conditional formulas; and how to use conditional formulas to count up value occurrences. Finally, you will learn to use reference positions in conditional formulas; and learn how to keep your table up to date with conditional formulas.



Expected Duration (hours)
0.6

Lesson Objectives

Excel 2019 for Windows: 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_msex2019_18_enus

    Expertise Level
    Intermediate