Databases

C

cadman29

Is there any way to create a database with Excel??
I currently use Pc-File to sort and print the contacts to make label
and other reports but I would like to switch to Excel if I can.

Is it possible??

Thanks
Cadman2
 
B

Bob Umlas, Excel MVP

In Excel, any list of similar values* is treated like a database. It is a flat-file database (not relational), but there are many functions specifically designed to work with this kind of structure (D-formulas such as DSUM, DAVERAGE, DMAX, DMIN, DCOUNT, etc).

*I mean each column contains like data. For example, column A would be Names, B would be States, C would be Amounts, etc.
 
A

Andrew

Excel 2002 has a template wizard that allows you to setup
a small database (99 data points) and form for entering
data into that database.
Andrew
 
Top