Excel 2007 More Functions & Formulas

Objective

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

Prerequisite Skills

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

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

• Comfortable working with Excel worksheets and workbooks.
  (Suggested course: Excel 2007 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 conditional functions.

Attend this course if you want to:

• Identify portions of an IF statement.

• Create simple and nested IF statements.

• Work with text functions.

• Eliminate extra spaces within your data.

• Change text to proper case.

• Merge cells with the Concatenate function.

• Extract a portion of text from a field.

• Change a formula to a value.

• Separate text into columns.

• Look up and merge data.

• Use the SUMIF, COUNTIF, and AVERAGEIF functions to calculate records based on certain conditions.

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