SECTION 2
Lesson 2.1: Working with Lists

   

 

 

 

 

Excel 2003 is more than just a spreadsheet program. You can actually use Excel 2003 as a basic database application. All that you have to do is get comfortable with using lists.

 

To help with this, Excel 2003 has new features to make managing lists easier. You can define a range of data as a list, and it will be highlighted with a blue border that distinguishes it from other data. The list toolbar and auto filter arrows (beside the column headings) help you to manage and maintain your database. You can even take advantage of user-friendly forms to navigate and access your lists. In short, the list and database features in Excel 2003, offer an alternative to complex database applications for basic database needs.

 

In this lesson you will learn what a list is, how to create a list, how to modify a list, and how to work with the total row