New Horizons Computer Learning Center
410-597-9722

Excel 2007 - Formulas and Functions

Course Length: 1 Day

Overview:
In this course, students will learn how to create and effectively apply a large number of Microsoft Office Excel 2007's formulas and functions.

Prerequisites:
Excel 2007 - Level 1
Or equivalent knowledge

Course Content

Lesson 1: Getting the Most Out of Ranges

• A Review of Excel's Range-Selection Techniques
• Advanced Range-Selection Techniques
• Data Entry in a Range
• Filling a Range
• Using the Fill Handle
• Creating a Series
• Copying a Range
• Moving a Range
• Inserting and Deleting a Range
• Clearing a Range
• Using Excel's Reference Operators

Lesson 2: Using Range Names

• Defining a Range Name
• Working with Range Names
• Range Names and the Reference Operators

Lesson 3: Building Basic Formulas

• Understanding Formula Basics
• Understanding Operator Precedence
• Controlling Worksheet Calculation
• Copying and Moving Formulas
• Displaying Worksheet Formulas
• Converting a Formula to a Value
• Working with Range Names in Formulas
• Working with Links in Formulas
• Formatting Numbers, Dates, and Times

Lesson 4: Creating Advanced Formulas

• Working with Arrays
• Using Iteration and Circular References
• Consolidating Multisheet Data
• Applying Data-Validation Rules to Cells
• Using Dialog Box Controls on a Worksheet

Lesson 5: Troubleshooting Formulas

• Understanding Excel's Error Values
• Fixing Other Formula Errors
• Using the Formula Error Checker
• Auditing a Worksheet

Lesson 6: Using Functions

• About Excel's Functions
• The Structure of a Function
• Typing a Function into a Formula
• Using the Insert Function Feature

Lesson 7: Working with Text Functions

• Working with Characters and Codes
• Converting Text
• Manipulating Text

Lesson 8: Working with Logical and Information Functions

• Adding Intelligence with Logical Functions
• Getting Data with Information Functions

Lesson 9: Working with Lookup Functions

• Understanding Lookup Tables
• The CHOOSE() Function
• Looking Up Values in Tables

Lesson 10: Working with Date and Time Functions

• How Excel Deals with Dates and Times
• Using Excel's Date Functions
• Using Excel's Time Functions

Lesson 11: Working with Math Functions

• Understanding Excel's Rounding Functions
• Summing Values
• The MOD() Function
• Generating Random Numbers

Lesson 12: Working with Statistical Functions

• Understanding Descriptive Statistics
• Counting Items with the COUNT() Function

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com