Microsoft Office Tutorials and References
In Depth Information
Table 4.1 Payment example
Item Account
$ Amount Date rcvd. Deposit
Days to pay
Comment
1
Office Supply
$123.45
1/2/2004
$10.00
0
Project X
2
Office Supply
$54.40
1/5/2004
$0.00
0
Project Y
3
Printing
$2,543.21
1/5/2004
$350.00
45
Feb. Brochure
4
Cleaning Service
$78.83
1/8/2004
$0.00
15
Monthly
5
Coffee Service
$56.92
1/9/2004
$0.00
15
Monthly
6
Office Supply
$914.22
1/12/2004
$100.00
30
Project X
7
Printing
$755.00
1/13/2004
$50.00
30
Hand Bills
8
Office Supply
$478.88
1/16/2004
$50.00
30
Computer
9
Office Rent
$1,632.00
1/19/2004
$0.00
15
Monthly
10
Fire Insurance
$1,254.73
1/22/2004
$0.00
60
Quarterly
11
Cleaning Service
$135.64
1/22/2004
$0.00
15
Water Damage
12
Orphan’s Fund
$300.00
1/27/2004
$0.00
0
Charity
13
Office Supply
$343.78
1/30/2004
$100.00
15
Laser Printer
14
Printing
$2,211.82
2/4/2004
$350.00
45
Mar. Brochure
15
Coffee Service
$56.92
2/5/2004
$0.00
15
Monthly
16
Cleaning Service
$78.83
2/10/2004
$0.00
15
Monthly
17
Printing
$254.17
2/12/2004
$50.00
15
Hand Bills
18
Office Supply
$412.19
2/12/2004
$50.00
30
Project Y
19
Office Supply
$1,467.44
2/13/2004
$150.00
30
Project W
20
Office Supply
$221.52
2/16/2004
$50.00
15
Project X
21
Office Rent
$1,632.00
2/18/2004
$0.00
15
Monthly
22
Police Fund
$250.00
2/19/2004
$0.00
15
Charity
23
Printing
$87.34
2/23/2004
$25.00
0
Posters
24
Printing
$94.12
2/23/2004
$25.00
0
Posters
25
Entertaining
$298.32
2/26/2004
$0.00
0
Project Y
26
Orphan’s Fund
$300.00
2/27/2004
$0.00
0
Charity
27
Office Supply
$1,669.76
3/1/2004
$150.00
45
Project Z
28
Office Supply
$1,111.02
3/2/2004
$150.00
30
Project W
29
Office Supply
$76.21
3/4/2004
$25.00
0
Project W
30
Coffee Service
$56.92
3/5/2004
$0.00
15
Monthly
31
Office Supply
$914.22
3/8/2004
$100.00
30
Project X
32
Cleaning Service
$78.83
3/9/2004
$0.00
15
Monthly
33
Printing
$455.10
3/12/2004
$100.00
15
Hand Bills
34
Office Supply
$1,572.31
3/15/2004
$150.00
45
Project Y
35
Office Rent
$1,632.00
3/17/2004
$0.00
15
Monthly
36
Police Fund
$250.00
3/23/2004
$0.00
15
Charity
37
Office Supply
$642.11
3/26/2004
$100.00
30
Project W
38
Office Supply
$712.16
3/29/2004
$100.00
30
Project Z
39
Orphan’s Fund
$300.00
3/29/2004
$0.00
0
Charity
6. Consistency in category titles —Although upon casual viewing, you may not con-
sider that there is a significant difference between the category entries Office
Supply and Office Supplies for the Account field, Excel will view them as com-
pletely distinct entries. As intelligent as Excel is, it requires you to exercise very
precise and consistent use of entries. Even a hyphen makes a difference; the term
H-G is different that HG in the mind of Excel.
 
Search JabSto ::




Custom Search