Page 45 - Computer_Genius_v2.1_C7_flipbook
P. 45

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.

                       Let's 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.



                                                                             Advanced Features of Excel 2016  43
   40   41   42   43   44   45   46   47   48   49   50