Conditional Formulas

Excel 2010 (Windows)    |    Intermediate
  • 9 Videos | 45m 6s
  • 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.

YOU MIGHT ALSO LIKE

Likes 52 Likes 52  
COURSE Managing Data
Likes 50 Likes 50  
Likes 33 Likes 33  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 12 Likes 12  
Likes 704 Likes 704  
Likes 34 Likes 34