Online Instruction Page

Sample Data for Excel

Related tutorials
Named Excel Tables
Data Entry Tips
More Excel Sample Files

Related Contextures Products

Contextures Excel Tools Add-in
Data Entry Popup Kit

Get weekly Excel tips, tutorials, videos, and news

Contextures Excel Newsletter

Notes
• SalesOrders sheet has sales data for a fictional company, and each row represents an order.
• The Total column could be changed to a formula, to multiply the Units and Cost columns.
sents an order.
ost columns.
 OrderDate Region Rep Item Units
1/6/19 East Jones Pencil 95
1/23/19 Central Kivell Binder 50
2/9/19 Central Jardine Pencil 36
2/26/19 Central Gill Pen 27
3/15/19 West Sorvino Pencil 56
4/1/19 East Jones Binder 60
4/18/19 Central Andrews Pencil 75
5/5/19 Central Jardine Pencil 90
5/22/19 West Thompson Pencil 32
6/8/19 East Jones Binder 60
6/25/19 Central Morgan Pencil 90
7/12/19 East Howard Binder 29
7/29/19 East Parent Binder 81
8/15/19 East Jones Pencil 35
9/1/19 Central Smith Desk 2
9/18/19 East Jones Pen Set 16
10/5/19 Central Morgan Binder 28
10/22/19 East Jones Pen 64
11/8/19 East Parent Pen 15
11/25/19 Central Kivell Pen Set 96
12/12/19 Central Smith Pencil 67
12/29/19 East Parent Pen Set 74
1/15/20 Central Gill Binder 46
2/1/20 Central Smith Binder 87
2/18/20 East Jones Binder 4
3/7/20 West Sorvino Binder 7
3/24/20 Central Jardine Pen Set 50
4/10/20 Central Andrews Pencil 66
4/27/20 East Howard Pen 96
5/14/20 Central Gill Pencil 53
5/31/20 Central Gill Binder 80
6/17/20 Central Kivell Desk 5
7/4/20 East Jones Pen Set 62
7/21/20 Central Morgan Pen Set 55
8/7/20 Central Kivell Pen Set 42
8/24/20 West Sorvino Desk 3
9/10/20 Central Gill Pencil 7
9/27/20 West Sorvino Pen 76
10/14/20 West Thompson Binder 57
10/31/20 Central Andrews Pencil 14
11/17/20 Central Jardine Binder 11
12/4/20 Central Jardine Binder 94

Developed by Contextures Inc. www.contextures.com 07/12/2021

 12/21/20 Central Andrews Binder 28

Developed by Contextures Inc. www.contextures.com 07/12/2021

mes nombre del mes Unit Cost Total
1 january 1.99 189.05
1 january 19.99 999.50
2 february 4.99 179.64
2 february 19.99 539.73
3 march 2.99 167.44
4 april 4.99 299.40
4 april 1.99 149.25
0 #N/A 4.99 449.10
5 may 1.99 63.68
6 june 8.99 539.40
6 june 4.99 449.10
7 july 1.99 57.71
7 july 19.99 1,619.19
8 august 4.99 174.65
9 september 125.00 250.00
-2 #N/A 15.99 255.84
10 october 8.99 251.72
10 october 8.99 575.36
11 november 19.99 299.85
43 #N/A 4.99 479.04
12 december 1.29 86.43
12 december 15.99 1,183.26
1 january 8.99 413.54
2 february 15.00 1,305.00
2 february 4.99 19.96
3 march 19.99 139.93
3 march 4.99 249.50
4 april 1.99 131.34
4 april 4.99 479.04
5 may 1.29 68.37
5 may 8.99 719.20
6 june 125.00 625.00
7 july 4.99 309.38
7 july 12.49 686.95
8 august 23.95 1,005.90
8 august 275.00 825.00
9 september 1.29 9.03
9 september 1.99 151.24
10 october 19.99 1,139.43
10 october 1.29 18.06
11 november 4.99 54.89
12 december 19.99 1,879.06

Developed by Contextures Inc. www.contextures.com 07/12/2021

 12 december 4.99 139.72

Developed by Contextures Inc. www.contextures.com 07/12/2021

 1 enero january
2 febrero february
3 marzo march
4 abril april
5 mayo may
6 junio june
7 julio july
8 agosto august
9 septiembreseptember
10 octubre october
11 noviembre november
12 diciembre december

1 2 3 4 5 6
enero febrero marzo abril mayo junio
january february march april may june
 7 8 9 10 11 12
julio agosto septiembreoctubre noviembre diciembre
july august september october november december
42.285

Central Gill Pencil 53 1.29

Central Gill Binder 80 8.99
Central Kivell Desk 5 125.00
East Jones Pen Set 62 4.99
Central Morgan Pen Set 55 12.49
Central Kivell Pen Set 42 23.95
West Sorvino Desk 3 275.00
Central Gill Pencil 7 1.29
West Sorvino Pen 76 1.99
West Thompson Binder 57 19.99
Central Andrews Pencil 14 1.29
january
january
february
february
march
april
april
#DIV/0!
may
june
june
july
july
august
september
#NAME?
october
october
november
#N/A
december
december
january
february
february
march
march
april
april
may
may
june
july
july
august
august
september
september
october
october
november
december
december
 Fecha
4/1/19
4/18/20
5/5/19
1 5/22/19
6/8/19
6/25/20
7/12/19
7/29/19
8/15/19
9/1/20
9/18/19
10/5/19
10/22/19
11/8/19
11/25/19
12/12/19
12/29/19
1/15/20
2/1/20
 15 7

Year Mes Día del mes Bisemana Semana

2019 4 1 1 1
2020 4 18 2 3
2019 5 5 1 1
2019 5 22 2 4
2019 6 8 1 2
2020 6 25 2 4
2019 7 12 1 2
2019 7 29 2 5
2019 8 15 1 3
2020 9 1 1 1
2019 9 18 2 3
2019 10 5 1 1
2019 10 22 2 4
2019 11 8 1 2
2019 11 25 2 4
2019 12 12 1 2
2019 12 29 2 5
2020 1 15 1 3
2020 2 1 1 1
 6 2 3

Semestre Nombre del semestre Semester Name Bimestre Trimestre

1 Primer Semestre First Semester 2 2
1 Primer Semestre First Semester 2 2
1 Primer Semestre First Semester 3 2
1 Primer Semestre First Semester 3 2
1 Primer Semestre First Semester 3 2
1 Primer Semestre First Semester 3 2
2 Segundo Semestre Second Semester 4 3
2 Segundo Semestre Second Semester 4 3
2 Segundo Semestre Second Semester 4 3
2 Segundo Semestre Second Semester 5 3
2 Segundo Semestre Second Semester 5 3
2 Segundo Semestre Second Semester 5 4
2 Segundo Semestre Second Semester 5 4
2 Segundo Semestre Second Semester 6 4
2 Segundo Semestre Second Semester 6 4
2 Segundo Semestre Second Semester 6 4
2 Segundo Semestre Second Semester 6 4
1 Primer Semestre First Semester 1 1
1 Primer Semestre First Semester 1 1
 $$$
suma
promedio
maximo
minimo
contar caracteres
4 =
medidas (*) dimensiones (*)

Cuatrimestre Región Vendedor Artículo Cantidad

1 East Jones Binder 60
1 Central Andrews Pencil 75
2 Central Jardine Pencil 90
2 West Thompson Pencil 32
2 East Jones Binder 60
2 Central Morgan Pencil 90
2 East Howard Binder 29
2 East Parent Binder 81
2 East Jones Pencil 35
3 Central Smith Desk 2
3 East Jones Pen Set 16
3 Central Morgan Binder 28
3 East Jones Pen 64
3 East Parent Pen 15
3 Central Kivell Pen Set 96
3 Central Smith Pencil 67
3 East Parent Pen Set 74
1 Central Gill Binder 46
1 Central Smith Binder 87
 0.00%
100.00%

0 0.00%
50 55.00%

Precio Monto bruto % descuento monto descuento % descuento v2

4.99 299.40 2.00 5.99 35.82%
1.99 149.25 29.00 43.28 23.40%
(484.99) 449.10 20.00 89.82 12.74%
1.99 63.68 42.00 26.75 40.20%
8.99 539.40 3.00 16.18 17.18%
4.99 449.10 34.00 152.69 17.05%
1.99 57.71 7.00 4.04 48.37%
(1,234.00) 1,619.19 15.00 242.88 21.46%
4.99 174.65 29.00 50.65 21.94%
125.00 250.00 6.00 15.00 0.98%
15.99 255.84 38.00 97.22 11.20%
8.99 251.72 9.00 22.65 10.04%
8.99 575.36 12.00 69.04 44.90%
19.99 299.85 26.00 77.96 0.04%
4.99 479.04 7.00 33.53 8.51%
1.29 86.43 32.00 27.66 10.31%
15.99 1,183.26 33.00 390.48 41.99%
8.99 413.54 31.00 128.20 34.47%
15.00 1,305.00 2.00 26.10 19.65%
monto descuento v2 estrato monto descuento v2 monto antes iv tax
107.26 Muy bueno 293.41 38.14
34.92 Medio medio 105.97 13.78
57.23 Muy bueno 359.28 46.71
25.6 Medio medio 36.93 4.80
92.68 Muy bueno 523.22 68.02
76.56 Muy bueno 296.41 38.53
27.91 Medio medio 53.67 6.98
347.54 Genial!!!! 1,376.31 178.92
38.32 Medio medio 124.00 16.12
2.46 Casi nada 235.00 30.55
28.67 Medio medio 158.62 20.62
25.27 Medio medio 229.07 29.78
258.32 Genial!!!! 506.32 65.82
0.12 Casi nada 221.89 28.85
40.79 Medio medio 445.51 57.92
8.91 Algo 58.77 7.64
496.84 Genial!!!! 792.78 103.06
142.54 Muy bueno 285.34 37.09
256.41 Genial!!!! 1,278.90 166.26
 obtenga el más grande los que son estrictamente m
4

total neto EstratoPrecio

331.56 cheap
119.74 Very cheap
405.99 Wrong
41.74 Very cheap
591.24 Half exp
334.94 cheap
60.65 Very cheap Estrato
1,555.23 Wrong Desde Hasta menos de
140.12 cheap -999999 0
265.55 really exp 0 3
179.24 Half exp 3 5
258.84 Half exp 5 8
572.14 Half exp 8 16
250.73 exp 16 50
503.42 cheap 50 200
66.41 Very cheap 200 999999
895.85 Half exp
322.44 Half exp
1,445.16 Half exp
ande los que son estrictamente menores

Nombre
Erróneo Wrong Erróneo [-00,0[
Barato Very cheapCasi nada [0,3[
Medio barato cheap Muy poco [3,5[
medio medio half half Poquito [5,8[
medio caro Half exp Algo [8,16[
cariñoso exp Medio med[0,3[
bien caro really exp Muy bueno[0,3[
carísimo very exp Genial!!!! [0,3[
 1000 9000

900 8000
listado del total de ventas por región en las columnas y por jerarquía de semestre, bimestre y mes en las
800
7000

700
Year Semester Name Data 6000

2019 600
First Semester Second Semester 5000

Total Neto
Región Sum - tax Sum - total neto Sum - tax Sum - total neto
500
Central 33.86 294.34 71.21 618.97
4000
East 92.85 807.09 479.18 4,165.17
400
West 6.79 59.01
Total Result 133.50 1,160.44 550.39 4,784.14 3000
300

2000
200

100 1000

0 0
Central East West Total Result

Axis Title
 9000
Límite de tax
45
8000
e semestre, bimestre y mes en las filas para un grupo determinado de vendedores
7000

6000

2019 Sum - tax 2019 Sum - total neto 2020

Second Semester Sum - taxFirst Semester Second Semester
5000
2020 First Semester Sum - tax
Sum - tax
Data Second Semester Sum - tax
Sum - total neto Sum - tax
105.07 Year 2019 First Semester Sum - tax 216.57
913.31 1,882.50 31.53
4000
572.03 4,972.26
Sum - total neto
Sum - total neto
6.79 59.01
Sum - total neto
683.89
3000 Semester Name5,944.58
Sum - total neto 216.57 1,882.50 31.53

2000

1000

0
West Total Result

is Title
 2020 Sum - tax 2020 Sum - total neto Total Sum - tax

Sum - total neto

274.03 248.10 2,156.52 353.17
572.03
6.79
274.03 248.10 2,156.52 931.99
Total Sum - total neto

3,069.83
4,972.26
59.01
8,101.10
 Sample Data -- Formatted Numbers
This example shows how Excel changes number formatting.

Click on the Text Box to select it Paste the numbers in the cells below
Then, select the numbers and copy them -- Some numbers will change to dates,
-- Leading zeroes will be lost.
3/4
02345
1-3

For more information:

Data Entry Tips -- How to paste formatted numbers and keep the formatting
ge to dates,
 Contextures Products
Pivot Power Premium Add-in
UserForms for Data Entry ebook Kit
Contextures Excel Tools Add-in
Data Entry Search Popup
Data Entry Popup
30 Excel Functions in 30 Days eBook Kit

Contextures Sites & News

Contextures Excel Newsletter
Contextures Excel Tips Website
Contextures Excel Blog
Excel Pivot Tables Blog

Other Excel Products

Contextures Recommends

www.contextures.com 07/12/2021
Time-saving tools for pivot table power users
Step by step instructions and videos
Make instant backups, sort sheets, and many more tools
Makes data entry easier when choosing from long list
Select single or multiple items from a listbox, to enter in a single cell
Sample workbook and easy to follow user guide for key Excel functions

Weekly Excel tips, tutorials, videos, and news

Hundreds of tutorials, tips and sample files
Read the Excel tutorials and share your comments
Pivot table tutorials and tips, with comments and questions

Other Excel tools and training, recommended by Debra

www.contextures.com 07/12/2021