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 » Pivot tables
Pivot tables
Resolved · High Priority · Version 2016
Thu 31 Jan 2019, 11:41Delegate Ola said...
Ola has attended:
Excel Advanced course
Pivot tables
How do you edit pivot tables that have a set template
Thu 31 Jan 2019, 19:53Trainer Jens said...
RE: Pivot tables
Hi Ola,
Thank you for the forum question.
I am sure I understand the question.
Do you mean how to edit a PivotTable created in a template?
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 4 Feb 2019, 14:39Delegate Ola said...
RE: Pivot tables
What I mean is once you have configured a pivot table and loaded it how can you create a formla or add totals to the columns and rows?
We have a system where I have to create reports based on the existing preloaded templates.
Mon 4 Feb 2019, 15:16Trainer Jens said...
RE: Pivot tables
Hi Ola,
Click inside the Pivot Table and click on the Design tab under Pivot Table Tools. From the Layout group you can add subtotals and grand totals.
You you want to write formulas click the Analyze tab, click Fields Items & sets insert calculated field.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 11 Feb 2019: 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:How to Remove Duplication's from a selection of data in an Excel 2010 WorksheetIt would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:- |
