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.

You can also create relational databases in Excel, with the master database in one file and the related databases in other files. But that’s another complex process for a future article.