Excel

Resolved · Low Priority · Version 2003

Wed 17 Dec 2008, 09:00 Delegate liz said...

liz has attended:
Excel Intermediate course

Excel

where do i find the support info for pivot tables

Wed 17 Dec 2008, 09:25 Trainer Pete said...

RE: Excel

Hi Liz,
Thank you for your question;
In response;
Pivot Tables are covered on our Excel Advanced Course, A pivot table is a summarisation of data which can be viewed from a number of different perspectives. There are a number of books which will cover this subject, ranging from the Idiots guides to some seriously complex manuals.
If you want a quick fix the internet will return some varied levels of response to the search "Excel Pivot Tables" but you will have to look deeper for particular requirements. I hope that has helped... Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips