Excel 2013: 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.9

Lesson Objectives

Excel 2013: 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

Keeping your table up to date with conditional formulas

Translating data in your worksheet

Using reference positions in conditional formulas

Course Number:
ds_msex2013_16_enus

Expertise Level
Intermediate