Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Pivot tables
|
|
|
The UK's most regular 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 training microsoft - Pivot tables
Resolved · Low Priority · Version Standard
Reply Tue 11 Sep 2007, 16:36Delegate Neville said...
Neville has attended:
Excel Intermediate course
Excel Intermediate course
Pivot tables
how do you group individual dates into months and years?
For upcoming training course dates see: Pricing & availability
RE: pivot tables
Hi Neville
Thanks for your question.
To group dates in a pivot table:
1. Right-click the Date field button.
2. Choose Group and Show Detail, then Group
3. In the Grouping dialog box, select one or more options from the 'By' list.
To limit the dates that are grouped, you can set a Start and End date, by typing the dates in the 'Starting at' and 'Ending at' boxes
4. Click OK
I hope this helps.
Amanda
|