Using Conditional Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 9 videos | 41m 12s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 245 users Rating 4.6 of 245 users (245)
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

  • 7m 9s
    In Excel 2016, you can use the SUMIF and SUMIFS formulas to perform a sum calculation on certain data values in your range. All you need to know is how to specify the conditions that your qualifying data values have to meet. These tools can be very useful when creating subtotals in Excel 2016. FREE ACCESS
  • 4m 31s
    The SI formula is made up of a range, a condition, a value if true, and a value if false. It can be used to display one message if a condition is met and another if the condition is not met. In Excel 2016, you can use qualifying conditions to perform an analysis on a data entry and display a particular value or message depending on the result of the logical test. FREE ACCESS
  • Locked
    3.  Performing complex conditional formulas in Excel 2016 for Windows
    5m 6s
    In Excel 2016, the IF formula can be used in conjunction with other formulas. You can create conditions based on calculations, and analyze your data in a variety of different ways. For example, this can be very useful when it comes to applying a discount on a data entry that has to be over a particular value to qualify. FREE ACCESS
  • Locked
    4.  Creating multiple conditions in Excel 2016 for Windows
    5m 21s
    If you want to return more than two possible messages in Excel 2016, you can. You will, however, have to embed multiple IF formulas within one another in order to obtain multiple result options. FREE ACCESS
  • Locked
    5.  Using IF & OR in conditional formulas in Excel 2016 for Windows
    4m 43s
    In Excel 2016, you can combine qualifying and alternative conditions in your IF formula. This can allow you to specify various different optional conditions that can be met when calculating your formula. FREE ACCESS
  • Locked
    6.  Using conditional formulas to count up value occurrences in Excel 2016 for Windows
    2m 33s
    In Excel 2016, you can use the SUMPRODUCT and date formulas to extract specific values from an existing data table. This can be very useful if you are looking to find the total number of purchases in a particular date range. FREE ACCESS
  • Locked
    7.  Translating data in your worksheet in Excel 2016 for Windows
    5m 34s
    In Excel 2016, you can use the IF formula to create a table that can be viewed in two different languages. Once you have inserted a dropdown list, you can use it as a button to quickly switch from one language to another. FREE ACCESS
  • Locked
    8.  Using reference positions in conditional formulas in Excel 2016 for Windows
    3m 35s
    In Excel 2016, you may sometimes need to find a cell value by using its positional coordinates in the table. You can do this with the MATCH and INDEX formulas. FREE ACCESS
  • Locked
    9.  Keeping your table up to date with conditional formulas in Excel 2016 for Windows
    2m 39s
    If you are constantly updating your tables and adding new data entries to your Excel 2016 worksheet, you can create conditional formulas to keep up to date with your new additions. Once you have inserted these calculations - using formulas such as COUNTA and MATCH - you will not have to modify them again or adjust the data ranges that they reference. 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

Rating 4.5 of 310 users Rating 4.5 of 310 users (310)
Rating 4.6 of 385 users Rating 4.6 of 385 users (385)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 307 users Rating 4.4 of 307 users (307)
Rating 4.6 of 188 users Rating 4.6 of 188 users (188)
Rating 4.6 of 106 users Rating 4.6 of 106 users (106)