Page 65 - TP_Modular_V2.1_Class7
P. 65

Step 5   Select  the  column in  which  you  want  to  add  subtotal  from  the  Add  subtotal  to
                         drop-down list.

                 Step 6   Click on the OK button. The subtotal and grand total will appear.


                          Tech Funda



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




                    USING PIVOT TABLE

                 The  Pivot  Table feature  of Excel 2016 allows you  to  analyse the  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 Pivot Table command.
                 Step 2   Click on the Pivot Table command from the Tables group of the Insert tab.
                 Step 3   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      63
   60   61   62   63   64   65   66   67   68   69   70