05/06/2015 Excel Sample Data

Search Contextures Sites
  Search
Custom Search

Home   Excel Tips   Excel Files   Products   Videos   Blog

Contact   RSS

 
Excel Sample Data
Contextures Below is a table with the Excel sample data used for many of my newsgroup and web site examples. You can use it to
Excel news create test files, and build Excel tables and pivot tables from the data.
by email

Email:

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

­­ when the order was placed,
Sign up
­­ which region the sale was made in
We respect your email
privacy
­­ 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

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
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
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
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

http://www.contextures.com/xlSampleData01.html#top 1/2
05/06/2015 Excel Sample Data
3/7/2015 West Sorvino Binder 7 19.99 139.93
Stellar Data 3/24/2015 Central Jardine Pen Set 50 4.99 249.50
Recovery 4/10/2015 Central Andrews Pencil 66 1.99 131.34
stellarinfo.co.in/Data­Re… 4/27/2015 East Howard Pen 96 4.99 479.04
100% Data Recovery 5/14/2015 Central Gill Pencil 53 1.29
@Bhubaneswar Lab No
Data­No Fee. Free 5/31/2015 Central Gill Binder 80 8.99 719.20
Consultation!
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

Excel VBA 8/24/2015 West Sorvino Desk 3 275.00 825.00

tools 9/10/2015 Central Gill Pencil 7 1.29
9/27/2015 West Sorvino Pen 76 1.99 151.24
Unltd Local 10/14/2015 West Thompson Binder 57 19.99 1,139.43
calls & Data 10/31/2015 Central Andrews Pencil 14 1.29
11/17/2015 Central Jardine Binder 11 4.99
Start
12/4/2015 Central Jardine Binder 94 19.99 1,879.06
Download
12/21/2015 Central Andrews Binder 28 4.99 139.72
Product  Top
forecasting

Home   Excel Tips   Excel Files   Products   Videos   Blog   Contact

    Contextures Inc., Copyright ©2015
All rights reserved.
Privacy Policy
 
Debra Dalgleish 

Last updated: May 16, 2015 9:39 AM

http://www.contextures.com/xlSampleData01.html#top 2/2