The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

How Excel makes a relational database Relational databases—databases structured to recognize relations among the information stored in them—are essential for working with large amounts of ...