Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Small databases of a few rows, to a few thousand rows, can often be created more quickly and easily in Microsoft Excel, than by using a dedicated database system. Excel is available as a stand-alone ...

Now we will create the relationship between tables after naming the tables. On the Data tab, click Relationships in the Data Tools group. A Manage Relationships dialog box will open. In the Manage ...

Automate repetitive data entry and fix broken sorting hierarchies using Excel's powerful, hidden Custom Lists tool.