Excel 2010: Conditional Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

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.



Expected Duration (hours)
0.7

Lesson 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

    • Course Number:
    ds_msex2010_13_enus

    Expertise Level
    Intermediate