a. 9. Go to the Projects by State worksheet. Hwan has created a PivotTable on this worksheet to list projects by state, start date, and category. Refresh the PivotTable so it displays the changes you made to the Category data on the Projects worksheet. 10. Reduce the clutter in the PivotTable by modifying it as follows: Change the report layout to show the PivotTable in Outline Form. b. Group the Project Start values by Months. 11. Hwan occasionally would like to focus on the project data according to the start date. Add a Timeline Slicer as follows to the Projects by State worksheet: Insert a Timeline Slicer based on the Project Start field. b. Move and resize the Timeline Slicer so it covers the range A34:F40. Adjust the Timeline Slicer to view all months. a. C. File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Record Macro E Properties TV Use Relative References E Map Properties Import Expansion Packs Export Refresh Data Source Visual Macros Basic Add ins Excel COM Add-ins Add-ins View Code Insert Design Mode Run Dialog Controls ! Macro Security Code Add-ins XML G1 X fic B C D E F G H I J W&K Projects by State 1 2 3 Estimates Category 4 State Bridge 5 OMT 6 3/30/2021 7 4/5/2021 8 4/16/2021 9 5/14/2021 10 6/3/2021 11 END 12 3/1/2021 13 3/24/2021 14 4/14/2021 15 5/10/2021 16 5/26/2021 17 6/24/2021 18 ENE 19 1/12/2021 20 1/20/2021 21 2/22/2021 22 3/12/2021 23 3/23/2021 24 4/2/2021 Documentation Highway Paving Site development Site enhancement Grand Total $29,800 $31,250 $241,067 $302,117 $42,350 $42,350 $70,347 $70,347 $128,370 $128,370 $29,800 $29,800 $31,250 $31,250 $100,800 $230,798 $331,598 $48,932 $48,932 $68,900 $68,900 $78,400 $78,400 $34,566 $34,566 $18,500 $18,500 $82,300 $82,300 $72,358 $45,062 $282,710 $142,236 $34,756 $577,122 $30,562 $30,562 $14,500 $14,500 $107,654 $107,654 $72,358 $72,358 $34,756 $34,756 $27 800 $27 800 Projects Project Stats Projects by State Project Payments Projects by Category Monthly Sal... Ready File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Properties Record Macro Use Relative References A EG Map Properties Import Expansion Packs Export Refresh Data Visual Macros Basic Source QE View Code Insert Design Mode Run Dialog Add- ins Excel COM Add-ins Add-ins ! Macro Security Code Add-ins Controls XML G1 fic D E F H I J K $72,358 $34,756 $27,800 $34,560 $82,350 $100,350 $34,582 $37,650 $81,418 $28,500 $168,687 $38,750 A 22 3/12/2021 23 3/23/2021 24 4/2/2021 25 4/23/2021 26 6/1/2021 27 6/12/2021 28 6/17/2021 29 6/26/2021 30 ESD 31 2/22/2021 32 4/2/2021 33 4/17/2021 34 5/14/2021 35 5/30/2021 36 6/20/2021 37 =WY 38 2/16/2021 39 3/20/2021 40 4/5/2021 41 5/2/2021 42 6/6/2021 43 Grand Total $28,500 G $72,358 $34,756 $27,800 $34,560 $82,350 $100,350 $34,582 $37,650 $278,605 $38,750 $28,500 $56,890 $24,528 $85,437 $44,500 $193,753 $54,672 $24,505 $19,576 $19,750 $75,250 $1,683,195 $56,890 $24,528 $85,437 $44,500 $44,255 $75,250 $74,248 $54,672 $24,505 $19,576 $19,750 $75,250 $176,406 $258,530 $858,325 $355,178 $34,756 44 45 47 48 Documentation Projects Project Stats Projects by State Project Payments Projects by Category Monthly Sal ... + Ready a
