Microsoft Office Excel 2002 - Intermediate Course Outline

Microsoft Office Excel 2002 - Intermediate

SECTION 1: Working with Functions and Formulas

Lesson 1.1: Using Formulas in Excel

Understanding Relative and Absolute Cell References

The Basic Mathematical Operators

Using Formulas with Multiple Cell References

The Formula Auditing Bar

Fixing Formula Errors

Displaying and Printing Formulas

Practice Exercise

Lesson 1.2: Exploring Excel Functions

What Are Functions?

Finding the Right Function

Some Useful and Simple Functions

Practice Exercise

Lesson 1.3: Using Functions in Excel

Inserting Functions

Using Functions and Autofill to Perform Difficult Calculations

Using the IF Function

Working with Nested Functions

Practice Exercise

Lesson 1.4: Working with Names and Ranges

What are Range Names?

Defining and Using Range Names

Selecting Nonadjacent Ranges

What is Auto Calculate?

Practice Exercise

Lesson 1.5: Working with Array Formulas

What are Array Formulas?

Using Basic Array Formulas

Using Functions with Array Formulas

Using the IF Function In Array Formulas

Practice Exercise

Section 1: Review Questions

SECTION 2: Managing Lists

Lesson 2.1 Working with Lists

What is a List?

Creating Lists

Applying the Auto Filter to a List

Practice Exercise

Lesson 2.2 Working with Records and Fields

What Are Records And Fields?

Adding Fields by Inserting Columns

Adding Records by Inserting Rows

Adding Records with A Data Form

Finding and Deleting Records

Practice Exercise

Lesson 2.3: Working with Lists and Filters

Sorting a List

What is an AutoFilter

Custom AutoFilters

Using an Advanced Filter

Copying Filtered Records

Practice Exercise

Lesson 2.4 Using Excel as a Database

Filtering With Wild Card Characters

Validating Your Data

What are Database Functions?

What are Lookup Functions?

Practice Exercise

Section 2: Review Questions

SECTION 3: Working with Macros and Controls

Lesson 3.1: Creating Macros in Excel

What is a Macro?

Creating a Macro

Playing a Macro

Assigning a Shortcut Key to a Macro

Macros, Buttons, and Toolbars

Practice Exercise

Lesson 3.2: Excel Form Controls

What Is A Form Control?

The Form Toolbar

Adding a Control to a Worksheet

Assigning a Macro to a Control

Using Form Controls

Practice Exercise

Section 3: Review Questions

SECTION 4: Using Excel with Other Programs

Lesson 4.1: Using Excel in Word

Inserting Excel Data in Word

Modifying Excel Data After Insertion

Linking Excel Data in Word

Linking an Excel Chart in Word

Practice Exercise

Lesson 4.2 Using Excel with Other Programs and Files

Using Outlook to Send Excel Data

Opening an Excel File in a Different Format

Importing Data from a Text File

Importing Data from a Database

Practice Exercise

Section 4: Review Questions