Excel 2013: Basic Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Get the most out of Excel 2013 by learning about formulas, functions, and totals. Explore using the function library, using automated formulas, inserting subtotals, ranking values, converting number types, and creating random values.

Expected Duration (hours)
1.1

Lesson Objectives

Excel 2013: Basic Formulas

  • Inserting a formula using the function library
  • Performing simple calculations with formulas
  • Using automated formulas in a table
  • Creating automated cumulative totals
  • Inserting subtotals
  • Counting cells in a range
  • Ranking a value
  • Rounding a number
  • Using replacement formulas
  • Converting number types
  • Factorizing the results of a division
  • Creating random values
  • Course Number:
    ds_msex2013_10_enus

    Expertise Level
    Beginner