Page 69 - modular4.0
P. 69

Chapter Profile
                 Perform the following steps to use the Subtotal command:

                                                                                                  2  Click on Data tab.


                                                                                                  3   Click  on  the

                                                                                                 Subtotal command
                                                                                                 in   the   Outline
                                                                                                 group.
                   1   Select  the  data  on
                  which you want to apply
                  Subtotal command.






                   4  Select the column T-Shirt Size from
                  the At each change in drop-down list.


                                                        5   Select  the
                                                        Count function
                                                        from the  Use
                                                        function drop-
                                                        down list.


                                                        6  Check the
                                                        T-Shirt   Size
                                                        column name
                                                        in  the   Add
                                                        subtotal to list.


                                                        7  Click on  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 2019 allows you to analyse the large amount of data. It consolidates,
                 summarises and presents data.





                                                                                                   Excel as Database  67
   64   65   66   67   68   69   70   71   72   73   74