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 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
Translating data in your worksheet
Using reference positions in conditional formulas
Keeping 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.YOU MIGHT ALSO LIKE
COURSE
Using macros in Excel 365
