Organize Your Records the Way You Want Them in Excel

You can customize how you sort your records by using a filter. To activate a filter:
1. In Microsoft Office Excel 2007, click Filter on the Data tab.

2. To choose your sorting options, click the filter arrow on the column that you want to sort, point to Sort by Color, and then click Custom Sort.

3. Create a customized sort order.
a. In the Sort dialog box, under Column, click the drop-down arrow next to Sort by, and choose the field that you want to be sorted. Values should appear in the Sort On field.
b. In the Order field, click Custom List. This will open a window that offers an entirely custom sort list.
c. In the left pane, list the values (each separated by a comma) in the order that you want them to be sorted, and then click Add.
d. In the right pane, select the list you've created, and then click OK.
e. In the Sort dialog box, click OK.

From now on, your records will be sorted according to your customized list.

Easy Filtering of Data in a Microsoft PivotTable View

There is a better way to select multiple report filters than dragging the filter down to a row. It is quicker to select additional filters directly from the original filter.

1. Select the filter, and then click multiple items at the bottom.

2. The filter selection changes to check boxes. Simply select the boxes you require.