One of the massive benefits of PowerPivot is the possibility of creating pivot tables from multiple tables. When you have two or more tables, you are going to rely on the concept of relationships to join the tables together.
Good news: Relationships are easier to define than
VLOOKUPs are to set up.
Mildly good news: In some simple cases, PowerPivot can autodetect the relationship correctly.
Good news: If you don’t want to rely on automatic ...