Behind the Scenes in PowerPivot for Excel
It has helped my clients to remember the Excel interface is primarily used to control and influence the presentation of data. Features for formatting values, as well as tasks to save, print, and share the solution, are included in the Excel interface. The existing Excel user community and the familiarity of these features to experienced spreadsheet users contribute to PowerPivot’s ease of adoption.
On the other hand, PowerPivot for Excel is a tool for integrating and manipulating large volumes of data. Nothing short of a revolution in database software would be required to create a user-friendly tool for organizing (sorting, filtering, and calculating) datasets that could contain millions of rows, using ...
Get PowerPivot for Business Intelligence Using Excel and SharePoint 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.
