Excel 2007 Functions and Formulas

Location: Webinar Date: 2010-09-07
List Price: $85 Offered Price: $68.00
Seats Available: 2

Elert & Associates Technology Training ~ Online MS Office Training Cancellation Policy

Description:

Do you want to perform calculations in your Excel spreadsheets? Do you want to use any of the 300+ built-in Excel functions? Do you want to learn how to efficiently create worksheets that update automatically?

Attend this course if you want to:

• Understand the difference between functions and formulas.

• Understand formula operators and order of operation.

• Learn how to use cell references.

• Create and edit formulas.

• Use a built-in function.

• Use AutoSum to automatically sum data.

• Sum subtotals to create a grand total.

• Access other functions from the Function dialog box or the Formulas tab.

• Type formulas that contain functions directly in a cell.

• Copy formulas to other cells.

• Understand the difference between and implications of relative and absolute references.

• Create logical (if/then) statements.

• Create formulas that span across multiple workbook pages.

Pre-Requisites:

Comfortable with basic Excel Capabilities.

Certificates offered:

Certificate of completion

Duration Details:

90 minutes long.
Starting Time: 11:30am EST

Facility Location:

On Line Instructor Led
Your Home or Office
Your City
Your Province
Your Country
--- ---

This listing has been viewed 12 times.