please do this excel project step by step

please follow all requirements

help me how to do this

file data_07

I cant post the sheet to copy because it tells that the question is too long.

Open the file data_07 and Save as Firstname_Lastname A. Create a PivotTable based on data range A2:E108 with the following values: a. FILTERS: Agent Type b. ROWS: City C. COLUMNS: Month d. VALUES: Sum of Sales Price c. DESIGN: Pivot Style Medium 14 B. Rename the new sheet Combined Real Estate Sales Rename Sheet1 to Data on the Combined Real Estate Sales worksheet, create a Slicer based on Type and apply - Slicer Style Dark 6. Apply a filter to include only Showcase Listings. Move the Slicer so the upper left corner is in cell G2. C. Create a copy of the Combined Real Estate Sales sheet and rename Combined Real Estate Sales (2) worksheet to Slicer Return to the Combined Real Estate Sales worksheet and remove the Type slicer filter. D. Click cell A1, Generate three Report Filter Pages, one named Premier Agents, one named Primary Agents, and one named Trainees a. On all three sheets, modify Value Field Settings to summarize by Average. Change cell A3 label to Average Sales Price Adjust the width of Department columns to display the new heading, if necessary. b. On all three sheets, modify Value Field Settings to Number format, remove all decimal places, and check the Use 1000 Separator (.). c. On the combined Real Estate Sales and Slicer worksheets, modify Value Field Settings to Number format, remove all decimal places, and check the Use 1000 Separator (.). E. On the original Data sheet, change the following numbers and update all PivotTables: a. Cell E13 June, Dayton, Premium Listings: change 562085 to 798349 b. Cell E47 July, Columbus, Showcase Listings: change 1359016 to 1987355 c. Cell E89 August, Cleveland, General Listings: change 188925 to 147349 F. Create a Stacked Column chart for the Premier Agents Pivottable. Move the chart to a new sheet named Premier Agent Sales Change the layout of the chart to Layout 3. Change the Chart Title to Average Sales - Premier Change the font size of the Chart Title to 32 pt and change the font color to Standard Green. Remove bold formatting, if necessary. G. Create a Stacked Column chart for the Primary Agents Pivottable. Move the chart to a new sheet named Primary Agent Sales Change the layout of the chart to Layout 3. Change the Chart Title to Average Sales - Primary Change the font size of the Chart Title to 32 pt and change the font color to Standard Green. Remove bold formatting, if necessary H. Create a Stacked Column chart for the Trainees PivotTable. Move the chart to a new sheet named Trainee Agent Sales Change the layout of the chart to Layout 3. Change the Chart Title to Average Sales - Trainees Change the font size of the Chart Title to 32 pt and change the font color to Standard Green. Remove bold formatting, if necessary. 1. On all sheets, insert a file name footer in the left section. Ensure that all the sheets are named correctly Copy of data_07.xlsx Month Sales Price 124984 June 350142 June 775482 Agent Type Premier Agents Premier Agents Premier Agents Premier Agents Premier Agents Premier Agents June June 243413 671674 June 1015877 June 187977 9 Premier Agents June 618391 10 June June 1192992 June 12 13 14 Real Estate Agent Sales City Type Cincinnati General Listings Cincinnati Premium Listings Cincinnati Showcase Listings Cleveland General Listings Cleveland Premium Listings Cleveland Showcase Listings Columbus General Listings Columbus Premium Listings Columbus Showcase Listings Dayton General Listings Dayton Premium Listings Dayton Showcase Listings Cincinnati General Listings Cincinnati Premium Listings Cincinnati Showcase Listings Cleveland General Listings Cleveland Premium Listings Cleveland Showcase Listings Columbus General Listings Columbus Premium Listings Columbus Showcase Listings Dayton General Listings 162560 562085 June 1190945 Premier Agents Premier Agents Premier Agents Premier Agents Premier Agents Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents June 183976 15 June June 688946 16 17 June June 963691 160544 18 19 June 498202 20 Primary Agents June 1086020 21 Primary Agents June 194072 22 Primary Agents June 404482 23 Primary Agents June 908869 24 Primary Agents June 245658 Primary Agents June Dayton Premium Listings 25 26 336478 Primary Agents June Dayton Showcase Listings 1356041 Trainees sune Cincinnati 200469 27 28 General Listings Premium Listings June Cincinnati 422034 Trainees Trainees Tune 29 30 Cincinnati Showcase Listings 1024645 Trainees June Cleveland General listings 156595 31 Trainees June Cleveland Premium Listings 269864 32 Trainees Hunt Cleveland Showcase Listings 1100322 33 R X Copy of data_07.xlsx USD SLOWCELLENT OS NCC General Listings 156595 Trainees June 269864 Cleveland Cleveland Cleveland Trainees June 1100327 Trainees June 143393 33 June Columbus Trainees 530739 34 Trainees June Columbus Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 807007 35 Trainees June Columbus 153367 36 Trainees June Dayton 730337 37 Trainees June Dayton 38 Trainees 1351213 June Dayton 208211 July Cincinnati July Cincinnati 286310 Cincinnati 853868 July July Cleveland 134566 July Cleveland General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 671110 July Cleveland 916759 45 July 151485 46 Columbus Columbus Columbus July July 439618 1359016 July Dayton General Listings 157933 July Premium Listings 356307 39 Premier Agents 40 Premier Agents 41 Premier Agents 42 Premier Agents 43 Premier Agents 44 Premier Agents Premier Agents Premier Agents Premier Agents 48 Premier Agents Premier Agents 50 Premier Agents 51 Primary Agents 52 ce Primary Agents 53 Primary Agents 54 Primary Agents 55 Primary Agents 56 Primary Agents 57 Primary Ments 58 Primary Agents 59 Primary Agents 60 Primary Acents July Dayton Dayton Cincinnati Showcase Listings 884348 July General Listings 244283 541037 July Cincinnati Premium Listings July 1227926 Cincinnati Cleveland Showcase Listings General Listings July 231123 Cleveland Premium Listings 637721 July July Cleveland Showcase Listings 1041363 July Columbus General Listings 158249 Joly Columbus Premium Listings S61859 July Columbus 975043 Showcasettings GeneralListing July Dayton 225095 E Copy of data_07.xlsx 175095 Primary Agents July BE General Listings Premium Listings Showcase Listings Dayton Dayton Dayton Cincinnati 569186 1061923 July July July Primary Agents Primary Agents Trainees 62 166415 63 64 July Cincinnati 454337 Trainees Trainees 65 July 851700 Cincinnati Cleveland 66 169057 Trainees 67 Trainees July July July Cleveland 736338 888762 68 Trainees Cleveland 69 July Columbus General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings Premium Listings Showcase Listings General Listings Premium Listings Trainees Trainees 156050 70 Columbus 494384 July July 71 Trainees Columbus 1159561 72 Trainees Dayton 398683 73 Trainees Dayton 1087761 144169 74 75 July July August August August Premier Agents Premier Agents Cincinnati Cincinnati 344479 1355395 76 Cincinnati Showcase Listings Premier Agents Premier Agents 77 Cleveland General Listings 135867 78 August August Cleveland 292828 Premier Agents Premier Agents Premier Agents 79 80 Cleveland 1274189 August August Columbus Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 205831 81 Columbus 285028 82 83 August August Columbus 1132681 Dayton Premier Agents Premier Agents Premier Agents Pemier Agents Premier Agent Primary Agents Primary Agents August August 125141 255236 B4 85 86 87 Dayton August August 1477938 211555 General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General listings Premium Listings Dayton Cincinnati Cincinnati Cincinnati Cleveland August 88 89 268508 805431 Primary Agents Primary Acents Primary cents August August 188925 90 91 Alust Cleveland 547053 ht E X Copy of data_07.xlsx August 135867 292828 Premier Agents Premier Agents Premier Agents 1274189 205831 Premier Agents August August August August August Premier Agents Premier Agents Cleveland Cleveland Cleveland Columbus Columbus Columbus Dayton Dayton Dayton Cincinnati 285028 1132681 83 August Premier Agents 175141 84 Premier Agents 255236 General Listings Premium Listings Showcase Uistings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 1477938 85 Premier Agents B6 August August August August August August Primary Agents 211558 26860B 87 Cincinnati Cincinnati 88 803431 89 188925 Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents Cleveland Cleveland 90 647053 August August 91 Cleveland 978808 92 Columbus General Listings 177893 August August 93 Columbus Premium Listings 697646 94 August Columbus Showcase Listings 843010 95 165701 Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents Trainees Trainees Dayton Dayton 96 General Listings Premium Listings Showcase Listings 312153 97 1373313 August August August August August August Dayton Cincinnati General Listings 98 99 Cincinnati Premium Listings 220528 481512 1411295 100 Trainees Cincinnati Showcase Listings 101 Trainees Cleveland 170292 102 August August Trainees Cleveland 652935 103 Trainees August Cleveland 1156612 General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings Trainees August Columbus 220841 104 105 Trainees August Columbus 332671 106 Trainees August Columbus 1499524 107 Trainees Aurut Dayton Premium Listings 539103 108 Trainees August Dayton Showcase listings 1408723 Open the file data_07 and Save as Firstname_Lastname A. Create a PivotTable based on data range A2:E108 with the following values: a. FILTERS: Agent Type b. ROWS: City C. COLUMNS: Month d. VALUES: Sum of Sales Price c. DESIGN: Pivot Style Medium 14 B. Rename the new sheet Combined Real Estate Sales Rename Sheet1 to Data on the Combined Real Estate Sales worksheet, create a Slicer based on Type and apply - Slicer Style Dark 6. Apply a filter to include only Showcase Listings. Move the Slicer so the upper left corner is in cell G2. C. Create a copy of the Combined Real Estate Sales sheet and rename Combined Real Estate Sales (2) worksheet to Slicer Return to the Combined Real Estate Sales worksheet and remove the Type slicer filter. D. Click cell A1, Generate three Report Filter Pages, one named Premier Agents, one named Primary Agents, and one named Trainees a. On all three sheets, modify Value Field Settings to summarize by Average. Change cell A3 label to Average Sales Price Adjust the width of Department columns to display the new heading, if necessary. b. On all three sheets, modify Value Field Settings to Number format, remove all decimal places, and check the Use 1000 Separator (.). c. On the combined Real Estate Sales and Slicer worksheets, modify Value Field Settings to Number format, remove all decimal places, and check the Use 1000 Separator (.). E. On the original Data sheet, change the following numbers and update all PivotTables: a. Cell E13 June, Dayton, Premium Listings: change 562085 to 798349 b. Cell E47 July, Columbus, Showcase Listings: change 1359016 to 1987355 c. Cell E89 August, Cleveland, General Listings: change 188925 to 147349 F. Create a Stacked Column chart for the Premier Agents Pivottable. Move the chart to a new sheet named Premier Agent Sales Change the layout of the chart to Layout 3. Change the Chart Title to Average Sales - Premier Change the font size of the Chart Title to 32 pt and change the font color to Standard Green. Remove bold formatting, if necessary. G. Create a Stacked Column chart for the Primary Agents Pivottable. Move the chart to a new sheet named Primary Agent Sales Change the layout of the chart to Layout 3. Change the Chart Title to Average Sales - Primary Change the font size of the Chart Title to 32 pt and change the font color to Standard Green. Remove bold formatting, if necessary H. Create a Stacked Column chart for the Trainees PivotTable. Move the chart to a new sheet named Trainee Agent Sales Change the layout of the chart to Layout 3. Change the Chart Title to Average Sales - Trainees Change the font size of the Chart Title to 32 pt and change the font color to Standard Green. Remove bold formatting, if necessary. 1. On all sheets, insert a file name footer in the left section. Ensure that all the sheets are named correctly Copy of data_07.xlsx Month Sales Price 124984 June 350142 June 775482 Agent Type Premier Agents Premier Agents Premier Agents Premier Agents Premier Agents Premier Agents June June 243413 671674 June 1015877 June 187977 9 Premier Agents June 618391 10 June June 1192992 June 12 13 14 Real Estate Agent Sales City Type Cincinnati General Listings Cincinnati Premium Listings Cincinnati Showcase Listings Cleveland General Listings Cleveland Premium Listings Cleveland Showcase Listings Columbus General Listings Columbus Premium Listings Columbus Showcase Listings Dayton General Listings Dayton Premium Listings Dayton Showcase Listings Cincinnati General Listings Cincinnati Premium Listings Cincinnati Showcase Listings Cleveland General Listings Cleveland Premium Listings Cleveland Showcase Listings Columbus General Listings Columbus Premium Listings Columbus Showcase Listings Dayton General Listings 162560 562085 June 1190945 Premier Agents Premier Agents Premier Agents Premier Agents Premier Agents Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents June 183976 15 June June 688946 16 17 June June 963691 160544 18 19 June 498202 20 Primary Agents June 1086020 21 Primary Agents June 194072 22 Primary Agents June 404482 23 Primary Agents June 908869 24 Primary Agents June 245658 Primary Agents June Dayton Premium Listings 25 26 336478 Primary Agents June Dayton Showcase Listings 1356041 Trainees sune Cincinnati 200469 27 28 General Listings Premium Listings June Cincinnati 422034 Trainees Trainees Tune 29 30 Cincinnati Showcase Listings 1024645 Trainees June Cleveland General listings 156595 31 Trainees June Cleveland Premium Listings 269864 32 Trainees Hunt Cleveland Showcase Listings 1100322 33 R X Copy of data_07.xlsx USD SLOWCELLENT OS NCC General Listings 156595 Trainees June 269864 Cleveland Cleveland Cleveland Trainees June 1100327 Trainees June 143393 33 June Columbus Trainees 530739 34 Trainees June Columbus Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 807007 35 Trainees June Columbus 153367 36 Trainees June Dayton 730337 37 Trainees June Dayton 38 Trainees 1351213 June Dayton 208211 July Cincinnati July Cincinnati 286310 Cincinnati 853868 July July Cleveland 134566 July Cleveland General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 671110 July Cleveland 916759 45 July 151485 46 Columbus Columbus Columbus July July 439618 1359016 July Dayton General Listings 157933 July Premium Listings 356307 39 Premier Agents 40 Premier Agents 41 Premier Agents 42 Premier Agents 43 Premier Agents 44 Premier Agents Premier Agents Premier Agents Premier Agents 48 Premier Agents Premier Agents 50 Premier Agents 51 Primary Agents 52 ce Primary Agents 53 Primary Agents 54 Primary Agents 55 Primary Agents 56 Primary Agents 57 Primary Ments 58 Primary Agents 59 Primary Agents 60 Primary Acents July Dayton Dayton Cincinnati Showcase Listings 884348 July General Listings 244283 541037 July Cincinnati Premium Listings July 1227926 Cincinnati Cleveland Showcase Listings General Listings July 231123 Cleveland Premium Listings 637721 July July Cleveland Showcase Listings 1041363 July Columbus General Listings 158249 Joly Columbus Premium Listings S61859 July Columbus 975043 Showcasettings GeneralListing July Dayton 225095 E Copy of data_07.xlsx 175095 Primary Agents July BE General Listings Premium Listings Showcase Listings Dayton Dayton Dayton Cincinnati 569186 1061923 July July July Primary Agents Primary Agents Trainees 62 166415 63 64 July Cincinnati 454337 Trainees Trainees 65 July 851700 Cincinnati Cleveland 66 169057 Trainees 67 Trainees July July July Cleveland 736338 888762 68 Trainees Cleveland 69 July Columbus General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings Premium Listings Showcase Listings General Listings Premium Listings Trainees Trainees 156050 70 Columbus 494384 July July 71 Trainees Columbus 1159561 72 Trainees Dayton 398683 73 Trainees Dayton 1087761 144169 74 75 July July August August August Premier Agents Premier Agents Cincinnati Cincinnati 344479 1355395 76 Cincinnati Showcase Listings Premier Agents Premier Agents 77 Cleveland General Listings 135867 78 August August Cleveland 292828 Premier Agents Premier Agents Premier Agents 79 80 Cleveland 1274189 August August Columbus Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 205831 81 Columbus 285028 82 83 August August Columbus 1132681 Dayton Premier Agents Premier Agents Premier Agents Pemier Agents Premier Agent Primary Agents Primary Agents August August 125141 255236 B4 85 86 87 Dayton August August 1477938 211555 General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General listings Premium Listings Dayton Cincinnati Cincinnati Cincinnati Cleveland August 88 89 268508 805431 Primary Agents Primary Acents Primary cents August August 188925 90 91 Alust Cleveland 547053 ht E X Copy of data_07.xlsx August 135867 292828 Premier Agents Premier Agents Premier Agents 1274189 205831 Premier Agents August August August August August Premier Agents Premier Agents Cleveland Cleveland Cleveland Columbus Columbus Columbus Dayton Dayton Dayton Cincinnati 285028 1132681 83 August Premier Agents 175141 84 Premier Agents 255236 General Listings Premium Listings Showcase Uistings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings 1477938 85 Premier Agents B6 August August August August August August Primary Agents 211558 26860B 87 Cincinnati Cincinnati 88 803431 89 188925 Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents Cleveland Cleveland 90 647053 August August 91 Cleveland 978808 92 Columbus General Listings 177893 August August 93 Columbus Premium Listings 697646 94 August Columbus Showcase Listings 843010 95 165701 Primary Agents Primary Agents Primary Agents Primary Agents Primary Agents Trainees Trainees Dayton Dayton 96 General Listings Premium Listings Showcase Listings 312153 97 1373313 August August August August August August Dayton Cincinnati General Listings 98 99 Cincinnati Premium Listings 220528 481512 1411295 100 Trainees Cincinnati Showcase Listings 101 Trainees Cleveland 170292 102 August August Trainees Cleveland 652935 103 Trainees August Cleveland 1156612 General Listings Premium Listings Showcase Listings General Listings Premium Listings Showcase Listings Trainees August Columbus 220841 104 105 Trainees August Columbus 332671 106 Trainees August Columbus 1499524 107 Trainees Aurut Dayton Premium Listings 539103 108 Trainees August Dayton Showcase listings 1408723