Tip sheets | Glossary | Home | Contents

 

Create a pivot table

 

Level of difficulty: Advanced

As an educator, your class could have conducted a survey while on a field trip or doing a science experiment. The data is descriptive data which can be interpreted in many different ways. You have already entered data in a spreadsheet, and would like them to analyse this data in a dynamic and flexible manner by means of a pivot table in Microsoft Excel.
Click here for example

 

Create your own pivot table - one which you will find useful. Alternatively, follow this example. To do so you would typically work through the following steps:
 
Description
Resources
1 Start Excel How to Start Excel
2 Enter data: Insert the data which your class has obtained from their research. Give each column a heading, and make sure there are no blank rows or columns in between your data. How to insert data for a pivot table
3 Create a pivot table: Use your data to create a pivot table on a new sheet. How to create a pivot table
4 Select a field to count: Choose one of your variables (generated from the column headings) to count; this should be a text item, not a number. How to select a field
5 Select a first field to divide up your data. How to select a first field
6 Select a second field to divide up your data further. How to select a second field
7 Select a numeric field with which to work. How to select a numeric field
8 Create a pivot chart: Create a chart, and experiment with different kinds of chart, and dragging the fields to sgraph different fields How to create a pivot chart
9 Save the worksheet How to save a file
 

Related scenarios

Create a simple chart

Sort data in Microsoft Excel

Import a chart into Microsoft Word

   
Home | Contents