pivot tables

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

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

Pivot tables

resolvedResolved · Medium Priority · Version 2007

Nick has attended:
Excel Intermediate course
Excel Advanced course

Pivot tables

How do you do pivot tables?

RE: Pivot tables

Hello Nick,

Hope you enjoyed your Microsoft Intermediate course with Best STL.

Thank you for your question regarding the creation of Pivot Tables. I notice that you are going to do the Advanced course at the end of this month when this topic will be fully covered.

There is a lot of information to include in a topic such as this which can be found when exploring excel help. I suggest that you go to the help section of excel and post the following question into the search box:

Create a pivot table

Then view all the topics that are covered, and by the time you go to the training course you will then get some practical experience on how to create a pivot table.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Tue 25 Jan 2011: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

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


Server loaded in 0.09 secs.