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 Training and help » financial excel course london - Excel advanced
financial excel course london - Excel advanced
Resolved · Low Priority · Version Standard
Wed 16 Jan 2008, 09:40Delegate Rifat said...
Rifat has attended:
Excel Advanced course
Excel Intermediate course
Excel advanced
how do you create pivot tables?
Fri 25 Jan 2008, 19:25Trainer Katie said...
RE: Create a Pivot Table
Dear Rifat,
Thanks for your question.
The following steps will help you in creating a pivot table:
- 1. Locate the data source table first
2. Click any cell within the data table
3. From the DATA menu
4. Click PivotTable & PivotChart Report
5. Press NEXT, Confirm Data region, Press NEXT again.
6. Choose either generating the table on a new sheet or on the same sheet
7.click on FINISH
Hope this helps.
Regards,
Katie
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:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |
