Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 47 - CodePilot V5.0 C7
P. 47

    Your data will be sorted first by Marks (from Largest to Smallest) and then by Student’s Name   To apply a Custom Filter, follow the given steps:
     (alphabetically) for students with the same score.
                                                                   2    Click on the arrow next to the Price per Unit header.

     If Excel was a magical library, how would you sort books and filter books you had read?  1    Apply filters to the data.

                               3    Hover your mouse pointer
                             over the Number Filters option.
     FILTERING DATA

     You can filter data in Excel to view specific information based on certain criteria without modifying
     the original dataset. This helps you focus on relevant data by hiding the rest.  4    Select the Custom Filter option.

     To filter data, follow the given steps:

                         5    Choose the is greater than option.  6    Enter 22 in the criteria box.
     2    Click on the Sort & Filter option.

     3    Select the Filter option.

     SHORT SIGN

     To add a filter:                                                        7    Click on the OK button.
     Ctrl + Shift + L
     1    Select the range of cells you want to filter.
                     Notice that only the details of the products with a price per unit greater than 22 are displayed and

     4    Click on the arrow next to the header.  the remaining rows are hidden.

                     REMOVING FILTERS

                     You can remove filters in Excel by selecting Clear from the Sort & Filter option.

     5    Click on the checkboxes
     you want to uncheck.

     6    Click OK to apply the filter.
     Your data will now only display rows that meet your filter criteria.
                     This will remove the filters applied to your data and all the rows will be visible again.
     CUSTOM FILTER

     You can apply a Custom Filter in Excel to filter data based on specific conditions that are not
     available in the default filter options. This gives you the flexibility to display data according to   Create a table for some employee details (name, department, salary). Use the filter feature to
     complex criteria such as greater than, less than or contains. For example, suppose you want to   display only employees in the “Sales” department with a salary greater than `50,000.
     find products whose price per unit is greater than 22.

                                                                                                                      45
                                                                                                         Excel in Excel

| 42 43 44 45 46 47 48 49 50 51 52 |