Excel 2016: Basic Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.

Expected Duration (hours)
0.8

Lesson Objectives

Excel 2016: 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
  • Rounding a number
  • Using replacement formulas
  • Converting number types
  • Factorizing the results of a division
  • Creating random values

    • Course Number:
    ds_msex2016_09_enus

    Expertise Level
    Beginner