Excel 2010: Basic Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.

Expected Duration (hours)
0.9

Lesson Objectives

Excel 2010: Basic Formulas

  • Inserting a formula using the function library
  • Performing simple calculations
  • Using automated formulas in a table
  • Creating automated cumulative totals
  • Inserting subtotals
  • Counting cells in a range
  • Ranking a value
  • round numbers in Excel 2010
  • use replacement formulas in Excel 2010
  • convert number types in Excel 2010
  • factorize the results of a division in Excel 2010
  • use formulas to generate random values in Excel 2010
  • Course Number:
    ds_msex2010_09_enus

    Expertise Level
    Beginner