Excel 2003 More Functions & Formulas

Objective

Learn to use some of Excel's logical, text, lookup & reference, and date & time functions to process worksheet data more efficiently.

Prerequisite Skills

• Comfortable with Excel and its formatting capabilities.
  (Suggested courses: Excel 2003 Getting Started and Excel 2003 Formatting Spreadsheets)

• Comfortable with basic functions & formulas.
  (Suggested course: Excel 2003 Functions & Formulas)

• Comfortable working with Excel worksheets and workbooks.
  (Suggested course: Excel 2003 Working with Workbooks)

Course Description

Do you need to do more advanced calculations? Do you want to learn to use more of the 300+ built-in Excel functions? This class covers four groups of common functions: logical functions, text functions, lookup and reference functions, and date and time functions.

Attend this course if you want to:

• Identify portions of an IF statement.

• Create a simple IF statement.

• Create a nested IF statement.

• Work with text functions.

• Eliminate extra spaces.

• Change text to proper case.

• Merge cells.

• Extract a portion of text from a field.

• Change a formula to a value.

• Separate text into columns.

• Look up and merge data.

• Work with Date & Time functions.

• Enter today’s date.

• Enter the current date and time.

• Extract a portion of a date.

• Enter formulas directly into cells.

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)