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.

Cons of using Excel as a database Limited security Before you fully embrace Excel as a database tool, make sure to keep the following cons in mind.

Using Forms in Microsoft Excel By following these steps, you can add and utilize forms in Microsoft Excel to enhance your data entry and management.

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.