powerpivot

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Powerpivot

Powerpivot

resolvedResolved · Low Priority · Version 2007

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

Mon 28 May 2012: Automatically marked as resolved.


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.08 secs.