Page 30 - Plus_V2.2_C7_Flipbook
P. 30

Step 4:  Check My data has headers checkbox, if the selected columns have a heading at the top.

                  Step 5:   Click on the Sort by box and select the column header according to which you want to sort
                          the data. In this case, we have selected Client Name header.
                  Step 6:  Click on the Sort On box and select Cell Values option.

                  Step 7:   Click on the Order box and select the A to Z or Z to A option. In this case, we have selected
                          A to Z option.

                  Step 8:   Click on the Add Level button at the top of the Sort dialog box to add another column to sort.
                          In this case, we have added Amount Billed column.

                  Step 9:  Click on the OK button.
















                                                              Sort dialog box
                  The data will be sorted according to the criteria defined.



                                                             Tech Hint
                                                      To sort data: click Data → Sort





                          Let’s CatCh uP

                    Why sorting is important?
                    ________________________________________________________________________________

                    ________________________________________________________________________________




                         FILTERING DATA


                  You must have studied about filtration process which is used to separate unwanted material from a
                  mixture. Excel also allows you to filter unwanted data from a set of data. To apply filters, follow these
                  steps:
                  Step 1:   Select the range of columns to be filtered.

                  Step 2:   Click on the Sort & Filter command from Editing group under Home tab. A drop-down list
                          appears.


                  28    Premium Edition-VII
   25   26   27   28   29   30   31   32   33   34   35