SkillSoft Explore Course – Lambers, Inc.

BUY NOW! STARTING AT ONLY $299!

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

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.

Asset ID	ds_msex2010_13_enus
Course Type	Video Course
Course Category	Microsoft Office 2010

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

Objectives

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