Course details

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