Excel 2016: Basic Formulas

Expected Duration
Lesson Objectives
Course Number
Expertise Level

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)

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:

    Expertise Level