PowerPivot
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
