excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

Simone has attended:
Excel Intermediate course

Excel

How do I create a Pivot table?

RE: Excel

Hello Simone

Thank you for your question and welcome to the forum.

To create a PivotTable:

1. Go to Data - PivotTable and PivotChart report.
2. Follow through the three step wizard, click Finish at the final step.
3. The pivot table areas will appear on your spreadsheet. You can drag and drop fields from the PivotTable field list into the PivotTable areas.

There is a good tutorial on PivotTables available via the Microsoft web site www.microsoft.com

If you search for PivotTables 101 on the Microsoft web site, the link to the tutorial should come up for you.

Kind regards
Amanda


 

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips


Server loaded in 0.1 secs.