Go to: Level 1 2 3 4 5 6 7 8 9 10 11 12 16 13 14 15 17

Start Microsoft Excel

Create the labels

  • Enter the Labels

    • In Cell A1 type: Check No

    • In Cell B1 type: Date

    • In Cell C1 type: Description

    • In Cell D1 type: Amount

    • In Cell E1 type: Deposit

    • In Cell F1 type: Balance

  • Select Row 1 and format the labels big, bold, and centered

Add the following smaple data:

  • Type in four or five records

A B C D E F
1

Check No

Date Description  Amount   Deposit   Balance 
2 Opening Balance  $ 500.00
3 100 4/7/04 Office Supplies  $   78.50
4 101 4/7/04 The Phone Store  $ 180.98
5 102 4/7/04 The Phone Co  $   50.00

 

more on the next page

Level 5: Set Up A Checkbook, part one