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 formulaInserting a conditional message formulaPerforming complex conditional formulasCreating multiple conditionsUsing IF & OR in conditional formulas
-
Using conditional formulas to count up value occurrencesKeeping your table up to date with conditional formulasTranslating data in your worksheetUsing 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.