Data Management in Excel
- Excel Sorting Tutorials (6)
- Excel Data Entry Form Tutorials (4)
- Excel Drop Down List Tutorials (6)
- Database Functions (7)
- 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 Step by Step Database Tutorial
This tutorial covers how to create a database in Excel. The step by step tutorial includes an example for you to work along with.
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
Excel 2003 Step by Step Database Tutorial
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.
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.