Tom has attended:
Excel VBA Intro Intermediate course
Excel Pivot Tables course
Powerpivot
Hi,
We discussed the option of using powerpivot to pivot large data sets. Would it be possible to have a link to the add-in please? Also, at the office we have 2007, so is this add-in supported by this version of excel? At the course, it was suggested that it would be.
Thanks,
Tom.
RE: powerpivot
Hi Tom, thanks for your query. The link to download Powerpivot is here:
http://www.microsoft.com/en-us/bi/powerpivot.aspx
Alas, you will encounter problems trying to run it in 2007. However, you can download a trial version of 2010 here:
http://chandoo.org/wp/2010/01/08/powerpivot-review/
...and here is some information about alternative data mining tools:
http://sqlblog.com/blogs/marco_russo/archive/2010/06/30/vizubi-the-first-competitor-of-powerpivot.aspx
Hope this helps,
Anthony
Hope this helps,
Anthony