# Conditional Formulas in Excel 2010 for Windows

Excel 2010 (Windows)    |    Intermediate
• 9 videos | 43m 36s
Likes 21
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.

## 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  Using reference positions in conditional formulas Keeping your table up to date with conditional formulas

## IN THIS COURSE

• 1.  Inserting a conditional sum formula in Excel 2010 for Windows
In Excel 2010, 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…
• 2.  Inserting a conditional message formula in Excel 2010 for Windows
The IF 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 2010, you can use…
• 3.  Performing complex conditional formulas in Excel 2010 for Windows
In Excel 2010, 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…
• 4.  Creating multiple conditions in Excel 2010 for Windows
If you want to return more than two possible messages in Excel 2010, you can. You will, however, have to embed multiple IF formulas within one another in order to obtain multiple result options.
• 5.  Using IF & OR in conditional formulas in Excel 2010 for Windows
In Excel 2010, 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.
• 6.  Using conditional formulas to count up value occurrences in Excel 2010 for Windows
In Excel 2010, 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…
• 7.  Translating data in your worksheet in Excel 2010 for Windows
In Excel 2010, 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.
• 8.  Using reference positions in conditional formulas in Excel 2010 for Windows
In Excel 2010, 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.
• 9.  Keeping your table up to date with conditional formulas in Excel 2010 for Windows
If you are constantly updating your tables and adding new data entries to your Excel 2010 worksheet, you can create conditional formulas to keep up to date with your new additions. Once you have inserted these…

## 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.