Search Contextures Sites
Custom Search

 

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. You can use it to create test files, and build Excel tables and pivot tables from the data.

This is sales data for an imaginary stationery company, and each row represents an order. It shows:

-- when the order was placed,

-- which region the sale was made in

-- the sales representative

-- the item sold

-- the number of units sold

-- the cost of a single unit

-- the total cost of the order

You can select all the Excel sample data in the table below, copy it, and then paste it into an Excel workbook, for use in your own tests. The Total column contains values, and you could change it to a formula, if you prefer, to multiply the Units and Cost columns.

Or, you can download the sample data in an Excel file, by clicking this link: Excel sample data workbook

OrderDate

Region

Rep

Item

Units

Cost

Total

1/6/2014

East

Jones

Pencil

95

1.99

189.05

1/23/2014

Central

Kivell

Binder

50

19.99

999.50

2/9/2014

Central

Jardine

Pencil

36

4.99

179.64

2/26/2014

Central

Gill

Pen

27

19.99

539.73

3/15/2014

West

Sorvino

Pencil

56

2.99

167.44

4/1/2014

East

Jones

Binder

60

4.99

299.40

4/18/2014

Central

Andrews

Pencil

75

1.99

149.25

5/5/2014

Central

Jardine

Pencil

90

4.99

449.10

5/22/2014

West

Thompson

Pencil

32

1.99

63.68

6/8/2014

East

Jones

Binder

60

8.99

539.40

6/25/2014

Central

Morgan

Pencil

90

4.99

449.10

7/12/2014

East

Howard

Binder

29

1.99

57.71

7/29/2014

East

Parent

Binder

81

19.99

1,619.19

8/15/2014

East

Jones

Pencil

35

4.99

174.65

9/1/2014

Central

Smith

Desk

2

125.00

250.00

9/18/2014

East

Jones

Pen Set

16

15.99

255.84

10/5/2014

Central

Morgan

Binder

28

8.99

251.72

10/22/2014

East

Jones

Pen

64

8.99

575.36

11/8/2014

East

Parent

Pen

15

19.99

299.85

11/25/2014

Central

Kivell

Pen Set

96

4.99

479.04

12/12/2014

Central

Smith

Pencil

67

1.29

86.43

12/29/2014

East

Parent

Pen Set

74

15.99

1,183.26

1/15/2015

Central

Gill

Binder

46

8.99

413.54

2/1/2015

Central

Smith

Binder

87

15.00

1,305.00

2/18/2015

East

Jones

Binder

4

4.99

19.96

3/7/2015

West

Sorvino

Binder

7

19.99

139.93

3/24/2015

Central

Jardine

Pen Set

50

4.99

249.50

4/10/2015

Central

Andrews

Pencil

66

1.99

131.34

4/27/2015

East

Howard

Pen

96

4.99

479.04

5/14/2015

Central

Gill

Pencil

53

1.29

68.37

5/31/2015

Central

Gill

Binder

80

8.99

719.20

6/17/2015

Central

Kivell

Desk

5

125.00

625.00

7/4/2015

East

Jones

Pen Set

62

4.99

309.38

7/21/2015

Central

Morgan

Pen Set

55

12.49

686.95

8/7/2015

Central

Kivell

Pen Set

42

23.95

1,005.90

8/24/2015

West

Sorvino

Desk

3

275.00

825.00

9/10/2015

Central

Gill

Pencil

7

1.29

9.03

9/27/2015

West

Sorvino

Pen

76

1.99

151.24

10/14/2015

West

Thompson

Binder

57

19.99

1,139.43

10/31/2015

Central

Andrews

Pencil

14

1.29

18.06

11/17/2015

Central

Jardine

Binder

11

4.99

54.89

12/4/2015

Central

Jardine

Binder

94

19.99

1,879.06

12/21/2015

Central

Andrews

Binder

28

4.99

139.72

 

Privacy Policy

 

Contextures Inc., Copyright 2015
All rights reserved.

 

Last updated: May 16, 2015 9:39 AM