Articles related to excel database files
How to Create a Database in Excel - Spreadsheets - About.com
At times, we need to keep track of information and a good place to this is in an Excel database file. Whether it is a personal list of phone numbers, a contact list ...
Excel Spreadsheets Glossary of Terms - Database Definition
A database is a collection of related information stored in a computer file in an organized ... Excel database files are made up of rows of data known as records.
Tutorials on Excel's Data Management Tools
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 ...
Sample Excel Document for Use in Tutorials - About Databases
If you do not want to create your own address file in Excel, you may download the sample file used in the generation of this tutorial. To save this file in Excel, right ...
Converting an Excel Spreadsheet to an Access Database
Do you have a huge Excel spreadsheet that you can't make heads or tails of? Maybe ... Our database file needs to have a name to be stored on the hard drive.
Sample Excel Document for Pivot Tables - About Databases
It should be used in conjunction with the Creating Pivot Tables in Excel 2010 tutorial found on this site. Download the file: Sample Excel File ...
Converting Excel Spreadsheet to Access 2007 Database
Converting an Excel Spreadsheet to an Access 2007 Database ... along with the tutorial, you can download the sample Excel file used to generate the tutorial.
Exporting Access Tables to Excel - Step-By-Step ... - About Databases
It's often necessary to convert data stored in an Access database to another form, such as an Excel ... Specify an appropriate filename in the “File name” textbox.
Using Excel's Database Functions - Spreadsheets - About.com
Excel has a number of database functions that make it easy to summarize information from large tables of data. This list of tutorials show you how to use each ...
Excel Data Entry Form Tutorials - Spreadsheets - About.com
These tutorials cover how to use a form for data entry in an Excel database. There are separate tutorials for Excel 2010 / 2007 and Excel 2003. Each tutorial ...