Online Instruction Page
Sample Data for Excel
Related tutorials - for Practice Ideas
Named Excel Tables
VLOOKUP Function Examples
Excel Drop Down Lists
Excel Pivot Tables Intro
Excel Formulas and Functions
Notes
• SalesOrders sheet has office supply sales data for a fictional company
• Each row represents an order.
• The Total column could be changed to a formula, to multiply the Units and Cost colum
More Sample Data
Athletes Sample Data
Food Nutrients Sample Data
Food Sales Sample Data
Hockey Player Sample Data
Insurance Policies Sample Data
Work Orders Sample Data
Workplace Safety Sample Data
e Units and Cost columns.
OrderDate Region Rep Item Units Unit Cost Total
1/6/2024 East Jones Pencil 95 1.99 189.05
1/23/2024 Central Kivell Binder 50 19.99 999.50
2/9/2024 Central Jardine Pencil 36 4.99 179.64
2/26/2024 Central Gill Pen 27 19.99 539.73
3/15/2024 West Sorvino Pencil 56 2.99 167.44
4/1/2024 East Jones Binder 60 4.99 299.40
4/18/2024 Central Andrews Pencil 75 1.99 149.25
5/5/2024 Central Jardine Pencil 90 4.99 449.10
5/22/2024 West Thompson Pencil 32 1.99 63.68
6/8/2024 East Jones Binder 60 8.99 539.40
6/25/2024 Central Morgan Pencil 90 4.99 449.10
7/12/2024 East Howard Binder 29 1.99 57.71
7/29/2024 East Parent Binder 81 19.99 1619.19
8/15/2024 East Jones Pencil 35 4.99 174.65
9/1/2024 Central Smith Desk 2 125.00 250.00
9/18/2024 East Jones Pen Set 16 15.99 255.84
10/5/2024 Central Morgan Binder 28 8.99 251.72
10/22/2024 East Jones Pen 64 8.99 575.36
11/8/2024 East Parent Pen 15 19.99 299.85
11/25/2024 Central Kivell Pen Set 96 4.99 479.04
12/12/2024 Central Smith Pencil 67 1.29 86.43
12/29/2024 East Parent Pen Set 74 15.99 1183.26
1/15/2025 Central Gill Binder 46 8.99 413.54
2/1/2025 Central Smith Binder 87 15.00 1305.00
2/18/2025 East Jones Binder 4 4.99 19.96
3/7/2025 West Sorvino Binder 7 19.99 139.93
3/24/2025 Central Jardine Pen Set 50 4.99 249.50
4/10/2025 Central Andrews Pencil 66 1.99 131.34
4/27/2025 East Howard Pen 96 4.99 479.04
5/14/2025 Central Gill Pencil 53 1.29 68.37
5/31/2025 Central Gill Binder 80 8.99 719.20
6/17/2025 Central Kivell Desk 5 125.00 625.00
7/4/2025 East Jones Pen Set 62 4.99 309.38
Developed by Contextures Inc. www.contextures.com 02/18/2025
7/21/2025 Central Morgan Pen Set 55 12.49 686.95
8/7/2025 Central Kivell Pen Set 42 23.95 1005.90
8/24/2025 West Sorvino Desk 3 275.00 825.00
9/10/2025 Central Gill Pencil 7 1.29 9.03
9/27/2025 West Sorvino Pen 76 1.99 151.24
10/14/2025 West Thompson Binder 57 19.99 1139.43
10/31/2025 Central Andrews Pencil 14 1.29 18.06
11/17/2025 Central Jardine Binder 11 4.99 54.89
12/4/2025 Central Jardine Binder 94 19.99 1879.06
12/21/2025 Central Andrews Binder 28 4.99 139.72
Developed by Contextures Inc. www.contextures.com 02/18/2025
Contextures Sites & News
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog
Contextures Excel Newsletter
Excel Products
Contextures Recommends
www.contextures.com 02/18/2025
Hundreds of tutorials, tips and sample files
Excel tutorials and tips, with comments and questions
Pivot table tutorials and tips, with comments and questions
Get emails with Excel tips, links, and news
Excel tools and training, recommended by Debra
www.contextures.com 02/18/2025
