1 11 of 2 6 ts 02:10:45 eBook Print ferences ! Required information [The following information applies to the questions displayed below.] Required: 1. Summarize the late accounts receivable by customer. Show the PivotTable. 2. Get the detailed receivables for the customer "Thai Tap." Ask the Question: How can we use PivotTables on the total detailed accounts receivables balance to get specific detail on Invoices due by customer? Master the Data: To begin, we have a list of 200 receivables on specific invoices that are all past their due date as of today's date of 12/31/2021. This is shown in the Excel file Lab 2-1 Data.xlsx. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-1 Alt Data.xlsx Perform the Analysis: Refer to Lab 2-1 Alternative in the text for instructions and Lab 2-1 steps for each of the lab parts. Share the Story: Now that we have the detail by customer, we can better follow up with them to help with collections. All employees interfacing with the client should have this detail when they talk and interact with that specific customer. Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. 1. Take a screenshot of the top 20 rows listing the total amount due by customer (from the PivotTable), and label it "Lab 2-1 Alt Submis 2. Take a screenshot of Thai Tap invoices due, and label it "Lab 2-1 Alt Submission 2 upload a response file (15MB max) Choose File No file chosen