Using Conditional Formulas in Excel 2016 for Windows
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 formula in Excel 2016 for Windows7m 9sUP NEXT
-
2.Inserting a conditional message formula in Excel 2016 for Windows4m 31s
-
3.Performing complex conditional formulas in Excel 2016 for Windows5m 6s
-
4.Creating multiple conditions in Excel 2016 for Windows5m 21s
-
5.Using IF & OR in conditional formulas in Excel 2016 for Windows4m 43s
-
6.Using conditional formulas to count up value occurrences in Excel 2016 for Windows2m 33s
-
7.Translating data in your worksheet in Excel 2016 for Windows5m 34s
-
8.Using reference positions in conditional formulas in Excel 2016 for Windows3m 35s
-
9.Keeping your table up to date with conditional formulas in Excel 2016 for Windows2m 39s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.