Page 1 of 15PREVNEXT

Lists I: How to use lists in Excel 2003

An Excel list
There's a new List command in Microsoft Excel 2003 that makes it easy to sort and filter data and to total up values.

About this course

This course includes:

  • Two self-paced lessons and two practice sessions for hands-on experience.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Goals

After completing this course you will be able to:

  • Create a list using the List command.
  • Add up values in lists using the List toolbar.
  • Use the AutoFilter arrows to sort and filter list data.

Data in Excel rows and columns can be sorted, filtered, and totaled. In Excel 2003 there's a powerful and easy way to do these tasks, using the new List command. What's a list? Think of orderly rows of data such as addresses, names of clients or products, and quarterly sales amounts.

If you're familiar with Excel, you'll recognize some features in this course (AutoFilter arrows, for instance), but you'll see them applied to the data in a new and very convenient way.

To learn more about this course, read the overview in the center of this page or the table of contents in the left column.

When you're done reading this page, click Next to start the first lesson.


Note     The new List command in Excel 2003 also makes it easy to share data with others by publishing the list to a server that is running Microsoft Windows® SharePoint® Services. That topic is not discussed in this course.

Page 1 of 15PREVNEXT