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

pivot tables

ResolvedVersion 2007

Tara has attended:
Excel Intermediate course

Pivot Tables

HOw do they work?

RE: Pivot Tables

Hi Tara

Creating Pivot tables is very easy in Excel. Click in your data and choose Data > Pivot tables and Pivot Chart wizard (in 2003) or choose Insert > Pivot table (2007 or 2010)

We have some useful articles on Pivot tables in our forum which you may find helpful. Take a look at the following:

https://www.stl-training.co.uk/fg-3/what-are-pivot-tables-in-excel.html

https://www.stl-training.co.uk/article-240-access-training-unleashes-power-pivot-table.html

https://www.stl-training.co.uk/article-440-preparing-pivot-why-all-excel-users-should-know-about-pivot-tables.html

I hope these are helpful - do let me know if you have any further questions.

Kind regards,
Andrew

Thu 7 Jun 2012: Automatically marked as resolved.

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

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.