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.

To activate Power Pivot, go to File > Options, click Add-ins, select COM Add-ins from the dropdown, and check the box for ...