Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 50 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 50

    FILTERING DATA

                      You must have studied about filtration process which is used to separate unwanted material from
                      a mixture. The AutoFilter option allows you to filter data based on a specific value or criteria. To
                      apply AutoFilter, follow the given steps:

                      Step 1  Select the range of columns to be filtered.

                                                                  Unfiltered data

                      Step 2  Click on the Data menu.
                      Step 3   Click on the Filter option. A submenu appears.

                      Step 4  Click on the AutoFilter option. You will notice that small arrows         appear in front of
                               all the column headers.
                      Step 5   Click on the arrow in front of the header Department to open a drop-down list. You will
                               notice that all the entries in the column are present in the list with small checkboxes in
                               the beginning.

                      Step 6   Click on Sales checkbox to uncheck it.
                      Step 7  Click on the OK button.

                                                    Using AutoFilter option           Using filter options

                                                                  Filtered data

                     48     Premium Edition-VII

| 45 46 47 48 49 50 51 52 53 54 55 |