Excel 03

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