Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Pivot Table
|
|
|
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 Pivot Table
Resolved · Urgent Priority · Version 2010
Reply Thu 21 Jul 2011, 16:26Delegate Chantelle said...
Chantelle has attended:
Excel Advanced course
Access Introduction course
Excel Pivot Table
Hi there,
I am have looked through my notes from my course regarding pivot tables but unable to find the answer.
I am currently trying to create a table that can be manipulated to your requirements, which I thought would be a pivot table.
The table will need to read from different sheets and excel rows, to form this front sheet which can show data that is manipulated by the person.
Am I heading down the right path or do I need to look at filtering?
Thanks
Chantelle
For upcoming training course dates see: Pricing & availability
RE: Excel Pivot Table
Hi Chantelle, thanks for your query. You're on the right track but you need a "middle" table, with a series of clear field headings, that collects (or links directly to) the individual sheets and cells that you're interested in. You'd run the Pivot Table off that.
Hope this helps,
Anthony
Reply Fri 22 Jul 2011, 12:18Delegate Chantelle said...
RE: Excel Pivot Table
Thanks Anthony,
Unfortuately I am still stuck because of the nature of the file.
I am trying to display sites, against month against a catergory (which there are quite a few catergories).
Where should I start?
RE: Excel Pivot Table
Hi Chantelle. We'd need to look at the file to help you out on this one I'm afraid. The most important thing is to get the data into one main table with simple headings along the top. Once you've that, the Pivot Table functionality should allow you to summarise and analyse.
Anthony
Fri 29 Jul 2011: Automatically marked as resolved.
|