Conditional Formulas

Excel 2013 (Windows)
  • 9 Videos | 51m 43s
  • Earns a Badge
Likes 20 Likes 20
Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.

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
    Keeping your table up to date with conditional formulas
    Translating data in your worksheet
    Using reference positions in conditional formulas

IN THIS COURSE

  • Playable
    1. 
    Inserting a conditional sum formula
    6m 51s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional message formula
    4m 22s
  • Locked
    3. 
    Performing complex conditional formulas
    6m 9s
  • Locked
    4. 
    Creating multiple conditions
    6m 53s
  • Locked
    5. 
    Using IF & OR in conditional formulas
    5m 25s
  • Locked
    6. 
    Using conditional formulas to count up value occurrences
    3m 36s
  • Locked
    7. 
    Keeping your table up to date with conditional formulas
    7m 28s
  • Locked
    8. 
    Translating data in your worksheet
    5m 4s
  • Locked
    9. 
    Using reference positions in conditional formulas
    5m 56s

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 21 Likes 21  
Likes 0 Likes 0  
Likes 27 Likes 27  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 139 Likes 139  
Likes 704 Likes 704  
Likes 633 Likes 633