PowerPivot

image with no caption

The best is saved for last. Microsoft offers a powerful analysis tool: the free PowerPivot for Excel 2010 add-in. This add-in is based on the latest technology, allowing processing of large data groups (up to several million rows), optimized integration of data, and the ability to publish analyses on the Internet with Microsoft SharePoint 2010. The following list details PowerPivot’s advantages:

  • PowerPivot combines native Excel 2010 functions with an in-memory engine to allow users to evaluate large data groups interactively and to use the results for calculations. This is possible with the new memory management system, which uses column-oriented ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.