> Data Management in Excel

Excel Database Files
This tutorial shows you how to create an Excel database. An Excel database can be used to keep track of valuable information such as phone numbers, DVD collections, or a contact list of your organization's members. Excel has built in database tools that make it easy to sort and filter a database file to find the information you want.

How to Create Lists in Excel
This tutorial shows you how to create lists to keep track of valuable information such as phone numbers, DVD collections, or a contact list of your organization's members. Excel's built in tools make it easy to create lists and filter or sort them according to the criteria needed at the time.

Creating a Drop Down List in Excel's 2007
Use a drop down list in Excel to make data entry easier or to limit what data can be added to a spreadsheet. This article shows you how to create a drop down list in Excel 2007.

Data Validation Tips, Tricks, and Answers
One problem when using Excel for data management is keeping the data error free. Often data is entered incorrectly so that the city name, for example, ends up where the zip code belongs. Excel’s data validation tool can limit these errors by restricting what data can be entered into a data field. Use this site’s data validation tutorials to help keep your lists and tables of data error free.

Creating a Custom Data Entry Form
A data form is a dialog box that gives you a convenient way to enter data records into a list or data table. A data form can also be used to view, change, locate, and delete records. This tutorial walks you through creating a custom data form complete with textboxes, labels, buttons, and the VBA code needed to make the whole thing work.

Using Advanced Filters in Excel
Filtering a list or data table in Excel is a quick and easy way to find only those rows in the list or table that meet specific criteria. There are two levels of filtering – AutoFiltering and Advanced Filtering. Advanced Filtering allows you to specify more complex criteria then does AutoFiltering so that the range of data can be filtered to a greater degree.

Importing Text Files into Excel
External data is data stored in a program other than Excel. Accounting programs and databases are two programs that contain data often imported into Excel and analyzed. It is common for external data to be saved as text files. This tutorial walks you through using the “Text Import Wizard” in Excel. The tutorial also includes a practice file that you can use for additional practice.