Using Conditional Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 9 videos | 41m 12s
  • Includes Assessment
  • Earns a Badge
Likes 98 Likes 98
In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.

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 in Excel 2016 for Windows
    7m 9s
    UP NEXT
  • Playable
    2. 
    Inserting a conditional message formula in Excel 2016 for Windows
    4m 31s
  • Locked
    3. 
    Performing complex conditional formulas in Excel 2016 for Windows
    5m 6s
  • Locked
    4. 
    Creating multiple conditions in Excel 2016 for Windows
    5m 21s
  • Locked
    5. 
    Using IF & OR in conditional formulas in Excel 2016 for Windows
    4m 43s
  • Locked
    6. 
    Using conditional formulas to count up value occurrences in Excel 2016 for Windows
    2m 33s
  • Locked
    7. 
    Translating data in your worksheet in Excel 2016 for Windows
    5m 34s
  • Locked
    8. 
    Using reference positions in conditional formulas in Excel 2016 for Windows
    3m 35s
  • Locked
    9. 
    Keeping your table up to date with conditional formulas in Excel 2016 for Windows
    2m 39s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, 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

Likes 116 Likes 116  
Likes 266 Likes 266