Required:

Calculate the grand totals of Customer Count, Sum of InvoiceAmount, and Count of Due Date.

Subtotal the accounts receivable by date in a pivot table.

Add in conditional formatting to the count of the Customer field.

Create a line chart representing customer orders by day.

Data:

Lab $2\mathrm{.}1$ Data.xIsx: