Excel assignment must have functions and all on document

(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 

(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.