O'Reilly logo

PowerPivot for Advanced Reporting and Dashboards by Robert Bosco J

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

Chapter 1. Principles and Installing PowerPivot

The PowerPivot add-in was developed for Microsoft Excel 2010 and supports its later versions. It does not support Microsoft Excel 2007, but in Microsoft Excel 2007, a user can only open the workbook since they are created in the .xlsx format. In Microsoft Excel 2007 users can only do Excel-level changes to the worksheet, such as change the color, font, and styles, but cannot interact with PivotTables and PivotCharts. When users upgrade PowerPivot, they can use the workbooks created in the previous versions but the opposite is not possible.

This chapter will cover the following topics:

  • The principle of PowerPivot for Excel
  • The benefits of using PowerPivot
  • Installing PowerPivot
  • Verification of the installation ...

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