Excel Tutorial 3Working with Formulas and Functions: Excel Tutorial 3 Working with Formulas and Functions


Objectives: Objectives New Perspectives on Microsoft Office 2007: Windows Vista Edition 2


Objectives: Objectives New Perspectives on Microsoft Office 2007: Windows Vista Edition 3


Using Relative References: Using Relative References New Perspectives on Microsoft Office 2007: Windows Vista Edition 4


Using Absolute References: Using Absolute References New Perspectives on Microsoft Office 2007: Windows Vista Edition 5


Using Mixed References: Using Mixed References New Perspectives on Microsoft Office 2007: Windows Vista Edition 6


Entering Relative, Absolute, and Mixed References: Entering Relative, Absolute, and Mixed References New Perspectives on Microsoft Office 2007: Windows Vista Edition 7


Understanding Function Syntax: Understanding Function Syntax New Perspectives on Microsoft Office 2007: Windows Vista Edition 8


Understanding Function Syntax: Understanding Function Syntax New Perspectives on Microsoft Office 2007: Windows Vista Edition 9


Inserting a Function: Inserting a Function New Perspectives on Microsoft Office 2007: Windows Vista Edition 10


Inserting a Function: Inserting a Function New Perspectives on Microsoft Office 2007: Windows Vista Edition 11


Inserting a Function: Inserting a Function New Perspectives on Microsoft Office 2007: Windows Vista Edition 12


Typing a Function: Typing a Function New Perspectives on Microsoft Office 2007: Windows Vista Edition 13


Working with AutoFill: Working with AutoFill New Perspectives on Microsoft Office 2007: Windows Vista Edition 14


Working with AutoFill: Working with AutoFill New Perspectives on Microsoft Office 2007: Windows Vista Edition 15


Using the AutoFill Options Button: Using the AutoFill Options Button New Perspectives on Microsoft Office 2007: Windows Vista Edition 16


Filling a Series: Filling a Series New Perspectives on Microsoft Office 2007: Windows Vista Edition 17


Filling a Series: Filling a Series New Perspectives on Microsoft Office 2007: Windows Vista Edition 18


Creating a Series with AutoFill: Creating a Series with AutoFill New Perspectives on Microsoft Office 2007: Windows Vista Edition 19


Working with Logical Functions: Working with Logical Functions New Perspectives on Microsoft Office 2007: Windows Vista Edition 20


Working with Logical Functions: Working with Logical Functions New Perspectives on Microsoft Office 2007: Windows Vista Edition 21


Working with Logical Functions: Working with Logical Functions New Perspectives on Microsoft Office 2007: Windows Vista Edition 22


Working with Logical Functions: Working with Logical Functions New Perspectives on Microsoft Office 2007: Windows Vista Edition 23


Working with Date Functions: Working with Date Functions New Perspectives on Microsoft Office 2007: Windows Vista Edition 24


Working with Financial Functions: Working with Financial Functions New Perspectives on Microsoft Office 2007: Windows Vista Edition 25


Using the PMT Function to Determine a Monthly Loan Payment: Using the PMT Function to Determine a Monthly Loan Payment New Perspectives on Microsoft Office 2007: Windows Vista Edition 26


Using the PMT Function to Determine a Monthly Loan Payment: Using the PMT Function to Determine a Monthly Loan Payment New Perspectives on Microsoft Office 2007: Windows Vista Edition 27


Using the PMT Function to Determine a Monthly Loan Payment: Using the PMT Function to Determine a Monthly Loan Payment New Perspectives on Microsoft Office 2007: Windows Vista Edition 28