Installing PowerPivot
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:
- Click File
- Click Options
- Goto Add Ins
- Change Excel add-ins to com add ins
- Check the PowerPivot Checkbox
Now that you've installed PowerPivot you can now get started with using it. Check out the following videos:
- Building Data Models with PowerPivot
- Creating relationships in PowerPivot
- Using the calculate function in PowerPivot
You don't need exercise files for this.