advanced excel ms training

advanced excel ms training - Pivot charts

Resolved · Low Priority · Version Standard

Pivot charts

Richard has attended:
Excel Introduction course

by - delegate Richard [1 post] (2007 Feb 21 Wed, 15:29) Reply

I would like to know more about how to use pivot table. I work on marketing and track our various marketing activity. At the end of a marketing campaign, I would like my staff members to show the different types of activity e.g. advertising, mailing, emails, etc and then the number of people who booked a place at one of our events as a result of that activity (we can tell this from our tracking activities). I then want to enter the cost of each activity and use a Pivot table to calculate the cost per head for each bit of marketing activity that we do. Can you advise?

Kind regards

Richard

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot charts

by - trainer Orok bronze contributer [29 posts] (2007 Feb 22 Thu, 15:11) Reply

Hello Richard,

Pivot tables are a good way of analysing upto four data sets.

Your question is very involved to demonstrate simply in this forum. This is a topic we address in depth on our Excel Advanced course. I would encourage you to attend.

Please find a link to the content of the Excel Advanced course below.

http://www.microsofttraining.net/excel-training-in-london-2003-advanced.php

Regards

· Microsoft Excel Training - Numerical excellence for all
· Do You Really Need Excel VBA Training?
· Creating Charts with Excel
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

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