This video demonstrates how to add data to the Data Model in the Excel PowerPivot addin. The method shown also links the data, so that changes made in Excel automatically updates in PowerPivot.
------------------------