Using conditional formulas in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 9 videos | 31m 1s
- Includes Assessment
- Earns a Badge
- 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 Course Contents pane or 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
-
45sThis 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. FREE ACCESS
-
4m 31sIn 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. FREE ACCESS
-
3. Inserting a conditional message formula2m 15sThe 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. FREE ACCESS
-
4. Using complex conditional formulas4m 26sIn 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. FREE ACCESS
-
5. Creating a formula with nested functions3m 50sIf 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. FREE ACCESS
-
6. Calling out data with conditional formatting4m 34sIf 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. FREE ACCESS
-
7. Counting up value occurrences2m 59sIn 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. FREE ACCESS
-
8. Using IF, OR, and NOT in conditional formulas3m 45sIn 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. FREE ACCESS
-
9. Using reference positions in conditional formulas3m 55sIn 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. FREE ACCESS
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.
