Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 30 - 2626_South Point_C-7
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 |