What is Excel’s new PowerPivot feature? — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

What is Excel’s new PowerPivot feature?

Get PDF file

by on
in Excel Training,Office Technology

Q: 2010/2013 new add-in: What is PowerPivot?

A: PowerPivot is a powerful data analysis tool that is available through a free Add-in for all versions of Microsoft Excel 2010 and for the Pro­­fessional Plus version of Excel 2013. This tool blasts past the 1,048,576 row limit of regular Excel worksheets. It uses external data sources like SQL databases to create tables and pivot tables. Also, it allows you to cross reference two datasets based on a matching field. For example, you can pivot together Customer Information and Customer Account Data based on the shared field of Customer Number.

Read more information on PowerPivot from Microsoft.

Leave a Comment

 

Previous post:

Next post: