Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

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.

Whether you've recently taken a Microsoft Excel course or you want to check that you're up-to-date with the program's latest capabilities, take the How-To Geek Advanced Excel Test and see how you fare ...