How To Use Relationships In PivotTables In Excel

Hiere is how you can create a single PivotTable with data from multiple tables without the use of PowerPivot!

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.


What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , ,

2 Responses to How To Use Relationships In PivotTables In Excel

  1. rmitnick June 18, 2015 at 12:03 pm #

    As always, this is a great tip. Is this only for Excel 2013? I tried it on my 2010 and didn’t find an option to add the data to the data model.

Leave a Reply