Collections Essentials Microsoft Office for Mac 2016: Excel (No Assessments)
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.
| 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
|
