# Using Conditional Formulas

Excel 2019 (Windows)    |    Intermediate
• 8 Videos | 50m 20s
• Includes Assessment
• CPE
• PMI PDU
Likes 52
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.

## WHAT YOU WILL LEARN

• insert a conditional sum formula
insert a conditional message formula
use complex conditional formulas
create multiple conditions
• use IF & OR in conditional formulas
use conditional formulas to count up value occurrences
use reference positions in conditional formulas
use conditional formulas to keep tables up to date

## IN THIS COURSE

• 1.
Inserting a conditional sum formula
• 2.
Inserting a conditional message formula
• 3.
Performing complex conditional formulas
• 4.
Creating multiple conditions
• 5.
Using IF & OR in conditional formulas
• 6.
Using conditional formulas to count up value occurrences
• 7.
Using reference positions in conditional formulas
• 8.
Keeping your table up to date with conditional formulas

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

Likes 212
Likes 43
Likes 94

Likes 176
Likes 266
Likes 41