Page 54 - ThinkGPT_V2.1_C7_Flipbook
P. 54

Using PivotTable
                  The PivotTable 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 PivotTable:


                                         2  Click on the Insert tab.


                     3  Click on the
                     PivotTable
                     command.













                       1  Select the data on which you want to apply PivotTable 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 ROWS box.                drop into VALUES box.

                  Your report will appear on the worksheet.

                        REFRESH


                        A spreadsheet is a digital tool that organises data in a grid of rows and columns.
                       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 PivotTable feature of Excel 2016 allows you to analyse the large amount of data.


                       52    Premium Edition-VII
   49   50   51   52   53   54   55   56   57   58   59