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 » Excel Pivot Table
Excel Pivot Table
Resolved · Urgent Priority · Version 2010
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
Fri 22 Jul 2011, 11:27Trainer Anthony said...
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
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?
Fri 22 Jul 2011, 12:45Trainer Anthony said...
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.
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:Viewing Many WorksheetsIf there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds. |
