Conditional Formulas

Excel 2010 (Windows)    |    Intermediate
  • 9 Videos | 43m 36s
  • Earns a Badge
Likes 21 Likes 21
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 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
    6m 9s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional message formula
    5m 4s
  • Locked
    3. 
    Performing complex conditional formulas
    5m 22s
  • Locked
    4. 
    Creating multiple conditions
    5m
  • Locked
    5. 
    Using IF & OR in conditional formulas
    4m 58s
  • Locked
    6. 
    Using conditional formulas to count up value occurrences
    3m 26s
  • Locked
    7. 
    Translating data in your worksheet
    6m 5s
  • Locked
    8. 
    Using reference positions in conditional formulas
    4m 19s
  • Locked
    9. 
    Keeping your table up to date with conditional formulas
    3m 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Tools
Likes 72 Likes 72  
Likes 40 Likes 40  
Likes 21 Likes 21