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.