Forum home » Delegate support and help forum » Microsoft Excel Training and help » pivot tables
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
pivot tables
Resolved · High Priority · Version 2003
Reply Mon 15 Feb 2010, 16:40Delegate Jason said...
Jason has attended:
Excel Intermediate course
Word Intermediate course
Powerpoint Introduction course
Project Intro Intermediate course
pivot tables
How do you use/create a pivot table?
For upcoming training course dates see: Pricing & availability
RE: pivot tables
Hi Jason
Thanks for your question
The following is the best procedure
1. Select a cell in the source data
2. Go to Data Pivot Table and Pivot chart report
3. Select MS Excel List and Pivot Table at step 1, click next
4. Confirm that the wizard has selected the correct range (step 2)
5. Choose to place the pivot in an existing or new sheet(step 3)
6. You now have the pivot table design sheet. Simply drag the required fields into the table to create your required pivot table.
It is a good idea to have a clear understanding of hwta you are trying to achieve before you build your pivot table
Regards
Stephen
Tue 23 Feb 2010: Automatically marked as resolved.
|