Conditional Formulas
Excel 2010 (Windows)
| Intermediate
- 9 Videos | 43m 36s
- Earns a Badge
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.
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 formula6m 9sUP NEXT
-
2.Inserting a conditional message formula5m 4s
-
3.Performing complex conditional formulas5m 22s
-
4.Creating multiple conditions5m
-
5.Using IF & OR in conditional formulas4m 58s
-
6.Using conditional formulas to count up value occurrences3m 26s
-
7.Translating data in your worksheet6m 5s
-
8.Using reference positions in conditional formulas4m 19s
-
9.Keeping your table up to date with conditional formulas3m 15s
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.