Lab Insight: Apply the same steps in Lab $2\mathrm{.}1$ to the Alt Lab $2\mathrm{.}1$ Data.xlsx dataset. Open Excel file Alt Lab $2\mathrm{.}1$ Data.xlsx$.$

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: Alt Lab $2\mathrm{.}1$ Data.xlsx

Analyze the Data: Refer to lab $2\mathrm{.}1$ in your text for additional instructions and steps.