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
    FREE ACCESS
  • Locked
    4. 
    Creating multiple conditions in Excel 2016 for Windows
    5m 21s
    FREE ACCESS
  • Locked
    5. 
    Using IF & OR in conditional formulas in Excel 2016 for Windows
    4m 43s
    FREE ACCESS
  • Locked
    6. 
    Using conditional formulas to count up value occurrences in Excel 2016 for Windows
    2m 33s
    FREE ACCESS
  • Locked
    7. 
    Translating data in your worksheet in Excel 2016 for Windows
    5m 34s
    FREE ACCESS
  • Locked
    8. 
    Using reference positions in conditional formulas in Excel 2016 for Windows
    3m 35s
    FREE ACCESS
  • Locked
    9. 
    Keeping your table up to date with conditional formulas in Excel 2016 for Windows
    2m 39s
    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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Finding and analyzing data with formulas in Excel 365
Course Custom & Conditional Formatting in Excel 2016 for Windows
Likes 150 Likes 150  
Course Using Conditional Formulas in Excel Microsoft 365 for Windows
Likes 190 Likes 190  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Custom & Conditional Formatting in Excel 2016 for Windows
Likes 150 Likes 150  
Course Working with Formulas in Excel 2016 for Windows
Likes 116 Likes 116  
Course Using Basic Formulas in Excel 2019 for Windows
Likes 266 Likes 266