Microsoft Excel 2016 for Mac: 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

Microsoft Excel 2016 for Mac: Basic Formulas

  • Inserting a formula using the function library
  • Performing simple formulas
  • Creating automated cumulative totals
  • Using automated formulas in a table
  • Inserting subtotals
  • Counting cells in a range
  • Ranking a value
  • Rounding a number
  • Using replacement formulas
  • Inserting a conditional sum formula
  • Inserting a conditional message formula
  • Using IF & OR in conditional formulas
  • Course Number:
    ds_msex16mc_09_enus

    Expertise Level
    Beginner