Excel 2000 Proficient User Specialist

Getting Started

What is Excel?

Starting Excel

The Excel 2000 Window

Worksheet versus Workbook

Moving around a Worksheet

Entering Data in a Worksheet

File Handling

Setting the Default File Location

Saving a Workbook

Closing a Workbook

Opening a Previously Saved Workbook

Creating a New Workbook

Saving in HTML Format

Creating a Hyperlink to Open Other Workbooks and Files

Working with Ranges, Columns and Rows

Defining Ranges

Selecting Ranges

Sorting

Column Width and Row Height

Using AutoSum

Moving and Copying to Build a Worksheet

Using the Clipboard to Move and Copy

Using Drag-and-Drop to Move and Copy

Moving and Copying Worksheets

Inserting and Deleting Cells, Rows and Columns

Formatting a Worksheet

Types of Formatting

Alignment

Formatting Numbers

Formatting Dates

Formatting Characters (Font)

Borders and Patterns

Copying Cell Formats

Clearing Cell Formats and Contents

AutoFormats

Styles

Functions and Formulas

Functions Defined

The SUM Function

The Paste Function Button

The AVERAGE, MIN and MAX Functions

Using the Formula Palette

Consolidating Data with 3-D References

The NOW and TODAY Functions

IF Function

Absolute, Relative, and Mixed References in Formulas

Financial Functions

Creating and Using Range Names in Formulas

Creating and Modifying Objects

Importing Graphics

Creating Graphics

Creating Charts

Parts of a Chart

Creating a Chart

Chart Type

Selecting Parts of a Chart

Moving, Sizing and Deleting Chart Items

Customizing Chart Items

Adding Drawn Items to a Chart

Previewing and Printing Charts Review

Printing Worksheets

Print Preview

Setting Printing Options

Printing

Reference Tables

Moving the Active Cell Indicator

Cell Selection (Keyboard and Mouse)