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

powerpivot

ResolvedVersion 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:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.