Sorting the data:

1. select the data to be sorted (or) select a cell within the data
2. Data tab–>Sort & filter tab–>sort button/AtoZ/ZtoA button
   1. Sort by: Select name of the column by which sorting is to be done
   2. Ascending/Descending order to be selected
   3. Then by: Select name of the column by which further sorting is to be done
   4. My dataRange has: Select Header Row to skip first row from sorting

Filtering data:

1. select the data to be sorted (or) select a cell within the data
   1. Data tab–>Sort & filter tab–>filter button
   2. Drop down arrow marks appear at the top of each column
   3. Click on drop down arrow to select the criteria by which the data to be filtered
   4. Removing Filter: Data tab–>Sort & filter tab–>filter button