You need to connect to another database and draw information from it. PowerPivot will enable you to do this and do it fast. The ability of being able to connect to multiple data sources and create relationships between them will give you an advantage and allow you to do calculations that were difficult and time consuming to do previously.
Note that this won't work with Excel 365. Now that you know that try the following:
Now that you've installed PowerPivot you can now get started with using it. Check out the following videos:
You don't need exercise files for this.