Using Conditional Formulas
Excel 2016 (Windows)
| Intermediate
- 9 Videos | 41m 12s
- Includes Assessment
- Earns a Badge
In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.
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 occurrencesTranslating data in your worksheetUsing reference positions in conditional formulasKeeping your table up to date with conditional formulas
IN THIS COURSE
-
1.Inserting a conditional sum formula7m 9sUP NEXT
-
2.Inserting a conditional message formula4m 31s
-
3.Performing complex conditional formulas5m 6s
-
4.Creating multiple conditions5m 21s
-
5.Using IF & OR in conditional formulas4m 43s
-
6.Using conditional formulas to count up value occurrences2m 33s
-
7.Translating data in your worksheet5m 34s
-
8.Using reference positions in conditional formulas3m 35s
-
9.Keeping your table up to date with conditional formulas2m 39s
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.