# Using conditional formulas in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
• 9 videos | 31m 1s
• Includes Assessment
• CPE
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. In order to practice what you have learned, you will find practice exercises and samples in the Resources section.

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

• This video outlines the key content covered in the Microsoft 365: Using conditional formulas in Excel 365 course, including how to use complex conditional formulas, create a formula with nested functions, and how to use reference positions in conditional formulas.
• In Excel 365, you can use the SUMIF and SUMIFS functions to perform a conditional sum calculation on a cell range based on certain criteria being met. In this video, you will explore how to insert and use conditional SUM formulas in Excel 365.
• 3.  Inserting a conditional message formula
The IF function is made up of a range, a condition, a value if true, and a value if false. It can be used to display one message if a condition is met and another if the condition is not met. In this video, you will explore how to use the IF function to insert a conditional message formula in Excel 365. This video aligns with the MOS MO-200 / Excel Associate Certification exam objective: 4.2.3 Perform conditional operations by using the IF() function.
• 4.  Using complex conditional formulas
In Excel 365, the IF function can be used in conjunction with other functions to create a complex formula. With conditional formulas, you can create conditions based on calculations and analyze your data in a variety of different ways. In this video, you will explore how to combine conditional functions in a formula in Excel 365.
• 5.  Creating a formula with nested functions
If you want to return more than two possible messages in Excel, you can. You can use nested functions within a formula in order to obtain results based on multiple criteria. In this video, you will explore how to create a formula with nested functions in Excel 365.
• 6.  Calling out data with conditional formatting
If you have a lot of data to analyze in a short time, you can use conditional formatting rules to highlight specific cells, rows, or columns. In this video, you will explore how to call out data with conditional formatting rules in Excel 365. This video aligns with MOS MO-200 / Excel Expert Certification exam objective: 2.3.2 Create conditional formatting rules that use formulas.
• 7.  Counting up value occurrences
In Excel 365, you can use conditional formulas with functions such as SUMPRODUCT to extract specific values from an existing data table. This can be very useful if you are looking to find the total number of purchases in a particular date range. In this video, you will explore how to use conditional formulas to count up value occurrences in Excel 365.
• 8.  Using IF, OR, and NOT in conditional formulas
In Excel 365, you can perform logical operations, such as using the NOT function, to check if one value is not equal to another. You can even combine qualifying and alternative conditions such as combining the OR and IF functions in a formula. In this video, you will explore the IF, OR, and NOT logical functions in conditional formulas in Excel 365. This video aligns with MOS MO-200 / Excel Associate Certification exam objective: 4.2.3 Perform conditional operations by using the IF() function and MOS MO-201 / Excel Expert Certification exam objective: 3.1.1 Perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions.
• 9.  Using reference positions in conditional formulas
In Excel 365, you may sometimes need to find a cell value by using its positional coordinates in the table. You can do this with the MATCH and OFFSET formulas. In this video, you will explore how to use reference positions with conditional formulas in Excel 365. This video aligns with MOS MO-200 / Excel Expert Certification exam objective: 3.2.1 Look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions.

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.