$8\mathrm{.}21$ Using GETPIVOTDATA

Steps to complete this project:

Mark the steps as checked when you complete them.

Open the EX$-$Project$4-$AgingAccountsReceivable Excel workbook start file. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the worksheet so you can modify it$.$

The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.

Compute the age of each customer's receivable.

a$.$ Click the Accounts Receivable sheet and select cell F$2.$

b$.$ Compute the number of days old as the difference the year$-$end date and the invoice date; the absolute value of cell $K9$ minus the invoice date in column $D.$

c$.$ Select cell F$2.$ Double$-$click the Fill Handle to complete the column.

Assign an aging category to each Receivable.

a$.$ Select cell G$2.$

b$.$ Click the Lookup & Reference button $[$Formulas tab, Function Library group$].$

c$.$ Select VLOOKUP in the list to open the Function Arguments dialog box.

d$.$ Lookup$\_$value: F$2$

e$.$ Table$\_$array: $$$1$$$$K$$$7$

f$.$ Col$\_$index$\_$num: $3$

Reset Progress Back to top

f$.$ Col$\_$index

Click OK$.$