Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

	98.1 % recommend us
	More live stats...

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

Training information:

Pivot Tables

Resolved · Low Priority · Version 2007

Reply Mon 18 Jul 2011, 17:20Delegate Suzi said...

Suzi has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

Hi,
I have a huge worklsheet with training data of over 400 people in it which i need to sumarise in the first sheet (for those who can't be bothered to look at all the data)
All i want to select is @Country' and 'Training Completed'. The data in 'Training completed' is either 'Y' or 'N', but the data is not showing up in the table - just the headings.
Driving me mental now!

For upcoming training course dates see: Pricing & availability

Reply Tue 19 Jul 2011, 13:29Trainer Simon said...

RE: Pivot Tables

Hi Suzi,

Thank you for your question and welcome to the forum.

Did you add the Training Completed as a column heading?

This would only work if you had a value field like the number of delegates to display under Yes or No.

Try adding the Training Completed field as a second row heading after the Country.

I hope this answers your question.

Regards

Simon

Mon 25 Jul 2011: Automatically marked as resolved.

Excel articles

· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· A Blinking Good Excel Tip
· Unsupported features in Excel 2007
· Working Together Is Easier Than Ever With Excel 2010
· VBA Excel 2007

Please browse our web site to find out more about
excel training in uk and other Microsoft training courses.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips