Here is a well written Excel
2000 Tutorial
from the Community College of Rhode Island, explaining
for you step-by-step how to perform the following
Excel
functionality: Managing Workbooks, Working with Ranges, Creating
Formulas, Copying and Moving Data, Printing, Formatting Numbers,
Working with Columns and Rows, Using Large Worksheets, and Managing
Multiple Worksheets. These tutorial lessons can also be used
to learn most of the Excel features in Excel XP and Excel 2003.
Contents
of Excel Tutorial Lessons:
Lesson
1 - Exploring Excel
- Starting Excel
- Working with Excel Windows
- Working with Worksheets
- Exiting Excel
- 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
- 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
- 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
- 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
- Previewing a Worksheet
- Printing the Current Worksheet
- Printing a Selected Range
- Printing Multiple Copies
- Printing a Page Range
- Using Number Formats
- Using the Currency Style
- Using the Percent Style
- Using the Comma Style
- Changing Decimal Places
- 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
- Switching to Full Screen View
- Splitting the Window
- Removing Split Windows
- Freezing the Panes
- Unfreezing the Panes
- Using Multiple Worksheets
- Navigating between Worksheets
- Selecting Worksheets
- Renaming Worksheets
- Selecting Multiple Worksheets
- Inserting Worksheets
- Deleting Worksheets
- Printing Selected Worksheets