Basic Excel 2003 Spreadsheet Tutorial

By Ted French, About.com Guide

Calculating employee deductions

1. Click on cell C9.
   
   
2. Type in the formula = B9 * rate and press the Enter key on the keyboard.

Calculating net salary

1. Click on cell D9.
   
   
2. Type in the formula = B9 - C9 and press the Enter key on the keyboard.

• Additional formula information:
  Excel 2003 Formulas Step by Step Tutorial

Copying the formulas in cells C9 and D9 to other cells:

1. Click on cell C9 again.
   
   
2. Move the mouse pointer over the fill handle (a small black dot) in the bottom right corner of the active cell.
   
   
3. When the pointer changes to a black "plus sign", click and hold down the left mouse button and drag the fill handle down to cell C12. The formula in C9 will be copied to cells C10 - C12.
   
   
4. Click on cell D9.
   
   
5. Repeat steps 2 and 3 and drag the fill handle down to cell D12. The formula in D9 will be copied to cells D10 - D12.

Previous

• Excel 2003 Step by Step Tutorial
• Entering Data into Excel
• Widening Columns in Excel
• Adding the Date and a Range Name
• Adding Formulas in Excel
• Changing Data Alignment
• Applying Number Formatting
• Changing Cell Background Color
• Changing Font Color

Next