{"id":676,"date":"2015-02-17T20:32:29","date_gmt":"2015-02-17T20:32:29","guid":{"rendered":"https:\/\/onthinktanks.org\/?post_type=resource&p=676"},"modified":"2016-01-06T18:34:03","modified_gmt":"2016-01-06T18:34:03","slug":"ttdatavis-how-to-series-how-to-summarise-data-with-pivot-tables-in-excel","status":"publish","type":"resource","link":"https:\/\/onthinktanks.org\/resource\/ttdatavis-how-to-series-how-to-summarise-data-with-pivot-tables-in-excel\/","title":{"rendered":"TTDATAVIS how to series: How to\u2026 summarise data with Pivot Tables in Excel"},"content":{"rendered":"
\n
\n

In a previous how to video, we learned\u00a0how to clean and tidy data in Excel using functions like VLOOKUP<\/a>. In this how to, we will look at how to summarise that data to answer specific questions using the PivotTable utility in Excel.<\/p>\n

In that previous how to, we were working with a set of data released by the UK government on all flights taken by staff of the UK Department for International Development in 2011. The original\u00a0data released under a Freedom of Information request<\/a>\u00a0didn\u2019t have the results in a very standard (and therefore, useful) format. But we tidied them by linking the data to an international standard for airport codes, IATA. By linking those two datasets, we now have information about what countries were flown to as well as exact geographic latitude and longitude for the airports. The\u00a0tidied spreadsheet is available as a Google Spreadsheet for download<\/a>.<\/p>\n

Now that we have the raw data, we might have a number of questions, like:<\/p>\n