98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
RE: Excel
Hello Simone
Thank you for your question and welcome to the forum.
To create a PivotTable:
1. Go to Data - PivotTable and PivotChart report.
2. Follow through the three step wizard, click Finish at the final step.
3. The pivot table areas will appear on your spreadsheet. You can drag and drop fields from the PivotTable field list into the PivotTable areas.
There is a good tutorial on PivotTables available via the Microsoft web site www.microsoft.com
If you search for PivotTables 101 on the Microsoft web site, the link to the tutorial should come up for you.
Kind regards
Amanda
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. |
Excel tip:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |