Sort and filter lists
AutoFilter drop-down lists [4] are automatically added in the header row of a list when the list is created.
Ensure data integrity
For lists that are not linked to SharePoint lists, you can use the built-in data validation features in Excel.
Easier data entry
using a list will reduce keystrokes, typos and allow more flexibility on the cursor movement and use of forms.
Format list objects
You can format cells in a list the same way that you format cells in a worksheet.
Insert rows
Another action that is common when you work with a list is to add a new row.
This interface element consists of a blank row, displayed directly below the last row of data, with a blue asterisk (*) inside the left-most cell.
Sources:
1/ http://blogs.techrepublic.com.com/msoffice/?p=999&tag=nl.e056 [5]
2/ http://office.microsoft.com/en-us/excel/HP010044331033.aspx [6]
Links:
[1] http://pulse.veltsos.com/category/it/data-management
[2] http://pulse.veltsos.com/category/it/software/software/os/microsoft
[3] http://linux.philosweb.com/drupal5/files/Excel_icon_2.jpg
[4] http://office.microsoft.com/
[5] http://blogs.techrepublic.com.com/msoffice/?p=999&tag=nl.e056
[6] http://office.microsoft.com/en-us/excel/HP010044331033.aspx