Microsoft Excel Training - Learn Excel Free

Excel 97 Tutorial








By Mr Ding Ding Ding

You can use this free online tutorial to learn Microsoft Excel 97. Click here to start. If you are using a a more recent version of Excel, click here for our Excel 2003/2002 tutorial or click here for our Excel 2007 tutorial.

Lesson 1: Getting Familiar with Microsoft Excel

Microsoft Excel is an electronic spreadsheet that runs on a personal computer. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice. This lesson will introduce you to the Excel window. You use the window to interact with 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

A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data.

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

By using functions, you can quickly and easily make many useful calculations, such as finding an average, the highest number, the lowest number, and a count of the number of items in a list. Microsoft Excel has many functions you can use. This lesson teaches you how to use functions.

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

In previous lessons, you learned the fundamentals of Excel. This lesson teaches you how to put it all together.

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