SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

Productivity & Collaboration Tools Microsoft Office 2013 Excel 2013 Microsoft Office 2013: Intermediate Excel (No Assessments)

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.

Asset ID	ds_msex2013_16_enus
Course Type	Video Course
Course Category	Microsoft Office 2013

Objectives
Excel 2013: Conditional Formulas 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 Keeping your table up to date with conditional formulas Translating data in your worksheet Using reference positions in conditional formulas

Objectives

Excel 2013: Conditional Formulas

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