Page 59 - ModularV1.1 _c7_flipbook
P. 59

Tech


                       Funda
                                    To remove subtotals, click on the Subtotal command and click on the
                                    Remove All button.



                     USING PIVOT TABLE

                 The Pivot Table feature of MS Excel allows you to analyse large amount of data. It consolidates,
                 summarises and presents data. Perform the following steps to use the Pivot Table:
                 Step 1   Select the data on which you want to apply the Pivot Table command.

                 Step 2   Click on the Pivot Table command from the Tables group of the Insert tab.
                         A drop-down list appears.
                 Step 3   Select the Pivot Table option. The Create Pivot Table dialog box appears displaying the
                         range you have selected.














                                      Using Pivot Table feature                                                     Create Pivot Table dialog box
                 Step 4   Click on the OK button.  A new worksheet will appear with Pivot Table Field List pane.

                 Step 5   Drag the desired column from Choose fields to add to report box and drop into
                         Row Labels box. In this case, we have dragged and dropped the Employee Name
                         field.

                 Step 6   Drag the desired column from Choose fields to add to report box and drop into Column
                         Labels box. In this case, we
                         have dragged and dropped the
                         Department field.
                 Step 7   Drag the desired column from
                         Choose fields to add to report

                         box and drop into Values box.
                         In this case, we have dragged
                         and  dropped  the  Total  field.
                         Your report will appear on the
                         worksheet.


                                                                          Summarising data using Pivot Table


                                                                                              Excel as Database   57
   54   55   56   57   58   59   60   61   62   63   64