Search Contextures Sites

 

Contextures
Excel news
by email

 

 

 

Excel Sample Data

Below is a table with the Excel sample data used for many of my newsgroup and web site examples.

It's sales data for an imaginary stationery company, and shows when the order was placed, which region the sale was made in, the sales representative, the item sold and the number of units sold. It also shows the cost of a single unit, and calculates the total cost of the order.

You can select the Excel sample data in the table below, and copy it for use in your own tests. Or download the sample data in an Excel file, by clicking the link below. If you need a larger set of sample data, check out JP's Random Data Generator

Download the zipped Excel sample data workbook

For an interactive view of the data, click the button below. You can filter, sort, and download the data from the interactive view.

NOTE: The button works in Firefox and Chrome, but might not appear in Internet Explorer.

<===Click this button to open the Interactive View

OrderDate
Region Rep Item
Units
Cost
Total
1/6/2012
East Jones Pencil
95
1.99
189.05
1/23/2012
Central Kivell Binder
50
19.99
999.50
2/9/2012
Central Jardine Pencil
36
4.99
179.64
2/26/2012
Central Gill Pen
27
19.99
539.73
3/15/2012
West Sorvino Pencil
56
2.99
167.44
4/1/2012
East Jones Binder
60
4.99
299.40
4/18/2012
Central Andrews Pencil
75
1.99
149.25
5/5/2012
Central Jardine Pencil
90
4.99
449.10
5/22/2012
West Thompson Pencil
32
1.99
63.68
6/8/2012
East Jones Binder
60
8.99
539.40
6/25/2012
Central Morgan Pencil
90
4.99
449.10
7/12/2012
East Howard Binder
29
1.99
57.71
7/29/2012
East Parent Binder
81
19.99
1,619.19
8/15/2012
East Jones Pencil
35
4.99
174.65
9/1/2012
Central Smith Desk
2
125.00
250.00
9/18/2012
East Jones Pen Set
16
15.99
255.84
10/5/2012
Central Morgan Binder
28
8.99
251.72
10/22/2012
East Jones Pen
64
8.99
575.36
11/8/2012
East Parent Pen
15
19.99
299.85
11/25/2012
Central Kivell Pen Set
96
4.99
479.04
12/12/2012
Central Smith Pencil
67
1.29
86.43
12/29/2012
East Parent Pen Set
74
15.99
1,183.26
1/15/2013
Central Gill Binder
46
8.99
413.54
2/1/2013
Central Smith Binder
87
15.00
1,305.00
2/18/2013
East Jones Binder
4
4.99
19.96
3/7/2013
West Sorvino Binder
7
19.99
139.93
3/24/2013
Central Jardine Pen Set
50
4.99
249.50
4/10/2013
Central Andrews Pencil
66
1.99
131.34
4/27/2013
East Howard Pen
96
4.99
479.04
5/14/2013
Central Gill Pencil
53
1.29
68.37
5/31/2013
Central Gill Binder
80
8.99
719.20
6/17/2013
Central Kivell Desk
5
125.00
625.00
7/4/2013
East Jones Pen Set
62
4.99
309.38
7/21/2013
Central Morgan Pen Set
55
12.49
686.95
8/7/2013
Central Kivell Pen Set
42
23.95
1,005.90
8/24/2013
West Sorvino Desk
3
275.00
825.00
9/10/2013
Central Gill Pencil
7
1.29
9.03
9/27/2013
West Sorvino Pen
76
1.99
151.24
10/14/2013
West Thompson Binder
57
19.99
1,139.43
10/31/2013
Central Andrews Pencil
14
1.29
18.06
11/17/2013
Central Jardine Binder
11
4.99
54.89
12/4/2013
Central Jardine Binder
94
19.99
1,879.06
12/21/2013
Central Andrews Binder
28
4.99
139.72

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.

 

Last updated: July 30, 2013 9:08 AM