98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Pivot Table
Pivot Table
Resolved · Low Priority · Version 2003
Thu 19 Mar 2009, 16:45Delegate Kelvin said...
Kelvin has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Pivot Table
What is a pivot table?
Mon 30 Mar 2009, 09:38Trainer Carlos said...
RE: Pivot Table
Hi Kelvin
Pivot tables allow you to look at data in several dimensions. For example, sales by region, sales by sales rep, sales by product.
To create a Pivot table:
Select a cell in the target table
Click Data / Pivot table and Pivot chart report
Follow the steps in the Wizard
Hope this helps
Carlos
Thu 9 Apr 2009: Automatically marked as resolved.
Training information:
|
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. |
Excel tip:Hiding and unhiding columns using the keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |
