Friday, April 29, 2011

PowerPivot Free Add-on for Excel 2010

I would like to share with you a information on Microsoft Excel Add-on (supports only 2010).

PowerPivot is a free add-on for MS Excel 2010

How it is useful?

=> helps in increasing the data analysis capability of Excel
=> Increase the data holding capacity of Excel Sheet so we can store more data in single Excel sheet.

Features:

=> We can import data from Access, SQL Server also from other data base.
=> In Normal Excel pivot allow 1millions rows and data, In PowerPivot allow to use 100 millions of rows.
=> In Normal Excel we can import data only from single data sources whereas In PowerPivot we can import data from diverse
sources and combain these data into single model.
=> Save your data and perform analysis in the familiar Excel Environment and we can copy, move & re-use the data when we needed.
=> share your analysis online where your colleagues can continue to slice and dice your data.

for more details: http://www.powerpivot.com/
Video links: http://www.powerpivot.com/videos.
Twitter Bird Gadget