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.

Visual Basic for Applications can make helpful items such as links appear on screen. You can open an external spreadsheet by clicking a link in an Excel spreadsheet. For instance, you might add an ...