Page 54 - Digicode_AI_class_7
P. 54

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:


                                   2  Click on the Insert tab.

               3  Click on the
               Pivot Table
               command.












                 1  Select the data on which you want to apply Pivot Table command.  4  Click on the OK button.









                                                                                  6  Drag the Department
                                                                                 field from Choose fields
                                                                                 to add to report box
                                                                                 and  drop  into  Column
                                                                                 Labels box.


                                                                                  7   Drag the  Total  field
                                                                                 from Choose  fields  to
                     5  Drag the Employee Name field from Choose fields          add to  report box  and
                     to add to report box and drop into Row Labels box.          drop into Values box.

            Your report will appear on the worksheet.


                  REFRESH


                  A database implies that organising the data in a manner which helps to store and retrieve a large
                 amount of data efficiently.
                 A form is a window used to display or enter a record in an Excel worksheet.
                 Excel can apply filters to show only required information and hide the unwanted information.
                 Conditional Formatting can be applied on the basis of various criteria.
                  Data validation means to restrict the user to enter a specific range of values in a particular cell or a
                 range of cells.
                 The Subtotal command allows you to calculate group-wise sum.
                 The Pivot Table feature of Excel 2016 allows you to analyse the large amount of data.


                 52    DigiCode AI-VII
   49   50   51   52   53   54   55   56   57   58   59