Using Pivot Tables

Pivot tables are based on a database of information and are designed to be interactive as you can manipulate the data included in the table to suit your needs. Thus rather than trolling through an entire database you can select which variables you wish to look at and the pivot tables displays those variables. Pivot tables allow you to analysis numerical data and to see tends in data much more easily.

Pivot Tables can be rearranged by dragging the buttons to a new position or information can be excluded by un-ticking it in the buttons drop-down box.

Help with using pivot tables

For more help with using or creating pivot tables in Excel see Microsoft Excel Pivot Tables.