Working with Microsoft Excel Formulas and Functions

The main objective of this lesson are the following:

• Copy Ms Excel formulas
• Build a formula containing a relative, absolute, and a mixed reference
• Review of the function syntax
• Insert function with Insert Function dialog box
• Search for function
• Type a function directly in cell
• Use AutoFill to fill a formula and complete a series
• Enter IF logical function
• Insert date with TODAY function
• Calculate monthly mortgage payments with PMT financial function