Data Management in Excel

A drop down list for data entry can make it easier to limit the type and amount of data that can be entered into a worksheet. This tutorial includes a step by step example of creating a drop down list in Excel

Part 2 of Creating a Drop Down List in Excel cover's creating a drop down list using data located on a different worksheet. This tutorial includes a step by step example of creating a data validation list in Excel using data from a separate worksheet.

In addition to creating drop down lists, Excel's data validation options can be used to stop invalid data from being entered into specific cells in a worksheet. An error alert message can also be displayed explaining the restrictions that are in place.

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.

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 with data located on a different worksheet.

A pivot table makes it easy to organize and extract information from a large table of data without the use of formulas in Excel. The tutorial includes a step by step tutorial example of how to create a pivot table in Excel.

This tutorial covers how to create a database in Excel. The step by step tutorial includes an example for you to work along with.

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.

This tutorial covers how to use a form to enter data into a database table in Excel. A step by step example of how to do data entry using a form is included.

This quick tip shows you how to access the data form in Excel 2007 / 2010 by adding the data form icon to the Quick Access Toolbar.

This tutorial shows you how to remove rows of duplicate data or records from an Excel database. The tutorial also includes a step by step example of how to remove duplicate data records in Excel.

This is a bare bones version of the Remove Duplicates tutorial listed above. It is intended for those familiar with using Excel's data management features.

The Remove Duplicates feature in Excel can find and remove duplicate rows or records of data in a database. The tutorial includes a step by step example of how to use Remove Duplicates in Excel.

Using Excel's sort feature. Step by step example of sorting data in Excel.

Using Excel 2003's sort feature. Step by step example of sorting data in Excel 2003.

Sort by Date using Excel's sort feature. Step by step example of how to sort by date in Excel.

Sort multiple columns of data using Excel's custom sort feature. Step by step example of how to sort multiple columns of data in Excel.

Sort data by font color in Excel. Included is a step by step example of how to sort data by font color in Excel.

Sort data by cell color in Excel. Included is a step by step example of how to sort data by cell color in Excel.

Excel's SUBTOTAL function returns one or more subtotals in a database or list of data. The step by step tutorial includes an example how to find subtotals using the Excel Subtotal Feature.

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to insert subtotals and totals into a database.

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the largest values in subsections of a database.

Excel's SUBTOTAL feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes examples of how to find an average value for your data using the Excel SUBTOTAL feature.

Excel's Subtotal feature lets you find one or more subtotals in a database or list of data. This step by step tutorial includes an example of how to use Excel's Subtotal feature to find the smallest values in subsections of a database.

This document contains pivot table data for the Excel subtotal tutorial. The subtotal tutorial data is to be copied and pasted into the tutorial worksheet.

This document contains pivot table data for the Excel 2007 pivot table tutorial. The pivot table data is to be copied and pasted into the tutorial worksheet

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.

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.

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.

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.