If you ever created a database file in a spreadsheet program like Excel you'll know that it does a great job. Whether you have a contact list for an organization, an inventory of parts, or a library catalog of books or DVD's, Excel has the tools to make the job simple and straightforward.

As your database grows in size, one tool that can make it easier for you to add new data or keep your current information up to date is the data entry form.

This form takes all the guess work out of adding new records and it makes it easy to find, edit, or delete existing ones.

To start using the form for your data entry, read the step by step tutorial on the Excel 2007 Data Entry Form.

Related Articles

• Access the Data Form in Excel 2007
• Remove Duplicate Data Records in Excel 2007
• Excel 2007 Step by Step Database Tutorial

If you ever need to keep track of a large quantity of information one option is to create a database file in a spreadsheet program like Excel. Whether it's a contact list for an organization, an inventory of parts, or a library catalog of books or DVD's, Excel has the tools to make the job simple and straightforward.

These database tools can make it easier for you to sort and search through your data to find the specific information you need.

To help you started, read the Excel 2007 Step by Step Database Tutorial. The tutorial covers fields and rows of data, creating tables, and using Excel's sorting and data filtering tools.

Related Articles

• Excel 2003 Step by Step Database Tutorial
• Creating a Drop Down List in Excel 2007 Part 1
• Creating a Drop Down List in Excel 2007 Part 2

A pivot table is a great tool for sorting and summarizing the data in a spreadsheet or database file.

It can automatically sort, count, and total spreadsheet data and then create a second table to display the summarized data.

Once you have finished looking at the summarized data, you can quickly re-sort your data and look at it from a totally different perspective, and all of this can be done without using functions or formulas.

Despite being so useful, many people shy away from using them, on the belief that they are hard to use. They aren't really, and once you get the hang of them, you'll use them at every opportunity.

To find out more about this handy tool, read the Excel 2007 Pivot Table Tutorial.

Related Article

• Excel 2003 Pivot Tables (video)

Recently I was using Excel's AutoComplete feature to quickly add some data to one of my spreadsheets. The data had many duplicates so AutoComplete helped to speed up the process quite a bit. AutoComplete, however, is not always so useful when it comes to entering data into spreadsheets.

If your data doesn't contain any duplicates, then AutoComplete can be more of a bother than a help. The black box containing the suggested completion shows up in the cell you are typing in, and while it does disappear if you keep typing, I find it distracting and I often end up with data entry errors.

When this starts happening, I find the best thing to do is to just turn AutoComplete off until I've finished entering data into my spreadsheets. It only takes a few clicks so it's easy to turn the feature off until you need it again. If you would like to do the same, read the article on how to Turn Off AutoComplete.

Related Articles

• Using AutoComplete to Enter Data
• Turn Off AutoComplete in Excel 2003