98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel training microsoft - Pivot Tables
excel training microsoft - Pivot Tables
Resolved · Low Priority · Version Standard
Matthew has attended:
Excel Intermediate course
Pivot Tables
The issue I have with pivot tables is that it is difficult knowing what data goes where
RE: Pivot Tables
Hi Matthew
Thank you for your question, and apologies for the delay in response.
The whole idea of the pivot table is that it gives you numerous choices in how you choose to display your data. Really there are no 'rules' on where items go in the pivot table area, apart from numerical values should go into the data items area.
I hope this helps.
Amanda
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:Quickly copy a formula across sheetsSuppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets. |