4: Creating PivotTables and PivotCharts GO! Think Project 4L Golf Course Revenue Project Files For Project 4L, you will need the following file: e04L Golf Courses You will save your workbook as: Lastname_Firstname_41_Golf Courses Open the file e04L Golf Courses, and then save it in your Excel Chapter 4 folder as Lastname Firstname 4L Golf Courses From the source data, create a PivotTable and filter the report on Month. Use Course as the row labels and Item as the column labels. Sum the amounts and apply appropriate number formatting. Create a PivotChart report on a separate sheet for the 3rd Quarter Revenue. Exclude Logo Shirts and Golf Balls from the PivotChart, and then apply appropriate formatting. Hide the source data worksheet. Insert the file name in the left section of the footer on each page, center horizontally, set the orientation to landscape, add appropriate information to the document properties, including the tags golf course revenue and submit as directed by your instructor. You have completed Project 4L ENI A1 1 File Home Insert Draw Page Layout Formulas Data Rev A Revenue from City Golf Courses B C Revenue from City Golf Courses D E F 12 Month Course Item Amount 3 July Wynwood Food 821 4 July Highland Park Food 628 5 July Emerald Hills Food 704 6 July Eagle Park Food 656 7 July Los Robles Food 776 8 July Crystal Springs Park Food 1122 9 July Wynwood Beverages 374 10 July Highland Park Beverages 253 11 July Emerald Hills Beverages 271 12 July Eagle Park Beverages 364 13 July Los Robles Beverages 307 14 July Crystal Springs Park Beverages 332 15 July Wynwood Season Passes 266 16 July Highland Park Season Passes 241 17 July Emerald Hills Season Passes 239 18 July Eagle Park Season Passes 191 19 July Los Robles Season Passes 174 20 July Crystal Springs Park Season Passes 168 21 July Wynwood Golf Balls 90 22 July Highland Park Golf Balls 60 23 July 24 July Emerald Hills Golf Balls 30 Eagle Park Golf Balls 36 25 July Los Robles Golf Balls 60 26 July Crystal Springs Park Golf Balls 30 27 July Wynwood Logo Shirts 36 28 July Highland Park Logo Shirts 42 29 July Emerald Hills Logo Shirts 46 30 July Eagle Park Logo Shirts 54 31 July Los Robles Logo Shirts 50 32 July Crystal Springs Park Logo Shirts 44 Golf Courses Revenue Ready Accessibility: Good in an