Exercise File - Pivot Tables
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
OrderDateRegionRepItemUnitsUnit CostTotal
Go to File --> Make a copy to get an editable version of this spreadsheet
2
5/22/16WestThompsonPencil321.9963.68
3
3/15/16WestSorvinoPencil562.99167.44Instructions:
4
9/1/16CentralSmithDesk21252501
Select the data in cells A1-G20
5
7/29/16EastParentBinder8119.991,619.192
Create a Pivot Table (Data --> Pivot Table). This will open in a new tab.
6
11/8/16EastParentPen1519.99299.853
Under Rows, add Reps
7
6/25/16CentralMorganPencil904.99449.14
Under Columns, add Item
8
10/5/16CentralMorganBinder288.99251.725
Under Values, add Total
9
1/23/16CentralKivellBinder5019.99999.56
Under Values, change to summarize by Count
10
1/6/16EastJonesPencil951.99189.05
11
4/1/16EastJonesBinder604.99299.4
12
6/8/16EastJonesBinder608.99539.4
13
8/15/16EastJonesPencil354.99174.65
14
9/18/16EastJonesPen Set1615.99255.84
15
10/22/16EastJonesPen648.99575.36
16
2/9/16CentralJardinePencil364.99179.64
17
5/5/16CentralJardinePencil904.99449.1
18
7/12/16EastHowardBinder291.9957.71
19
2/26/16CentralGillPen2719.99539.73
20
4/18/16CentralAndrewsPencil751.99149.25
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...