Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Advanced
|
|
|
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 Advanced
Resolved · Medium Priority · Version 2003
Reply Fri 16 Jan 2009, 17:16Delegate Stefania said...
Stefania has attended:
Excel Introduction course
Outlook Advanced course
Outlook Introduction course
Excel Intermediate course
Excel Advanced course
Word Introduction course
Word Intermediate course
Word Advanced course
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
Dreamweaver Introduction (2 days) course
Excel Advanced
Hi,
I would like to know how to to link a Pivot table filtering from month to month with different data entered each month.
Thank you in advance for your help
Stefania
For upcoming training course dates see: Pricing & availability
RE: Excel Advanced
Dear Stefania
Thank you for attending various courses with us!! I hope you enjoyed the courses and benefited from them.
Please refer to the uploaded Excel file where I have created a Pivot table.
I believe you have done Excel Advanced course with us on 10 Dec 2008 and hope that you are comfortable in creating Pivot tables.
What you will notice on my spreadsheet is the dates are appearing as Months.
I dragged the Month Field that contains the date on the Row header area. Then I right-clicked on the field and then chose Group...
In the grouping dialog box I chose Months (You can choose quarters if you want).
Once I saw my dates arranged in Months I dragged it in the Drop Page field here section so that I could filter them from month to month.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Attached files...
pivot tables.xlsReply Tue 10 Feb 2009, 18:22Delegate Stefania said...
RE: Excel Advanced
Hi Rajeev,
I have just looked at your suggestion and I understand it really well now.
It is very clever to do the grouping for the month from dates in the row field and then tranfer to page field.
Thank you once again very much
Stefania
|