Page 30 - TP_Pluse_V2.2_Class_7
P. 30
Step 5: Click on the Sort by box and select the column header according to which you want to sort
the data. In this case, we have selected Client Name header.
Step 6: Click on the Sort On box and select Cell Values option.
Step 7: Click on the Order box and select the A to Z or Z to A option. In this case, we have selected
A to Z option.
Step 8: Click on the Add Level button at the top of the Sort dialog box to add another column to sort.
In this case, we have added Amount Billed column.
Step 9: Click on the OK button.
Sort dialog box
The data will be sorted according to the criteria defined.
If Excel was a magical library, how would you sort books and filter books you had read?
Tech Hint
To sort data: click Data → Sort
Let’s CatCh uP
Why sorting is important?
________________________________________________________________________________
________________________________________________________________________________
FILTERING DATA
You must have studied about filtration process which is used to separate unwanted material from a
mixture. Excel also allows you to filter unwanted data from a set of data. To apply filters, follow these
steps:
Step 1: Select the range of columns to be filtered.
28 Plus (Ver. 2.2)-VII

