pivot tables
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Recommend training98.1 %
recommend us
More live stats...

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

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

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.

Pivot Tables

resolvedResolved · Low Priority · Version 2007

replyReply Wed 14 Dec 2011, 16:51Delegate Sandy said...

Sandy has attended:
Excel Introduction course
Word Introduction course
Powerpoint Introduction course
Excel Intermediate course

Pivot Tables

How do I set up a Pivot Table

For upcoming training course dates see: Pricing & availability

replyReply Fri 16 Dec 2011, 16:10Trainer Andrew said...

RE: Pivot Tables

Hi Sandy

Thank you for your question - the process to create a pivot table is very fast in 2007. Click within your table of data then from the Insert Ribbon choose Pivot Table. From the dialogue box that appears make sure the range of cells highlighted by Excel is correct then click OK.

Excel creates a tab with a pivot table based on your data. Use the grid on the right side of your sheet to drag your data fields into the Row/Column/Value areas to analyse your data.

I hope this helps - do let me know if you have any further questions.

Kind regards,
Andrew

 

Excel articles

· Create Buttons To Navigate Between Worksheets
· How To Use The New Excel Web App
· Identifying Suitable Candidates For VBA For Excel Training
· Tap the Power of Recorded Macros with MS Excel Courses
· How To Ensure You Always Make A Complete Data Recovery

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

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy