Sorting and Filtering.pptx

Sorting and filtering types in excel

1. Sorting and Filtering By Dr. Abhishek Kumar Singh Excel

2. Sorting Arranging record in a specific sequence is called sorting. It is represented as of two types Ascending order If it is sorted from lowest to highest. Descending order If it is sorted from highest to lowest.

3. Sorting Number Sorting Text Sorting Date Sorting Multi-column Sorting Color Sorting

4. Filter Filtering refers to comparing a list of records against specific criteria and then hiding the records that don’t match the criteria. It can be used simply to help find a record, or to create a subset of data that you can then edit , format , copy , move , chart or otherwise manipulate without affecting the other records.

5. Filter In MS-Excel To apply/remove filter (by shortcut key) Ctrl + Shift + L To apply/remove Filter (without mouse) Alt  A  T Contd …

6. Filter Number Sorting Text Sorting Date Sorting Sort (A-Z, Z-A) Sort by Color Number Filter Sort (A-Z, Z-A) Sort by Color Text Filter Equal =, <, >, <=, >= Above Average Below Average Begin with, End With Contain Equal, Does not equal