1. Computing
Send to a Friend via Email

Data Management in Excel

Here you will find tutorials on how to create a database in Excel as well as a creating drop down lists, using the data entry form, sorting and filtering data, removing duplicate records, and more.
  1. Excel Sorting Tutorials (6)
  2. Excel Data Entry Form Tutorials (4)
  3. Excel Drop Down List Tutorials (6)
  4. Database Functions (7)
  5. Excel Subtotal Tutorials (5)

Prevent Invalid Data Entry in Excel
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.

Excel Pivot Table Step by Step Tutorial
A pivot table makes it easy to organize and extract information from a large table of data without the use of formulas in Excel.

Excel Database Tutorial
This tutorial covers how to create an Excel database and how to use the built in database tools that make it easy to sort and filter a database file to find the information you want.

Excel Step by Step Database Tutorial
Similar to the tutorial above except this one covers how to create a database in Excel 2003.

Remove Duplicate Data Records in Excel Part 1
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.

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.

Remove Duplicates in Excel Part 2
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.

Data for Excel Pivot Table Tutorial
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

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.

Access the Data Form in Excel 2007
This quick tip shows you how to access the data form in Excel 2007. Add the data form to the Quick Access Toolbar.

Enter Data Using a Form in Excel
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.

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.

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

Sort by Date in Excel
This tutorial covers how to sort by Date using Excel's sort feature. A step by step example is included.

Sort Data by Font Color 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
Sort data by cell color in Excel. Included is a step by step example of how to sort data by cell color in Excel.

Inserting 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 insert subtotals and totals into a database.

Find the Largest Values with Excel's 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 largest values in subsections of a database.

Find Average Values with Excel's 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 examples of how to find an average value for your data using the Excel SUBTOTAL feature.

Find the Smallest Values with Excel's 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.

Excel Database Functions Tutorial Data
This document contains data for the Excel database functions step by step tutorials. Instruction are included to explain how to copy the data into a blank worksheet.

©2014 About.com. All rights reserved.