How to Create a Data List in Excel 2007

Creating a data list, or Excel table, can help you store a large amount of data consistently, as well as give you the ability to easily read, sort, and filter that information. This video tutorial shows you how to create a simple data list in Excel 2007.

Comments (1)

  1. Posted by John Franco
    Great video Don't forget to follow Microsoft recommendations to make your list reliable... 1. Use only one list per worksheet 2. Put similar items in one column 3. Leave at least one blank column and one blank row between the list and other data on the worksheet 4. Position critical data above or below the list 5. Show rows and columns Source: http://www.excel-spreadsheet-authors.com/excel-list.html

Leave a Reply


Post Comment

Connect with For Dummies

Sign Up for RSS Feeds

Computers & Software

Inside Dummies.com