Conditional Formulas
Excel 2013 (Windows)
| Intermediate
- 9 Videos | 51m 43s
- Earns a Badge
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.
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
Keeping your table up to date with conditional formulas
Translating data in your worksheet
Using reference positions in conditional formulas
IN THIS COURSE
-
1.Inserting a conditional sum formula6m 51sUP NEXT
-
2.Inserting a conditional message formula4m 22s
-
3.Performing complex conditional formulas6m 9s
-
4.Creating multiple conditions6m 53s
-
5.Using IF & OR in conditional formulas5m 25s
-
6.Using conditional formulas to count up value occurrences3m 36s
-
7.Keeping your table up to date with conditional formulas7m 28s
-
8.Translating data in your worksheet5m 4s
-
9.Using reference positions in conditional formulas5m 56s
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.
