Excel 2007 Functions & Formulas

Objective

Learn the fundamentals of creating and working with formulas and functions. Start by building a simple formula and move to more advanced functions such as SUM, PMT, and IF. Also, create formulas that contain 3-D references.

Prerequisite Skills

Comfortable with basic Excel capabilities.

(Suggested course: Excel 2007 Getting Started)

Course 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.

Class Length

90 minutes

Delivery Options

Virtual classroom - public
($70 per student; check times and register here)
Virtual classroom - dedicated (up to ten people from the same organization)
($480 per class; contact us for more details)
Virtual classroom - one on one
(Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)
On-site instructor-led
(Contact us for details)