Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

Tips This article applies to Microsoft Excel 2007, 2010, and Office 365. View the videos listed in the Resources section for more ideas on using Excel's database functions.