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.

Part Two covers how to maintain and manage that database, and Part Three shows how to create a document with custom merged fields from Excel, then save it as a template to reuse later. 1.