Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Overview
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.

  • Length: 15–20 minutes
 


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.
 
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.
COURSE TEXT

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.

 
BEFORE YOU BEGIN

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.

  Go to previous page (disabled)    Next Go to next page
advertisement