Computer Training

Microsoft Excel 2003

Sorting Custom Lists

1. Create a new spreadsheet and name it Custom Lists. Enter the data below.
   

   Cell	Entry
   A1	Date
   B1	Department
   C1	Purchase
   D1	Cost

2. Click in cell A2 and enter the starting date shown. Press the tab key and then enter the data below in the cells listed.

   Date	Department	Purchase	Cost
   8/2/2006	A	Printing	$44.00
   8/3/2006	B	Software	$124.00
   8/4/2006	C	Computers	$3,200.00
   8/5/2006	C	Software	$500.00
   8/6/2006	C	Printing	$79.00
   8/7/2006	A	Software	$300.00
   8/8/2006	A	Computers	$1,200.00
   8/9/2006	C	Printing	$55.00
   8/10/2006	B	Computers	$2,400.00
   8/11/2006	B	Printing	$150.00
   8/12/2006	A	Software	$300.00
   8/13/2006	B	Printing	$79.00

3. Click on the menus Tools | Options and then the tab Custom Lists. Enter the following data: Computers, Printing, and Software. Click on the buttons Add and OK. The new custom list is saved.
4. Click on the menus Data | Sort. Choose Department and Ascending order from the Sort Options dialog box.
5. Click on the button Options to open the Sort Options dialog box. Click on the First key sort order's drop down arrow and choose the custom list Computers, Printing, and Software.
6. Change the orientation option to Sort top to bottom and then click on the OK button.
7. Click on the menus Data | Subtotals. Under the label At each change in: select Department, Use Function: Sum, and Add subtotal to: check the box Cost.
   Note: You need to check the boxes Replace current subtotals and Summary below data and then click on the OK button.