The steps are to be done in excel , please help me with the process. it's for accounting information system class

1. Go to the Sales by Client worksheet. Nadia created a PivotTable named ClientPivot that lists sales by client and state, but she wants to simplify the PivotTable by displaying the sales by client and region. Manually group the CT, NJ, and NY column labels (cells B3, E3, and F3). Use North as the name of the group. Manually group the GA and FL column labels in row 4 and use South as the name of the group. Remove the State field from the Columns area. Rename the State2 field to use Region as the custom name. Sort the South values in ascending order to list first the North sales amounts in column B followed by the South sales amounts in column C. Hide the field headers to further streamline the layout.

Do = NP_EX19_EOM11-1_RochiBorbon_2 Q- Search Sheet Home Insert Page Layout Formulas View Pivot Table Analyze Design + Share Data Review Expand Field Pivot Table Name: Active Field: fx State Field Group Selection Refresh Change Clear Select Fields PivotChart Move Pivot Table Data Source Items, & Sets Field List +/- Field Buttons Headers ClientPivot Options Collapse Field Insert Insert Filter Settings Slicer Timeline Connections x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. F3 fx NY Check for Updates B D E E F G H 1 J K L M N Pivot Table Fields x FIELD NAME Q Search fields Service Client ID Category State Start Date Filters III Columns : State QUALEY CONSULTING SALES BY CLIENT 1 2 Sum of Total Sales Column Labels 3 Row Labels FL GA NU NY Grand Total 4 ASHBY $39,105 $39,105 5 CLAUS $60,095 $60,095 6 FLATH $37,035 $37,035 7 HARRA $38,220 $38,220 8 KERRA $35,945 $35,945 9 9 LUCIO $30,010 $30,010 10 MIRSS $32,835 $32,835 11 NEETN $20,055 $20,055 12 RENOR $47,155 $47,155 13 WELLS $9.990 $9,990 14 Grand Total $47,155 $52,890 $76,140 $98,315 $75,945 $350,445 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 E Rows Values : Client ID : Sum of Total Sales : Documentation Sales Report Sales by Category Sales by Client Sales by Service Drag fields between areas + Ready Average: 37972.5 Count: 5 Sum: 151890 + 100%