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

excel

ResolvedVersion 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:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.