Using Conditional Formulas
Excel 2019 (Windows)
| Intermediate
- 8 Videos | 38m 20s
- Includes Assessment
- Earns a Badge
- CPE
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Conditional Formulas Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
insert a conditional sum formulainsert a conditional message formulause complex conditional formulascreate multiple conditions
-
use IF & OR in conditional formulasuse conditional formulas to count up value occurrencesuse reference positions in conditional formulasuse conditional formulas to keep tables up to date
IN THIS COURSE
-
1.Inserting a conditional sum formula5m 13sUP NEXT
-
2.Inserting a conditional message formula4m 53s
-
3.Performing complex conditional formulas5m 2s
-
4.Creating multiple conditions5m 27s
-
5.Using IF & OR in conditional formulas5m 50s
-
6.Using conditional formulas to count up value occurrences3m 25s
-
7.Using reference positions in conditional formulas5m 5s
-
8.Keeping your table up to date with conditional formulas3m 25s
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.