Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel ms training - Pivot charts

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

advanced excel ms training - Pivot charts

Resolved · Low Priority · Version Standard

Reply Wed 21 Feb 2007, 15:29Delegate Richard said...

Richard has attended:
Excel Introduction course
Project Intro Intermediate course

Pivot charts

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

For upcoming training course dates see: Pricing & availability

Reply Thu 22 Feb 2007, 15:11Trainer Orok said...

RE: Pivot charts

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

Excel articles

· How To Add A Second Axis To An Excel Line Chart
· Use Hyperlinks In Excel To Make An Impact
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· How To Manage Your Everyday Spending In Excel

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips