microsoft+excel+training+london - excel training

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training+london - Excel training

microsoft+excel+training+london - Excel training

resolvedResolved · Low Priority · Version Standard

Jaclyn has attended:
Excel Advanced course

Excel training

How do I create a pivot table?

RE: Excel training

Hi Jaclyn

Thank you for your question.

To create a pivot table, first ensure that all the data you wish to include in the pivot table is continuous, i.e. there are no whole blank rows or columns within the data area that you want to create the pivot table from.

Then:
1. Select a cell in the data area.
2. Go to Data - PivotTable and PivotChart report.
3. Follow through the Wizard.
4. You will now have a pivottable area and a pivottable field list showing on your screen. To add a field to the pivot table, select it with your mouse from the pivottable field list and drag it into the pivot table area where you want it positioned. The only real rule of thumb is that numerical values should go into the Data Items area.

To remove an item from the pivot table area, select the grey box representing the field in the pivot table area and drag it with your mouse outside of the pivot table area.

I hope this helps.
Amanda


 

Excel tip:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

View all Excel hints and tips


Server loaded in 0.08 secs.