Pivot Tables are an incredibly powerful and useful tool in Excel. But did you know that with a new free Microsoft Extension you can power up your Pivot Tables to do even better quick summary and organisation with over a MILLION rows of data?
Here Ed and Michele from Microsoft quickly show how to create a Pivot Table using Power Pivot data:
Microsoft offers its own Power Pivot tutorials here http://technet.microsoft.com/en-us/library/gg413497.aspx There’s help on installing the extension here too in case you are having problems.
And here is a website dedicated entirely to Power Pivot http://www.powerpivotpro.com/what-is-powerpivot/ No doubt this will solve all your Power Pivot needs!
So what are you waiting for? Download PowerPivot now at http://www.microsoft.com/en-us/bi/powerpivot.aspx