Excel 2016: Basic Formulas

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