Excel assignment must have functions and all on document

Agingschedule.xlsx

Sheet1

Execl Project
There are three reports that you need to complete.
The second and third reports are given in sheets 2 and 3.
Your name:
Today's Date:			11/1/17
(1) Prepare an aging schedule:
	Use the =IF() function to identify past due invoices and # of days past due.
	Use the =IF(AND()) function for the aging schedule.
Invoice #	Customer Type	Invoice Date	Due Date	Amount	# of days past due
1001	X	6/28/17	7/28/17	$ 5,740
1002	Y	7/12/17	8/11/17	$ 14,027
1003	Z	8/5/17	9/4/17	$ 7,029
1004	X	8/30/17	9/29/17	$ 3,620
1005	Y	9/4/17	10/4/17	$ 7,319
1006	Z	9/9/17	10/9/17	$ 12,411
1007	X	9/14/17	10/14/17	$ 14,427
1008	Y	9/19/17	10/19/17	$ 6,064
1009	Z	9/24/17	10/24/17	$ 10,249
1010	X	10/9/17	11/8/17	$ 3,148
1011	Y	10/14/17	11/13/17	$ 10,103
Aging schedule-		Past Due Amount:
Invoice #	Csustomer Type	1-30 days	31-60 days	61-90 days	Over 90 days
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
Total

(2) Prepare an analysis of accounts receivable using Pivot table:
	In your report, you should present an aging schedule by the types of customers.

(3) Prepare an analysis of accounts receivable using Pivot chart:
	In your chart, you should present an aging schedule by the types of customers.