Excel 03

Featured Animated Featured Animated
Uploaded from authorPOINT
Download as
 PPT
Presentation Description 

No description available

By:
 (7 month(s) ago)  
hey i want to download this ppt for improving my knowledge in excel.. But i am not able to download this ppt..please help me out
?

authorSTREAM Premium Service
What's up on authorSTREAM?
Views: 1543
Like it  ( Likes) Dislike it  ( Dislikes)
Added: June 16, 2007 This Presentation is Public 
Presentation Category : Product Training/ Manuals All Rights Reserved
Presentation Transcript

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