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.
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 ...
Sample Excel Document for Use in Tutorials - Databases - About.com
To save this file in Excel, right click on the link below and select "Save Target As" from the ... Understanding 'Facts' and 'Dimensions' Tables in a Database ...
Converting an Excel Spreadsheet to an Access Database - Databases
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 - Databases - About.com
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 an Excel Spreadsheet to an Access 2013 Database
Converting an Excel Spreadsheet to an Access 2013 Database ... along with the tutorial, you can download the sample Excel file used to generate the tutorial.
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 ...
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 ...
Exporting Access Tables to Excel - Databases - About.com
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.