O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required