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


resolvedResolved · Low Priority · Version 2007

Tom has attended:
Excel VBA Intro Intermediate course
Excel Pivot Tables course



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.


RE: powerpivot

Hi Tom, thanks for your query. The link to download Powerpivot is here:


Alas, you will encounter problems trying to run it in 2007. However, you can download a trial version of 2010 here:


...and here is some information about alternative data mining tools:


Hope this helps,


Hope this helps,


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.