PowerPivot for Excel

One sheet in Microsoft Excel has a limit of 1,048,576 rows, but you may have millions of rows of data. So what do you do now? You can download the PowerPivot plug-in from Microsoft.

PowerPivot for Excel is an add-in to Excel 2010 that is used for adding and integrating large amounts of data in Excel workbooks. The data that you add to the workbook is stored internally, as an embedded PowerPivot database inside the .xlsx file.

You can use this database in Excel or in Power View reports. In Excel, the workbook provides all of the data visualization and interaction features. Using the PivotTable reporting skills you already have, you can build sophisticated workbooks that are based on rich analytical data that you build easily in Excel.

When you install the add-in, you get the following benefits:

  • A separate application workspace used for importing, relating, enriching, and cleansing data. The workspace opens over Excel, but stores the data in the same .xlsx file that Excel uses. Within the workspace, you can build an analytical database inside Excel when you import and relate data.
  • A PowerPivot menu is added to the Excel ribbon so you can work with data in the Excel workspace.

Take a look at Microsoft’s PowerPivot page to learn even more and watch a few short video clips.

For more Microsoft Applications Training information visit www.directionstraining.com or call 1-855-575-8900.