Using Conditional Formulas

Excel 2019 (Windows)    |    Intermediate
  • 8 Videos | 50m 20s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 52 Likes 52
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 in this 8-video course. Key concepts covered in this course include how to insert a conditional sum formula to perform a sum calculation on certain data values in your range; how to insert a conditional message formula which can be used to display one message if a condition is met, and another if a condition is not met; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. Learners will continue by observing how to create multiple conditions; how to use IF & OR in conditional formulas; and how to use conditional formulas to count up value occurrences. Finally, you will learn to use reference positions in conditional formulas; and learn how to keep your table up to date with conditional formulas.

WHAT YOU WILL LEARN

  • insert a conditional sum formula
    insert a conditional message formula
    use complex conditional formulas 
    create multiple conditions
  • use IF & OR in conditional formulas
    use conditional formulas to count up value occurrences
    use reference positions in conditional formulas
    use conditional formulas to keep tables up to date

IN THIS COURSE

  • Playable
    1. 
    Inserting a conditional sum formula
    5m 13s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional message formula
    4m 53s
  • Locked
    3. 
    Performing complex conditional formulas
    5m 2s
    FREE ACCESS
  • Locked
    4. 
    Creating multiple conditions
    5m 27s
    FREE ACCESS
  • Locked
    5. 
    Using IF & OR in conditional formulas
    5m 50s
    FREE ACCESS
  • Locked
    6. 
    Using conditional formulas to count up value occurrences
    3m 25s
    FREE ACCESS
  • Locked
    7. 
    Using reference positions in conditional formulas
    5m 5s
    FREE ACCESS
  • Locked
    8. 
    Keeping your table up to date with conditional formulas
    3m 25s
    FREE ACCESS

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

COURSE Working with Excel Tables
Likes 212 Likes 212  
COURSE Performing Calculations in Tableau Desktop
Likes 43 Likes 43  
COURSE Getting to Know Macros
Likes 94 Likes 94  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Formatting Data
Likes 176 Likes 176  
COURSE Using Basic Formulas
Likes 266 Likes 266  
COURSE Finding & Grouping Data
Likes 41 Likes 41