Using Excel’s Data Model feature, ... The example data sets have been converted already, but you might need to know how to do this. Fortunately, it’s easy: Click anywhere inside the data set.

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.

It also stands to reason that it could augment, rather than replace, some tasks in finance, accounting, and other data-intensive fields. For example, the model introduces a "Chain of Spreadsheet ...