Powerpivot

Resolved · Low Priority · Version 2007

Mon 21 May 2012, 10:50 Delegate Tom said...

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.

Mon 21 May 2012, 14:44 Trainer Anthony said...

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.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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