Skip main navigation

An introduction to pivot tables

Get started with pivot tables - why and how.
0.2
Tips and recommendations for handling data? Learn how to use a pivot table, yeah they are magic and wonderful. Pivot tables yeah it enables you to take, a big spreadsheet of data and quickly you know, find results from it. The person who taught me pivot tables, told me ‘it will change your life’. It does change your life. Pivot tables, Excel, buy a, you don’t need to do a course on Excel, but I got a, it’s like an excel dictionary. So it was all the functions and whenever you’re trying to do something, just it takes time to learn, but if you can’t afford to hire somebody in to do it, then just having that dictionary, or you know look up on YouTube.
52.7
If you can afford to hire somebody in to do it. My advice would be spend time, to understand what data you have? What data you don’t have? Before you dive in and and understand and understand, that maybe, just having an exploratory period, where you play around with the data, to see what could be interesting, before you try and design, whatever it is you’re trying to build. Because otherwise you can rack up a lot of costs and end up with something, that doesn’t actually fit what you need.

Not all data will be presented in an online dashboard. Some data will only be available to view via download, often in a spreadsheet format. No matter how large your spreadsheet, providing it has consistent headers, a pivot table can help speed up your data analysis.

A pivot table is a summary tool, created to analyse a larger set of data. Available within spreadsheet software such as Excel for Mac or PC, or Google Sheets, this function allows you to quickly count, compare and analyse the data by selecting core attributes, such as column headers. For example, if you consistently collected customer demographic information in a spreadsheet, it would be possible to see how many tickets were sold on a particular day to each demographic characteristic listed.

Build your own pivot table activity

This is an optional activity, as it requires spreadsheet software, which you may need to purchase (Excel) or sign up to use (Google sheets). If you have acccess to the software then try using the relevant guide with the data source provided by the Office for National Statistics to build your own pivot table :

Can you answer the questions on page 2 of the guide?

This article is from the free online

Understanding Data in the Tourism Industry

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education