more Excel Intermediate Level

Please follow all steps Challenge 1 a-k

Please follow all steps Challenge 2 a-i

Please follow all steps Challenge 3 a-i

Need someone that can do excel

Need on 10/4/13 at 1:00 eastern time

Notes are provided to help

In Challenges 1- 3 please follow the instructions; in challenge 3 that is the data information

accounts payable

Travel Well
Advertising Accounts Payable
Current Date	9/1/10
Invoice Number	Invoice Date	Account Name	Amount	Invoice Due Date	Age of Invoice	Number of Days Overdue	Priority
5003	8/2/10	Travel Asia	1,367.00
1017	7/16/10	Europe by Rail	1,259.99
2341	6/2/10	African Tours	1,569.33
3922	8/7/10	See Australia	2,461.65
3486	7/3/10	Family Travels	789.34
9864	8/5/10	Single Holidays	1,576.88
7443	8/16/10	Senior Vacations	557.00

Sheet2

Sheet3

Jan

Goals

Sales

Summary

Sales Category Sales in Canadian $ % of Sales Sticks 850890 Ice Skates 725099 Apparel 98590 Pads 552430 Equipment Bags 468000 January Sales Total

Feb

Goals

Sales Category Sales in Canadian $ % of Sales

Sticks

Ice Skates

Apparel

Pads

Equipment Bags

			Sales Summary
$ 650,095
$ 550,213
$ 885,075
$ 355,910
$ 329,760
February Sales Total

Mar

Goals
Sales Summary
Sales Category Sales in Canadian $ % of Sales

Sticks

Ice Skates

Apparel

Pads

Equipment Bags

$ 169,000

$ 725,052

$ 785,073

$ 255,700

$ 87,490

March Sales Total

Summary

Goals
Sales Summary
Sales Category Sales in Canadian $ % of Sales

Sticks
Ice Skates
Apparel
Pads
Equipment Bags

First Quarter Sales Total

Products

sticks, ice skates, apparel, pads, equipment bags

Sheet1

Sheet2

Sheet3