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