OLAP tools in Excel 2007

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

Hi all,

Havent posted here for some months so I hope no one minds If I come back striaght away with a question.

A user on our finance team has requested access to OLAP tolls within MS Excel 2007. We are using MS Office 2007 Standard across the board. I've consulted other members of my team, but it seems that no one has any idea of OLAP tools or how to implement them. So my questions are thus;

1. Are the OLAP tools included in our licence for the Standard verssion of Office 2007? If not are they available as a download from Microsoft?

2. I am assuming that I will need to install SQL server, either on an existing server (File & Print?)

3. Would this affect any group policies already in place?

I think, what would help me greatly, as I imagine that once we have at least the inital user setup with OLAP, there will be others who will require would be a simple "how to" guide.

I would be extremely grateful for any help anyone can give me. even if it's it's just a link to helpful reading material.

Regards.

Rob.