Page 30 - Plus_V2.2_C7_Flipbook
P. 30
Step 4: Check My data has headers checkbox, if the selected columns have a heading at the top.
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.
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.
Step 2: Click on the Sort & Filter command from Editing group under Home tab. A drop-down list
appears.
28 Premium Edition-VII

