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
The 2018 DASSH Conference was in Canberra, ACT from 12 to 14 September.
» Read More
‘Experts? Who needs ‘em?’ Promoting the Value of Expertise in Decision-Making in Australia’s Future. 12 September 2018
The inaugural Social Sciences week is a series of Australia-wide events from 10 to 16 September 2018.
DASSH has prepared briefing papers following the Australian and New Zealand Governments' 2018-19 Budgets.
DASSH has published the "HASS Engagement and Impact" collection at the Analysis & Policy Observatory.