Using Conditional Formulas

Excel 2016 (Windows)
  • 9 Videos | 44m 42s
  • Includes Assessment
  • Earns a Badge
Likes 70 Likes 70
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

  • Playable
    1. 
    Inserting a conditional sum formula
    7m 9s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional message formula
    4m 31s
  • Locked
    3. 
    Performing complex conditional formulas
    5m 6s
  • Locked
    4. 
    Creating multiple conditions
    5m 21s
  • Locked
    5. 
    Using IF & OR in conditional formulas
    4m 43s
  • Locked
    6. 
    Using conditional formulas to count up value occurrences
    2m 33s
  • Locked
    7. 
    Translating data in your worksheet
    5m 34s
  • Locked
    8. 
    Using reference positions in conditional formulas
    3m 35s
  • Locked
    9. 
    Keeping your table up to date with conditional formulas
    2m 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

Likes 0 Likes 0  
Likes 114 Likes 114  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 203 Likes 203  
Likes 282 Likes 282  
Likes 79 Likes 79