Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    You will notice that the rows of unchecked data are removed from the list. You need not to worry
                     as the data is not lost. Notice the row headings. Some of the row headings are missing. The

                     unchecked rows have just been hidden from the display. To get the data back, open the filter list
                     again and check the unchecked entries. You can use the Standard Filter to apply advanced filtering
                     criteria. Suppose you want to know the names of the employees from the Sales department who
                     have more than two years of experience.
                     Perform the following steps to apply a Standard Filter:
                     Step 1  Select the range of cells you want to filter, including the headers.

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

                     Step 4  Click on the Standard Filter option. The Standard Filter dialog box will open.
                     Step 5  Under the Filter Criteria section, in the Field name drop-down list, select Department
                              as the first criterion.
                     Step 6  In the Condition drop-down list, select equals (=).

                     Step 7  In the Value drop-down list, select Sales to filter for employees from the Sales department.
                     Step 8  Under the Operator drop-down list, choose AND to connect rows that meet both filter
                              criteria.

                     Step 9  To add another filter condition, in the second row of the Filter Criteria section, in the
                              Field Name drop-down list, select Years of Experience as the second criterion.
                     Step 10  In the Condition drop-down list, select greater than (>).

                     Step 11  In the Value drop-down list, enter 2 to filter only rows where the years of experience
                              are greater than 2.
                     Step 12  Once you have set up all criteria, click the OK button.

                                                              Using Standard Filter

                                                                                            Using Calc as Database       49

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