Figure B shows the Customers view in Power Pivot–there’s a tab for each view. (Power Pivot refers to the data sets as views.) Figure B Add all three Table objects to Power Pivot.

Pivot tables are now functional in all current versions of Excel, whether you paid for the software or use Microsoft Office/365 for free. Step 1: Prepare your data Perhaps the most important step ...

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.