Friday December 18, 2009
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
Wednesday December 16, 2009
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
Monday December 14, 2009

Excel Pivot Tables
© Ted French
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
Friday December 11, 2009

Turn Off AutoComplete in Excel
© Ted French
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