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

pivot tables

ResolvedVersion 2010

Frank has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

What advantages are there for using pivot tables over regular tables?

RE: Pivot Tables

Hi Frank, thanks for your query. Pivot Tables are incredibly powerful summarising and analysing tools. The quickest win is structural flexibility, providing the ability to generate new table structures and mathematical analyses within seconds. To do this using static tables takes far longer and is much more prone to error.

Hope this helps,

Anthony

Sun 12 Jun 2011: Automatically marked as resolved.

Excel tip:

Currency format

Ctrl+Shift+$ applies the Currency format, with two decimal places

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.13 secs.