Excel’s Data Model creates a relationship between two (or more) sets of data using a common field. In this case, the common field is Shelf Code, as shown in Figure A.

How to Data Model in Excel Spreadsheets. Enable PowerPivot Add-In. Open Excel and go to the File tab. Select Options from the menu. In the Excel Options dialog box, click on Add-Ins.

Financial Modeling Using Excel & VBA. ... Built-in functions, available from within Excel or from the Data Analysis Toolpak add-in, are a good option if you are new to financial modeling.