Using Conditional Formulas

Excel 2019 (Windows)    |    Intermediate
  • 8 Videos | 38m 20s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 112 Likes 112
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Conditional Formulas Exercise as well as the associated materials in the Resources section.

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 Performing Conditional Calculations
COURSE Referencing Data
Likes 123 Likes 123  
COURSE Using Basic Formulas
Likes 266 Likes 266  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with Different Chart Styles
Likes 41 Likes 41  
COURSE Custom & Conditional Formatting
Likes 75 Likes 75  
COURSE Creating & Saving Workbooks
Likes 172 Likes 172