# Using conditional formulas in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
• 9 Videos | 31m 1s
• Includes Assessment
• CPE
• PMI PDU
Conditional formulas let you perform calculations in Excel 365 on a range of values by specifying the criteria the data must meet. In this course, discover how to use built-in conditional formulas and create your own. Key concepts covered in this course include how to insert a conditional SUM formula to perform a sum calculation on certain data values; insert a conditional message formula that can be used to display one message if a condition is met, and another if a condition is not met; check if a value is not equal to another; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. You will also explore how to create multiple conditions; how to use IF and OR in conditional formulas; and how to use conditional formulas to count up value occurrences or call out data. Finally, you will learn to use reference positions in conditional formulas and analyze data ranges with conditional formulas.

## WHAT YOU WILL LEARN

• discover the key concepts covered in this Microsoft 365: Using conditional formulas in Excel 365 course insert conditional SUM formulas in Excel 365 insert a conditional message formula in Excel 365 create complex conditional formulas by combining functions in Excel 365 create a formula with nested functions in Excel 365
• use conditional formatting rules to highlight data in Excel 365 use conditional formulas to count up value occurrences in Excel 365 use IF, OR, and NOT in conditional formulas in Excel 365 use reference positions in conditional formulas in Excel 365

## IN THIS COURSE

• 1.
Course Overview: Using conditional formulas in Excel 365
• 2.
Inserting a conditional SUM formula
• 3.
Inserting a conditional message formula
• 4.
Using complex conditional formulas
• 5.
Creating a formula with nested functions
• 6.
Calling out data with conditional formatting
• 7.
Counting up value occurrences
• 8.
Using IF, OR, and NOT in conditional formulas
• 9.
Using reference positions in 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.