Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
From the author of PowerPivot Is a Home Run

PowerPivot Is a Home Run

Considering that PowerPivot solves five difficult problems, it is a home run for a version 1 product from Microsoft. Version 2 is expected to be released in early 2011 with more functionality, including support for billion-row data sets.

To recap, PowerPivot solves these issues:

  • Mashes up data from anywhere in Excel.
  • Loads more than a million rows into Excel.
  • Uses the new calculation functions offered in the DAX language to perform calculations in the grid or in a pivot table.
  • Joins data from multiple worksheets into a single pivot table without doing VLOOKUP functions.
  • New time intelligence functions handle fiscal years, parallel periods, and more.

Bill Jelen is an Excel MVP, host of MrExcel.com, and the author of 30+ books about Excel, including Pivot Table Data Crunching and PowerPivot for the Data Analyst.

  • + Share This
  • 🔖 Save To Your Account