### 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