Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training london - Pivot table
microsoft excel training london - Pivot table
Resolved · Low Priority · Version Standard
Holly has attended:
Excel Intermediate course
Pivot table
please can you tell me how to create a pivot table and why are they used?
For upcoming training course dates see: Pricing & availability
RE: pivot table
Hi Holly,
1. Enter the data you require for the Pivot table.
2. Select any cell within that data range
3. Then click Data > Pivot Table and Chart Reports
4. Follow all the steps of the wizard
5. Drag the fields you want to see onto the pivot table from the field list.
Pivot tables can be a more efficient way to view data
Hope that helps and enjoy your training
Tracy
|
