Q: 2010/2013 new add-in: What is PowerPivot?
A: PowerPivot is a powerful data analysis tool that is available through a free Add-in for all versions of Microsoft Excel 2010 and for the Professional Plus version of Excel 2013. This tool blasts past the 1,048,576 row limit of regular Excel worksheets. It uses external data sources like SQL databases to create tables and pivot tables. Also, it allows you to cross reference two datasets based on a matching field. For example, you can pivot together Customer Information and Customer Account Data based on the shared field of Customer Number.
Read more information on PowerPivot from Microsoft.