Activity : Pivot Table
This activity demonstrates a very simple pivot table used on a spreadsheet to analyse the total sales of a number of salesmen.

Assume a business has three salesmen - Tom, Dick and Harry. The sales they make each day are recorded on a spreadsheet.

 

[1] Create a new spreadsheet and enter the sales figures from below...

 
Salesman Date Sales Value
Tom 12/07/2009 £215.00
Harry 13/07/2009 £129.00
Tom 13/07/2009 £67.00
Dick 13/07/2009 £512.00
Tom 14/07/2009 £431.00
Dick 14/07/2009 £66.00
Harry 14/07/2009 £378.00
Harry 15/07/2009 £290.00
Tom 16/07/2009 £187.00

HINT : Copy these and paste them into a spreadsheet!
[2] You are on your own now....

 You should be able to use the Pivot Table Wizard to create the total sales for each salesman as shown below...

 
Sum of Sales Value  
Salesman Total
Dick £578.00
Harry £797.00
Tom £900.00
Grand Total £2,275.00

 
 

   Back