Page 23 - TP_Prime_V2.2_Class7
P. 23

The Sort dialog box opens.
                 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 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.                                                                     ADVANCED FEATURES OF EXCEL

                 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.






                                                                                                                          21






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

                                                                              To sort data: click Data → Sort
                   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.
                 Step 3:  Click on the Filter option from the drop-down list.



















                                                             Using Filter
   18   19   20   21   22   23   24   25   26   27   28