Microsoft Office XP
Microsoft Excel Tutorial

Lesson 1: Entering Text and Numbers

• The Microsoft Excel Window
• Moving Quickly Around the Microsoft Excel Worksheet
• Selecting Cells
• Entering Data
• Editing a Cell
• Changing a Cell Entry
• Wrapping Text
• Deleting a Cell Entry
• Entering Numbers as Labels or Values
• Smart Tags
• Saving a File
• Closing Microsoft Excel

Lesson 2: Formatting Text and Performing Mathematical Calculations

• Choosing a Default Font
• Adjusting the Standard Column Width
• Cell Alignment
• Adding Bold, Underline, and Italic
• Changing the Font, Font Size, and Font Color
• Working with Long Text
• Changing a Single Column Width
• Moving to a New Worksheet
• Setting the Enter Key Direction
• Making Numeric Entries
• Performing Mathematical Calculations
• The AutoSum Icon
• Automatic Calculation
• Formatting Numbers
• More Advanced Mathematical Calculations
• Cell Addressing
• Deleting Columns
• Deleting Rows
• Inserting Columns
• Inserting Rows
• Creating Borders
• Merge and Center
• Adding Background Color
• Using Auto Format
• Saving Your File
• Closing Microsoft Excel

Lesson 3: Numbers and Mathematical Calculations

• Reference Operators
• Functions
• Typing a Function
• Calculating an Average
• Calculating Min
• Calculating Max
• Calculating Count
• Filling Cells Automatically
• Printing
• Print Preview
• Saving Your File
• Closing Microsoft Excel

Lesson 4: Creating Charts

• Creating a Column Chart
• Changing the Size and Position of a Chart
• Modify Your Chart
• Saving Your File
• Closing Microsoft Excel