# Using Conditional Formulas

Excel Microsoft 365 (Windows)
• 8 Videos | 43m 42s
• Includes Assessment
Likes 114
This 8-video course explores how to use built-in formulas to perform a calculation on a range of values in Excel for Office 365. You will begin by learning how to insert a conditional sum using SUMIF formulas to perform a sum calculation on selected data values in your range. You will next learn how to use the IF function to determine whether a condition is met or not met, and to use the IF function in conjunction with other formulas. This course continues by demonstrating how to embed multiple IF formulas within one another to obtain multiple result options. You will learn to combine qualifying and alternate conditions using the IF and OR in conditional formulas. Next, learners will observe how to use Conditional Formulas to count value occurrences. You will learn to use reference positions in Conditional Formulas. Finally, this course demonstrates how to keep your table up to date with Conditional Formulas by using formulas such as COUNTA and OFFSET.

## WHAT YOU WILL LEARN

• 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

## 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 1
Likes 0
Likes 132

Likes 132
Likes 206
Likes 886