Excel 2013 – Combine PowerPivot with Relationships

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

Cheers!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s