Excel 2003 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 IF statements and 3-D references.

Prerequisite Skills

Comfortable with basic Excel capabilities.

(Suggested course: Excel 2003 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:

• Learn how to use cell references.

• Create and/or edit a formula.

• Use a built-in function.

• Use the AutoSum button to automatically sum data.

• Sum subtotals to create a grand total.

• Use ScreenTips to enter function arguments.

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

• Use column headings in formulas.

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)