Using Conditional Formulas in Excel 2019 for Windows

Excel 2019 (Windows)    |    Intermediate
  • 8 videos | 38m 20s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 494 users Rating 4.5 of 494 users (494)
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

  • 5m 13s
    In Excel, 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. FREE ACCESS
  • 4m 53s
    The IF function 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, 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 2019 for Windows
    5m 2s
    In Excel, 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 2019 for Windows
    5m 27s
    If you want to return more than two possible messages in Excel, 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 2019 for Windows
    5m 50s
    In Excel, 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 2019 for Windows
    3m 25s
    In Excel, 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.  Using reference positions in conditional formulas in Excel 2019 for Windows
    5m 5s
    In Excel, 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 OFFSET formulas. FREE ACCESS
  • Locked
    8.  Keeping your table up to date with conditional formulas in Excel 2019 for Windows
    3m 25s
    If you are constantly updating your tables and adding new data entries to your Excel worksheet, you can create conditional formulae to keep up to date with your new additions. Once you have inserted these calculations - using formulae such as COUNTA and OFFSET - 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 1588 users Rating 4.5 of 1588 users (1588)
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 336 users Rating 4.6 of 336 users (336)
Rating 4.5 of 455 users Rating 4.5 of 455 users (455)
Rating 4.5 of 327 users Rating 4.5 of 327 users (327)