Excel 2000 Day 2

Formatting Cells

Changing Cell Alignment

Using the Merge and Center Button

Using the Borders Button

Using the Fill Color Button

Using the Format Painter Button

Copying to Non-adjacent Cells

Clearing Formats

Inserting Selected Cells

Deleting Selected Cells

Formatting Cells

Using Automatic Formatting and Styles

Using Automatic Formatting Features

Applying an AutoFormat

Changing AutoFormat Options

Extending List Formats and Formulas

Creating a Style by Example

Applying a Style

Creating a New Style

Modifying a Style

Merging Styles

Using Automatic Formatting and Styles

Using Large Worksheets

Increasing the Magnification

Decreasing the Magnification

Changing the Magnification of a Range

Switching to Full Screen View

Splitting the Window

Removing Split Windows

Freezing the Panes

Unfreezing the Panes

Using Large Worksheets

Working with Multiple Worksheets

Using Multiple Worksheets

Navigating between Worksheets

Selecting Worksheets

Renaming Worksheets

Selecting Multiple Worksheets

Inserting Worksheets

Deleting Worksheets

Printing Selected Worksheets

Working with Multiple Worksheets

Managing Worksheets

Copying Worksheets

Moving Worksheets

Using Grouped Worksheets

Moving Data between Worksheets

Copying Data between Worksheets

Creating 3-D Formulas

Using Functions in Worksheets

Managing Worksheets

Using Paste Special

Working with Paste Special

Copying Formats between Worksheets

Copying Values between Worksheets

Copying Formulas between Worksheets

Performing Mathematical Operations

Using Paste Special

Using Range Names

Working with Range Names

Jumping to a Named Range

Assigning Names

Using Range Names in Formulas

Creating Range Names from Headings

Applying Range Names

Deleting Range Names

Using Range Names in 3-D Formulas

Creating 3-D Range Names

Using 3-D Range Names in Formulas

Using Range Names

Working with Labels in Formulas

Using Labels in Formulas

Using Labels to Define a Range

Using Multiple Stacked Headings

Referring to Individual Cells

Working with Labels in Formulas

Using Other Functions

Using Function Arguments

Using Financial Functions

Using Logical Functions

Using Date Functions

Formatting Dates

Revising Formulas

Using Other Functions

Creating Charts

Using Charts

Creating Charts - Chart Wizard

Moving and Resizing Charts

Identifying Chart Objects

Changing the Chart Type

Changing the Plot Direction

Adding/Removing a Legend

Changing the Text Orientation

Adding a Data Table

Formatting Chart Objects

Changing the Chart Range

Printing a Chart

Deleting a Chart

Creating Charts

Editing Charts

Editing Charts

Changing the Chart Type and Sub-type

Changing the Data Source

Adding Chart Titles

Moving the Legend

Changing the Chart Location

Printing a Chart Sheet

Editing Charts

Managing Data

Sorting Lists

Sorting in Ascending/Descending Order

Finding Data

Replacing Data

Managing Data

Customizing Excel Preferences

Setting View Options

Setting Edit Options

Setting General Options

Customizing Excel Preferences