Excel 2000 Day 1

Exploring Excel

Starting Excel

Working with Excel Windows

Working with Worksheets

Using Menu Commands

Displaying and Hiding Toolbars

Displaying Hidden Toolbar Buttons

Moving and Resizing Toolbars

Changing Menu and Toolbar Options

Exiting Excel

Exploring Excel

Working with the Office Assistant

Using the Office Assistant

Finding an Answer

Hiding/Displaying the Office Assistant

Changing Office Assistant Options

Working with the Office Assistant

Using Basic Workbook Skills

Selecting a Cell using the Keyboard

Scrolling using the Mouse

Entering Text into Cells

Entering Numbers into Cells

Saving a New Workbook

Closing a Workbook

Creating a New Workbook

Opening an Existing Workbook

Using Data Entry Shortcuts

Editing Cell Entries

Renaming an Existing Workbook

Using Basic Workbook Skills

Working with Ranges

Working with Ranges

Selecting Ranges with the Keyboard

Selecting Ranges with the Mouse

Selecting Non-adjacent Ranges

Entering Values into a Range

Using the AutoFill Feature

Working with Ranges

Creating Simple Formulas

Using Formulas

Entering Formulas

Using the AutoSum Button

Using Basic Functions

Using the AutoCorrect Feature

Using the Formula Palette

Using the Paste Function Button

Using the AutoCalculate Feature

Using the Range Finder Feature

Creating Simple Formulas

Copying and Moving Data

Copying/Cutting and Pasting Data

Pasting from the Clipboard Toolbar

Creating an Absolute Reference

Filling Cells

Using Drag-and-Drop Editing

Using Undo and Redo

Copying and Moving Data

Printing

Previewing a Worksheet

Printing the Current Worksheet

Printing a Selected Range

Printing Multiple Copies

Printing a Page Range

Printing

Using Page Setup

Setting Margin and Centering Options

Changing the Page Orientation

Editing Headers and Footers

Customizing Headers and Footers

Changing Print Gridlines

Repeating Row and Column Labels

Scaling a Worksheet

Using Page Break Preview

Setting/Removing a Print Area

Using Page Setup

Formatting Numbers

Using Number Formats

Using the Currency Style

Using the Percent Style

Using the Comma Style

Changing Decimal Places

Formatting Numbers

Formatting Text

Changing Text Appearance

Using the Font List

Using the Font Size List

Using the Bold/Italic Buttons

Using the Underline Button

Using the Font Color Button

Rotating Text in a Cell

Wrapping Text in a Cell

Shrinking Text in a Cell

Merging Cells into One Cell

Changing Text Indent

Formatting Text

Working with Columns and Rows

Selecting Columns and Rows

Changing the Width of Columns

Changing the Height of Rows

Adjusting Columns Automatically

Hiding Columns and Rows

Unhiding Columns and Rows

Inserting a Column

Inserting a Row

Deleting a Column

Deleting a Row

Working with Columns and Rows

Using Online Help

Working with Online Help

Viewing ScreenTips

Using Help Contents

Showing and Hiding the Help Tabs

Using the Help Answer Wizard

Using the Help Index

Using Online Help