Data Management in Excel
If you are new to Microsoft Excel, you will find all the basics you need right here on how to use Excel's data management tools. How to create a list, how to sort it, and how to filter the data to find the specific information you want, are covered in free step by step Excel tutorials, tips and shortcuts for using Excel's data management tools.
Excel 2007 Step by Step Database Tutorial
This tutorial covers how to create a database in Excel 2007. The step by step tutorial includes an example for you to work along with.
This tutorial covers how to create a database in Excel 2007. The step by step tutorial includes an example for you to work along with.
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.
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.
Creating a Drop Down List in Excel's 2007 Part 1
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.
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.
Creating a Drop Down List in Excel 2007 Part 2
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 with data located on a different worksheet.
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 with data located on a different 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.
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.
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.
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.
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.
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.
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.