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.
For more help with using or creating pivot tables in Excel see Microsoft Excel Pivot Tables.
Back to Top
Hosted by Macquarie University on 18-20 September, this year's theme is Universities and Communities.
» Read More