microsoft-excel-courses - pivot table
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 » microsoft-excel-courses - Pivot Table

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.

microsoft-excel-courses - Pivot Table

resolvedResolved · Low Priority · Version Standard

replyReply Fri 18 Jan 2008, 10:04Delegate Merline said...

Merline has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Pivot Table

How do I create a pivot table?

For upcoming training course dates see: Pricing & availability

replyReply Mon 21 Jan 2008, 15:24Trainer Katie said...

RE: Pivot Table

Dear Merline,

Thank you for your question.

In order to build PIVOT TABLES, you will need to locate the data source table first:

  1. Click anywhere within your data table
  2. From the DATA menu > click PivotTable & PivotChart Report
  3. Press NEXT, Confirm Data region, Press NEXT again.
  4. Choose either generating the table on a new sheet or on the same sheet
  5. click on FINISH


See if this helps.

Regards,

Katie

 

Excel articles

· Share And Share Alike - Use Excel To Collaborate As A Winning Team!
· Prepare for your MOS Certification with MS Excel Courses
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Using The Drawing Toolbar In Excel
· How To Create A Data Table In Excel 2010

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

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