title: Excel Data Model without using PowerPivot
body: <p>I have a question about the "Data Model" in excel. Whenever I read about this function, it is used with PowerPivot.</p>
  
  <p>I ask because I would like to do something like this:</p>
  
  <p>I have <strong>table A</strong>:</p>
  
  <ul>
  <li>ID</li>
  <li>info1</li>
  </ul>
  
  <p>And <strong>table B</strong>:</p>
  
  <ul>
  <li>ID</li>
  <li>info2</li>
  </ul>
  
  <p>Now if I connect these tables with with the data model function (through the ID-Column), I thought that I could then join tableB.info2 to <code>tableA</code> and have a table that shows <code>ID,info1,info2</code></p>
  
  <p>But that doesn't seem to be possible, or is it possible and I'm doing something wrong?</p>
  
  <p>Is there ANYTHING you can do with datamodels without using PowerPivot? I feel like I'm missing the point of this feature.</p>