i need help with excel homework

Create an Accounts Receivable Aging pivot table with the following headings that totals A/R by customer and region. Please note the column lables. You should reformat and edit lables so they are identical to the figure below.

Note the four worksheet tabs. Spring YouTube Video: 1) Create an Accounts Receivable Aging pivot table with the following headings that totals A/R column lables. You should reformat and edit lables so they are identical to the figure below 2) Copy your completed A/R pivot table to the "Aging by Region" tab, colapse the regios, and th doubtful accounts using the percentages given below. http://youtu.be/9BvST9xWXws eadings that totals A/R by customer and region. Please note the tical to the figure below. olapse the regios, and then calculate the Allowance for Report Date 12/31/2013 AGI Customer Armstrong Armstrong Armstrong Armstrong Armstrong Armstrong Bradley Brown Brown Brown Brown Brubaker Brubaker Brubaker Brubaker Brubaker Brubaker Chavez Chavez Chavez Chavez Chavez Chavez Clark Clark Clark Clark Clark Clark Clark Clark Davis Davis Davis Delfert Delfert Flanders Flanders Flanders Flanders Flanders Flanders Flanders Flanders Good Good Good Good Sales Region East East East East East East North North North North North East East East East East East West West West West West West West West West West West West West West East East East South South North North North North North North North North North North North North Invoice Date 12/25/13 11/25/13 10/7/13 9/28/13 11/25/13 10/29/13 11/16/13 11/1/13 12/18/13 11/1/13 10/31/13 11/3/13 8/28/13 7/26/13 11/29/13 11/6/13 12/17/13 11/24/13 10/27/13 10/6/13 12/1/13 12/13/13 11/11/13 12/31/13 12/28/13 12/17/13 11/27/13 7/18/13 7/9/13 8/9/13 12/14/13 11/7/13 11/5/13 10/13/13 11/29/13 12/22/13 11/2/13 12/26/13 12/14/13 11/22/13 8/21/13 8/3/13 7/6/13 12/14/13 12/11/13 12/17/13 12/10/13 11/30/13 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Amount 1,939 631 6 820 757 123 1,096 853 66 1,013 267 527 226 74 515 692 362 589 1,102 634 68 506 408 229 383 118 47 319 597 418 762 622 1,107 83 695 898 1,900 133 925 533 471 116 11 501 16 594 437 264 Days Current (0-30 days) Good Herr Herr Herr Herr Kane Kane Kane Kane Kane Lawrence Lawrence Lawrence Lawrence Marcus Marcus Marcus Marshall Marshall McGonigal McGonigal McGonigal McGonigal McGonigal Mertz Mertz Mertz Mertz Mertz Mertz Mohler Mohler Mohler Mohler Mohler Mohler Peterson Peterson Peterson Peterson Pickell Podolsky Podolsky Rice Rice Rice Rice Rice Rice Rice Rice Rice North North North North North West West West West West West West West West South South South South South South South South South South East East East East East East East East East East East East West West West West North South South South South South South South South South South South 10/11/13 11/11/13 11/14/13 7/2/13 12/1/13 11/27/13 9/29/13 8/13/13 12/28/13 11/22/13 12/12/13 11/25/13 9/28/13 11/14/13 11/3/13 7/28/13 6/25/13 11/8/13 11/3/13 11/2/13 11/23/13 8/18/13 12/3/13 11/22/13 3/19/13 12/17/13 12/24/13 11/23/13 9/6/13 8/6/13 12/20/13 12/5/13 11/11/13 11/1/13 9/14/13 12/18/13 12/27/13 12/7/13 12/21/13 10/12/13 12/14/13 9/9/13 6/27/13 11/29/13 11/11/13 11/2/13 12/16/13 12/3/13 11/6/13 11/1/13 10/7/13 8/6/13 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 229 292 139 412 1,086 1,198 89 891 1,386 65 262 563 9 1,557 213 171 612 225 1,748 360 210 130 10 1,847 542 603 1,091 99 666 101 1,164 586 304 899 1,466 172 256 19 372 85 993 89 663 1,029 31 795 287 156 47 16 313 669 Rice Richet Richet Richet Roberts Roberts Samuel Samuel Samuel Samuel Savitsky Shepke Steller Steller Steller Stephens Stephens Stephens Stephens Stone Stone Stone Johnson Johnson Johnson Walker Walker Walker Winters Winters Winters Winters South East East East East East East East East East East East West West West West West West West West West West South South South South South South West West West West 12/9/13 11/29/13 7/1/13 6/27/13 11/17/13 11/2/13 11/29/13 11/4/13 9/27/13 12/12/13 9/26/13 11/25/13 12/20/13 12/25/13 12/5/13 12/31/13 11/6/13 9/20/13 8/2/13 10/10/13 10/14/13 12/24/13 9/7/13 12/4/13 11/18/13 12/18/13 12/29/13 12/24/13 8/24/13 10/14/13 9/25/13 7/6/13 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 580 1,425 48 574 439 440 476 907 202 815 231 143 401 98 689 1,055 35 404 148 734 913 25 718 110 479 592 279 262 358 224 419 22 AGING SCHEDULE Past Due (31-60 days) (61-90 days) (91-120 days) (over 120 days)