Excel 97 Tutorial

You can use this free online tutorial to learn Microsoft Excel 97. Click here to start.

Lesson 1: Getting Familiar with Microsoft Excel

• The Title Bar
• The Menu Bar
• Toolbars
• Worksheets
• The Formula Bar
• The Status Bar
• The Down Arrow Key
• The Up Arrow Key
• The Right and Left Arrow Keys
• Page Up and Page Down
• The End Key
• The Home Key
• Scroll Lock
• Selecting Cells
• Closing Microsoft Excel

Lesson 2: Entering Text

• Editing a Cell
• Adjusting the Standard Column Width
• Cell Alignment
• Adding Bold, Underline, and Italic
• Changing the Font and Font Size
• Deleting a Cell Entry
• Working with Long Text
• Changing a Single Column Width
• Moving to a New Worksheet
• Filling Cells Automatically
• Saving Your File and Closing Microsoft Excel

Lesson 3: Numbers and Mathematical Calculations

• Setting the Enter Key Direction
• Making Numeric Entries
• Moving Quickly Around the Worksheet
• Performing Mathematical Calculations
• Automatic Calculation
• Formatting Numbers
• More Advanced Mathematical Calculations
• Functions
• Saving Your File and Closing Microsoft Excel

Lesson 4: Creating Your First Worksheet

• Creating a Series
• Entering Numbers
• Inserting Rows
• Aligning Cells
• Entering Text
• The AutoSum Icon
• Using Copy and Paste
• The Paste Function Icon
• Centering Across Cells
• Changing the Font and the Font Size
• Inserting Columns
• Aligning Text Sideways
• Bolding
• Formatting Numbers
• Creating a Border
• Formatting as a Percent
• Printing a Worksheet
• Saving Your File and Closing Microsoft Excel