I’m even more in love with Microsoft 2013!
Pivot Tables have been great to display large amounts of data in a simplified layout and Microsoft Access has always been a valued program with relational tables. Excel 2013 provides relationships between ‘tables’, and with the use of the PowerPivot add-in, allows you to create Pivot Tables from multiple tables!
PowerPivot and Relationships were designed for the Excel power user who has used Excel VLookups and Pivot Tables and/or relational databases in Access but has wanted more from Excel.
Note that PowerPivot does not have to be used with Relationships, but when they are combined, they are super powerful! Also note that PowerPivot has not replaced Pivot Tables.
- Click here to learn about Relationships
- Click here to install the free PowerPivot add-in
- Click here to learn how to use PowerPivot