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

  • use the Function Library to insert a formula in Excel 2016 for Mac
  • perform simple formulas in Excel 2016 for Mac
  • create automated cumulative totals in Excel 2016 for Mac
  • use the Fill Down function to automate formulas in Excel 2016 for Mac
  • add subtotals in Excel 2016 for Mac
  • learn formulas to count cells in a range in Excel 2016 for Mac
  • rank values in Excel 2016 for Mac
  • learn formulas to round your data values in Excel 2016 for Mac
  • use replacement formulas in Excel 2016 for Mac
  • insert conditional sum formulas in Excel 2016 for Mac
  • insert conditional message formulas in Excel 2016 for Mac
  • use IF and OR in conditional formulas
  • Course Number:
    ds_msex16mc_09_enus

    Expertise Level
    Beginner