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

excel training class - olap

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training class - OLAP

excel training class - OLAP

ResolvedVersion Standard

Guy has attended:
Excel VBA Intro Intermediate course
Excel Advanced course

OLAP

How does this work? Is this an advanced form of Pivot Table and is there a good URL?

RE: OLAP

Hi Guy

OLAP is a Microsoft Analysis System that works in conjunction with Microsoft Server.

It allows the Excel formulas to link to multi-dimensional cells on a server, just as Excel can link to normal cells.

There are many URL's that explain and advertise programs that help and enhance the use of OLAP in Excel.

Just search for Excel OLAP

Hope this helps

Carlos

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

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.1 secs.