June has attended:
Excel Intermediate course
Formula example for Pivot table
Could example of Pivot table formulas be sent so that it registers how to create them
RE: Formula example for Pivot table
Hi June,
Thank you for the forum question.
A PivotTable is a very powerful tool in Excel to fast analyse many records.
On our Excel advanced course PivotTables and PivotCharts are on the course outline. We also have a course called Excel PivotTables where we work with all the options a whole day.
If you click on the link below you will find a step by step introduction to PivotTables.
https://support.office.com/en-us/article/Quick-start-Create-a-PivotTable-report-0c220f35-e478-49aa-beaf-24018b7f0f64
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best 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