Using the excel tools including “pivot table” and vlookup function, create a new spreadsheet named “estimation of bad debt” which shows “sales_order_id”, AR balance per sales order, and total estimated uncollectible amount.

Use the attached excel posted for this question, the internal auditor of this company wants to estimate the amounts of uncollectible AR, which would be a basis to estimate the bad debt expense this period. Using the excel tools including “pivot table” and vlookup function, create a new spreadsheet named “estimation of bad debt” which shows “sales_order_id”, AR balance per sales order, and total estimated uncollectible amount.

Last Completed Projects