Please help me with a second opinion asap on what you think with this data!

sam97

New Member
Joined
Aug 8, 2022
Messages
12
Platform
  1. MacOS
This project is fairly open ended, we are really just looking to see how you think through the data, what insights you can identify, and your used of excel to arrive at those insights.

450.00Kilogram5/13/2022A
4100.00Kilogram5/13/2022C
15,000.00Gram5/13/2022C
11,000.00Gram5/13/2022I
13,000.00Gram5/13/2022S
15,000.00Gram5/13/2022S
110,000.00Gram5/11/2022D
13,000.00Gram5/11/2022I
13,000.00Gram5/11/2022I
13,000.00Gram5/11/2022P
4100.00Kilogram5/10/2022B
675.00Kilogram5/10/2022I
13,000.00Gram5/10/2022P
15,000.00Gram5/10/2022P
49,000.00Kilogram5/9/2022C
1500.00Gram5/9/2022N
11,000.00Gram5/9/2022N
1500.00Gram5/9/2022R
4100.00Kilogram5/6/2022A
11,000.00Gram5/6/2022D
42,450.00Kilogram5/6/2022D
4550.00Kilogram5/6/2022D
4200.00Kilogram5/6/2022D
11,000.00Gram5/6/2022G
51,050.00Kilogram5/5/2022E
4100.00Kilogram5/5/2022L
12,000.00Gram5/3/2022D
6825.00Kilogram5/3/2022I
14,000.00Gram5/3/2022J
115,000.00Gram5/3/2022J
15,000.00Gram5/3/2022T
4225.00Kilogram5/2/2022A
110,000.00Gram5/2/2022N
41,000.00Kilogram5/2/2022N
650.00Kilogram4/29/2022I
4800.00Kilogram4/29/2022I
325.00Kilogram4/29/2022N
14,000.00Gram4/29/2022N
7125.00Kilogram4/29/2022N
7500.00Kilogram4/29/2022P
1500.00Gram4/29/2022S
1100.00Gram4/29/2022S
1300.00Gram4/29/2022S
1100.00Gram4/29/2022S
4625.00Kilogram4/27/2022E
41,825.00Kilogram4/26/2022A
4625.00Kilogram4/26/2022G
153,000.00Gram4/26/2022G
1100,000.00Gram4/25/2022C
41,050.00Kilogram4/25/2022N
450.00Kilogram4/22/2022B
425.00Kilogram4/22/2022C
425.00Kilogram4/22/2022C
450.00Kilogram4/22/2022C
425.00Kilogram4/22/2022M
1500.00Gram4/22/2022P
15,000.00Gram4/22/2022S
450.00Kilogram4/21/2022C
35.00Kilogram4/21/2022N
13,000.00Gram4/21/2022V
15,000.00Gram4/21/2022V
1200.00Gram4/20/2022F
11,000.00Gram4/20/2022F
11,000.00Gram4/20/2022N
350.00Kilogram4/20/2022N
4475.00Kilogram4/19/2022E
425.00Kilogram4/19/2022G
3275.00Kilogram4/19/2022P
425.00Kilogram4/19/2022S
425.00Kilogram4/19/2022Z
4325.00Kilogram4/18/2022B
13,000.00Gram4/18/2022E
11,000.00Gram4/18/2022R
13,000.00Gram4/18/2022W
110,000.00Gram4/14/2022B
120,000.00Gram4/14/2022B
1500.00Gram4/14/2022M
1500.00Gram4/14/2022U
4100.00Kilogram4/13/2022C
110,000.00Gram4/13/2022N
116,000.00Gram4/12/2022G
750.00Kilogram4/12/2022T
11,000.00Gram4/11/2022A
14,000.00Gram4/11/2022A
12,000.00Gram4/11/2022V
13,000.00Gram4/11/2022V
125,000.00Gram4/11/2022V
450.00Kilogram4/8/2022C
475.00Kilogram4/8/2022C
4100.00Kilogram4/8/2022D
475.00Kilogram4/8/2022D
425.00Kilogram4/8/2022D
4100.00Kilogram4/8/2022S
4350.00Kilogram4/8/2022U
1500.00Gram4/7/2022A
1500.00Gram4/7/2022A
4150.00Kilogram4/7/2022C
450.00Kilogram4/7/2022P
450.00Kilogram4/7/2022P
6100.00Kilogram4/7/2022P
1500.00Gram4/7/2022P
15,000.00Gram4/7/2022S
125,000.00Gram4/7/2022S
4325.00Kilogram4/6/2022N
7525.00Kilogram4/5/2022C
4100.00Kilogram4/5/2022D
4150.00Kilogram4/4/2022N
15,000.00Gram4/4/2022S
125,000.00Gram4/4/2022S
4125.00Kilogram4/4/2022S
12,000.00Gram4/4/2022S
110,000.00Gram4/4/2022S
42,950.00Kilogram3/31/2022C
12,000.00Gram3/31/2022L
4125.00Kilogram3/30/2022S
425.00Kilogram3/29/2022E
4175.00Kilogram3/29/2022G
750.00Kilogram3/29/2022W
12,000.00Gram3/28/2022A
15,000.00Gram3/28/2022P
475.00Kilogram3/25/2022A
6400.00Kilogram3/25/2022C
41,125.00Kilogram3/25/2022C
6200.00Kilogram3/25/2022C
410,700.00Kilogram3/25/2022C
425.00Kilogram3/25/2022D
4100.00Kilogram3/25/2022D
475.00Kilogram3/24/2022C
6775.00Kilogram3/24/2022I
4100.00Kilogram3/24/2022N
450.00Kilogram3/24/2022P
450.00Kilogram3/24/2022P
126,000.00Gram3/22/2022G
4100.00Kilogram3/22/2022L
4400.00Kilogram3/22/2022N
410,975.00Kilogram3/21/2022B
4450.00Kilogram3/21/2022S
41,600.00Kilogram3/18/2022A
11,000.00Gram3/18/2022D
4825.00Kilogram3/18/2022E
41,300.00Kilogram3/18/2022E
5750.00Kilogram3/18/2022E
4100.00Kilogram3/18/2022I
425.00Kilogram3/18/2022M
12,000.00Gram3/18/2022M
4150.00Kilogram3/18/2022N
4450.00Kilogram3/18/2022S
11,000.00Gram3/18/2022U
1300.00Gram3/17/2022A
11,000.00Gram3/17/2022A
450.00Kilogram3/17/2022C
475.00Kilogram3/17/2022C
425.00Kilogram3/16/2022C
11,000.00Gram3/14/2022D
1100.00Gram3/14/2022N
41,000.00Kilogram3/14/2022N
73,600.00Kilogram3/14/2022P
12,000.00Gram3/14/2022V
13,000.00Gram3/14/2022V
125,000.00Gram3/14/2022V
14,000.00Gram3/11/2022C
425.00Kilogram3/11/2022Z
4125.00Kilogram3/10/2022D
450.00Kilogram3/10/2022D
475.00Kilogram3/10/2022D
6200.00Kilogram3/10/2022P
5175.00Kilogram3/9/2022I
750.00Kilogram3/9/2022S
11,000.00Gram3/8/2022Z
13,000.00Gram3/7/2022A
15,000.00Gram3/7/2022A
15,000.00Gram3/7/2022P
4300.00Kilogram3/4/2022A
450.00Kilogram3/4/2022S
41,000.00Kilogram3/3/2022N
110,000.00Gram3/3/2022W
11,000.00Gram3/2/2022A
6175.00Kilogram3/2/2022I
5250.00Kilogram3/2/2022L
125,000.00Gram3/2/2022S
11,000.00Gram3/2/2022V
475.00Kilogram3/1/2022A
4125.00Kilogram3/1/2022A
1500.00Gram3/1/2022A
1500.00Gram3/1/2022A
450.00Kilogram3/1/2022B
11,000.00Gram2/28/2022D
4100.00Kilogram2/28/2022N
42,000.00Kilogram2/25/2022B
41,050.00Kilogram2/25/2022B
4200.00Kilogram2/25/2022G
7200.00Kilogram2/25/2022M
425.00Kilogram2/25/2022S
425.00Kilogram2/25/2022T
4200.00Kilogram2/24/2022A
450.00Kilogram2/24/2022C
410,000.00Kilogram2/24/2022C
120,000.00Gram2/24/2022D
11,000.00Gram2/24/2022D
4150.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
4150.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
425.00Kilogram2/24/2022D
450.00Kilogram2/24/2022Z
4150.00Kilogram2/23/2022A
425.00Kilogram2/23/2022C
425.00Kilogram2/23/2022C
410,000.00Kilogram2/23/2022C
61,375.00Kilogram2/23/2022C
4625.00Kilogram2/23/2022C
41,925.00Kilogram2/23/2022C
61,250.00Kilogram2/23/2022C
650.00Kilogram2/23/2022L
3350.00Kilogram2/23/2022P
46,000.00Kilogram2/22/2022C
4150.00Kilogram2/22/2022C
41,500.00Kilogram2/22/2022C
110,000.00Gram2/22/2022F
1100,000.00Gram2/21/2022C
12,000.00Gram2/18/2022V
475.00Kilogram2/17/2022S
1500.00Gram2/16/2022E
12,000.00Gram2/16/2022E
72,000.00Kilogram2/16/2022P
1400.00Gram2/16/2022S
1300.00Gram2/15/2022A
425.00Kilogram2/15/2022E
42,050.00Kilogram2/15/2022E
1500.00Gram2/15/2022H
175,000.00Gram2/15/2022K
1300.00Gram2/15/2022M
5125.00Kilogram2/11/2022S
4150.00Kilogram2/11/2022S
12,000.00Gram2/10/2022J
15,000.00Gram2/10/2022J
62,625.00Kilogram2/10/2022M
6250.00Kilogram2/10/2022M
4375.00Kilogram2/10/2022N
41,250.00Kilogram2/9/2022A
4325.00Kilogram2/9/2022G
725.00Kilogram2/9/2022T
1500.00Gram2/8/2022A
1500.00Gram2/8/2022A
11,000.00Gram2/8/2022C
4525.00Kilogram2/8/2022F
3225.00Kilogram2/8/2022P
15,000.00Gram2/8/2022S
125,000.00Gram2/8/2022S
4200.00Kilogram2/7/2022I
110,000.00Gram2/7/2022L
4100.00Kilogram2/7/2022P
5250.00Kilogram2/4/2022E
5125.00Kilogram2/4/2022E
64,825.00Kilogram2/3/2022I
4650.00Kilogram2/3/2022I
4175.00Kilogram2/3/2022S
4350.00Kilogram2/3/2022U
6175.00Kilogram2/3/2022Z
42,000.00Kilogram2/2/2022A
110,000.00Gram2/2/2022F
225.00Kilogram2/2/2022N
2200.00Kilogram2/2/2022N
2800.00Kilogram2/2/2022N
475.00Kilogram2/2/2022P
4200.00Kilogram2/1/2022B
4150.00Kilogram2/1/2022E
4750.00Kilogram2/1/2022I
325.00Kilogram2/1/2022P
47,300.00Kilogram1/31/2022C
42,500.00Kilogram1/31/2022C
1100,000.00Gram1/31/2022C
11,000.00Gram1/31/2022E
12,000.00Gram1/31/2022I
14,000.00Gram1/31/2022I
11,000.00Gram1/31/2022N
5200.00Kilogram1/31/2022S
4325.00Kilogram1/31/2022S
4325.00Kilogram1/31/2022S
425.00Kilogram1/28/2022C
625.00Kilogram1/28/2022G
725.00Kilogram1/28/2022G
525.00Kilogram1/28/2022G
13,000.00Gram1/28/2022H
15,000.00Gram1/28/2022P
675.00Kilogram1/27/2022S
11,000.00Gram1/27/2022S
625.00Kilogram1/27/2022T
750.00Kilogram1/27/2022W
4175.00Kilogram1/26/2022N
11,000.00Gram1/25/2022D
4350.00Kilogram1/25/2022F
425.00Kilogram1/25/2022I
4225.00Kilogram1/25/2022I
6275.00Kilogram1/25/2022I
4100.00Kilogram1/25/2022I
41,000.00Kilogram1/25/2022N
11,000.00Gram1/24/2022D
11,000.00Gram1/24/2022D
4125.00Kilogram1/24/2022D
425.00Kilogram1/24/2022D
425.00Kilogram1/24/2022D
425.00Kilogram1/24/2022D
425.00Kilogram1/24/2022D
425.00Kilogram1/24/2022D
41,400.00Kilogram1/24/2022H
425.00Kilogram1/24/2022J
35.00Kilogram1/24/2022J
11,000.00Gram1/24/2022N
4350.00Kilogram1/24/2022N
425.00Kilogram1/24/2022N
725.00Kilogram1/24/2022T
4125.00Kilogram1/24/2022U
12,000.00Gram1/21/2022F
425.00Kilogram1/21/2022G
13,000.00Gram1/21/2022P
15,000.00Gram1/21/2022S
125,000.00Gram1/21/2022S
425.00Kilogram1/21/2022Z
450.00Kilogram1/21/2022Z
4675.00Kilogram1/20/2022C
4100.00Kilogram1/20/2022C
750.00Kilogram1/20/2022N
5300.00Kilogram1/20/2022S
4725.00Kilogram1/20/2022S
4100.00Kilogram1/20/2022S
4100.00Kilogram1/19/2022B
110,000.00Gram1/19/2022N
12,000.00Gram1/18/2022A
1100,000.00Gram1/18/2022C
1100.00Gram1/18/2022N
13,000.00Gram1/14/2022S
15,000.00Gram1/14/2022S
42,000.00Kilogram1/13/2022A
110,000.00Gram1/13/2022I
4150.00Kilogram1/13/2022N
11,000.00Gram1/12/2022A
4100.00Kilogram1/12/2022B
425.00Kilogram1/12/2022C
45,275.00Kilogram1/12/2022C
42,700.00Kilogram1/12/2022C
5150.00Kilogram1/12/2022D
725.00Kilogram1/12/2022J
110,000.00Gram1/12/2022N
71,700.00Kilogram1/12/2022P
425.00Kilogram1/12/2022V
4350.00Kilogram1/11/2022M
42,400.00Kilogram1/11/2022N
5100.00Kilogram1/11/2022N
325.00Kilogram1/11/2022X
1200.00Gram1/7/2022A
1200.00Gram1/7/2022A
45,500.00Kilogram1/7/2022A
4125.00Kilogram1/7/2022G
11,000.00Gram1/7/2022V
11,000.00Gram1/7/2022V
15,000.00Gram1/6/2022A
450.00Kilogram1/6/2022C
550.00Kilogram1/6/2022G
4425.00Kilogram1/6/2022N
750.00Kilogram1/6/2022N
1200.00Gram1/5/2022C
1300.00Gram1/5/2022C
11,000.00Gram1/5/2022C
11,000.00Gram1/5/2022C
110,000.00Gram1/5/2022D
11,000.00Gram1/5/2022D
16,000.00Gram1/5/2022D
1200.00Gram1/5/2022N
7500.00Kilogram1/5/2022S
475.00Kilogram1/4/2022A
4300.00Kilogram1/4/2022F
450.00Kilogram1/4/2022M
4425.00Kilogram1/4/2022N
15,000.00Gram1/4/2022S
4500.00Kilogram1/3/2022A
42,000.00Kilogram1/3/2022A
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
The first thing i would do is convert all the measurements into the same units by adding and extra column with an equation like:
Excel Formula:
=IF(C3="Gram",B3/1000,B3)
 
Upvote 0
what are you trying to do with the data - wehat do the columns mean - how do you want to view
quite a few questions

we do not know
what insights you want
what the information is for
how you want to view

please supply some more info

otherwise
no idea what your project is all about
 
Upvote 0
what are you trying to do with the data - wehat do the columns mean - how do you want to view
quite a few questions

we do not know
what insights you want
what the information is for
how you want to view

please supply some more info

otherwise
no idea what your project is all about
thats all the information i got for my question.so I'm confused as well
 
Upvote 0
thats all the information i got for my question.so I'm confused as well
this is the direction I've gotten (This project is fairly open-ended, we are really just looking to see how you think through the data, what insights you can identify, and your used of excel to arrive at those insights. )
 
Upvote 0
is this an assignment / homework ?

dont you even get header titles
 
Upvote 0
sorry this is it
SKUQtyU Of MInvoice DateCustomer Name
4​
50.00​
Kilogram
5/13/22​
A
4​
100.00​
Kilogram
5/13/22​
C
1​
5,000.00​
Gram
5/13/22​
C
1​
1,000.00​
Gram
5/13/22​
I
1​
3,000.00​
Gram
5/13/22​
S
1​
5,000.00​
Gram
5/13/22​
S
1​
10,000.00​
Gram
5/11/22​
D
1​
3,000.00​
Gram
5/11/22​
I
1​
3,000.00​
Gram
5/11/22​
I
1​
3,000.00​
Gram
5/11/22​
P
4​
100.00​
Kilogram
5/10/22​
B
6​
75.00​
Kilogram
5/10/22​
I
1​
3,000.00​
Gram
5/10/22​
P
1​
5,000.00​
Gram
5/10/22​
P
4​
9,000.00​
Kilogram
5/9/22​
C
1​
500.00​
Gram
5/9/22​
N
1​
1,000.00​
Gram
5/9/22​
N
1​
500.00​
Gram
5/9/22​
R
4​
100.00​
Kilogram
5/6/22​
A
1​
1,000.00​
Gram
5/6/22​
D
4​
2,450.00​
Kilogram
5/6/22​
D
4​
550.00​
Kilogram
5/6/22​
D
4​
200.00​
Kilogram
5/6/22​
D
1​
1,000.00​
Gram
5/6/22​
G
5​
1,050.00​
Kilogram
5/5/22​
E
4​
100.00​
Kilogram
5/5/22​
L
1​
2,000.00​
Gram
5/3/22​
D
6​
825.00​
Kilogram
5/3/22​
I
1​
4,000.00​
Gram
5/3/22​
J
1​
15,000.00​
Gram
5/3/22​
J
1​
5,000.00​
Gram
5/3/22​
T
4​
225.00​
Kilogram
5/2/22​
A
1​
10,000.00​
Gram
5/2/22​
N
4​
1,000.00​
Kilogram
5/2/22​
N
6​
50.00​
Kilogram
4/29/22​
I
4​
800.00​
Kilogram
4/29/22​
I
3​
25.00​
Kilogram
4/29/22​
N
1​
4,000.00​
Gram
4/29/22​
N
7​
125.00​
Kilogram
4/29/22​
N
7​
500.00​
Kilogram
4/29/22​
P
1​
500.00​
Gram
4/29/22​
S
1​
100.00​
Gram
4/29/22​
S
1​
300.00​
Gram
4/29/22​
S
1​
100.00​
Gram
4/29/22​
S
4​
625.00​
Kilogram
4/27/22​
E
4​
1,825.00​
Kilogram
4/26/22​
A
4​
625.00​
Kilogram
4/26/22​
G
1​
53,000.00​
Gram
4/26/22​
G
1​
100,000.00​
Gram
4/25/22​
C
4​
1,050.00​
Kilogram
4/25/22​
N
4​
50.00​
Kilogram
4/22/22​
B
4​
25.00​
Kilogram
4/22/22​
C
4​
25.00​
Kilogram
4/22/22​
C
4​
50.00​
Kilogram
4/22/22​
C
4​
25.00​
Kilogram
4/22/22​
M
1​
500.00​
Gram
4/22/22​
P
1​
5,000.00​
Gram
4/22/22​
S
4​
50.00​
Kilogram
4/21/22​
C
3​
5.00​
Kilogram
4/21/22​
N
1​
3,000.00​
Gram
4/21/22​
V
1​
5,000.00​
Gram
4/21/22​
V
1​
200.00​
Gram
4/20/22​
F
1​
1,000.00​
Gram
4/20/22​
F
1​
1,000.00​
Gram
4/20/22​
N
3​
50.00​
Kilogram
4/20/22​
N
4​
475.00​
Kilogram
4/19/22​
E
4​
25.00​
Kilogram
4/19/22​
G
3​
275.00​
Kilogram
4/19/22​
P
4​
25.00​
Kilogram
4/19/22​
S
4​
25.00​
Kilogram
4/19/22​
Z
4​
325.00​
Kilogram
4/18/22​
B
1​
3,000.00​
Gram
4/18/22​
E
1​
1,000.00​
Gram
4/18/22​
R
1​
3,000.00​
Gram
4/18/22​
W
1​
10,000.00​
Gram
4/14/22​
B
1​
20,000.00​
Gram
4/14/22​
B
1​
500.00​
Gram
4/14/22​
M
1​
500.00​
Gram
4/14/22​
U
4​
100.00​
Kilogram
4/13/22​
C
1​
10,000.00​
Gram
4/13/22​
N
1​
16,000.00​
Gram
4/12/22​
G
7​
50.00​
Kilogram
4/12/22​
T
1​
1,000.00​
Gram
4/11/22​
A
1​
4,000.00​
Gram
4/11/22​
A
1​
2,000.00​
Gram
4/11/22​
V
1​
3,000.00​
Gram
4/11/22​
V
1​
25,000.00​
Gram
4/11/22​
V
4​
50.00​
Kilogram
4/8/22​
C
4​
75.00​
Kilogram
4/8/22​
C
4​
100.00​
Kilogram
4/8/22​
D
4​
75.00​
Kilogram
4/8/22​
D
4​
25.00​
Kilogram
4/8/22​
D
4​
100.00​
Kilogram
4/8/22​
S
4​
350.00​
Kilogram
4/8/22​
U
1​
500.00​
Gram
4/7/22​
A
1​
500.00​
Gram
4/7/22​
A
4​
150.00​
Kilogram
4/7/22​
C
4​
50.00​
Kilogram
4/7/22​
P
4​
50.00​
Kilogram
4/7/22​
P
6​
100.00​
Kilogram
4/7/22​
P
1​
500.00​
Gram
4/7/22​
P
1​
5,000.00​
Gram
4/7/22​
S
1​
25,000.00​
Gram
4/7/22​
S
4​
325.00​
Kilogram
4/6/22​
N
7​
525.00​
Kilogram
4/5/22​
C
4​
100.00​
Kilogram
4/5/22​
D
4​
150.00​
Kilogram
4/4/22​
N
1​
5,000.00​
Gram
4/4/22​
S
1​
25,000.00​
Gram
4/4/22​
S
4​
125.00​
Kilogram
4/4/22​
S
1​
2,000.00​
Gram
4/4/22​
S
1​
10,000.00​
Gram
4/4/22​
S
4​
2,950.00​
Kilogram
3/31/22​
C
1​
2,000.00​
Gram
3/31/22​
L
4​
125.00​
Kilogram
3/30/22​
S
4​
25.00​
Kilogram
3/29/22​
E
4​
175.00​
Kilogram
3/29/22​
G
7​
50.00​
Kilogram
3/29/22​
W
1​
2,000.00​
Gram
3/28/22​
A
1​
5,000.00​
Gram
3/28/22​
P
4​
75.00​
Kilogram
3/25/22​
A
6​
400.00​
Kilogram
3/25/22​
C
4​
1,125.00​
Kilogram
3/25/22​
C
6​
200.00​
Kilogram
3/25/22​
C
4​
10,700.00​
Kilogram
3/25/22​
C
4​
25.00​
Kilogram
3/25/22​
D
4​
100.00​
Kilogram
3/25/22​
D
4​
75.00​
Kilogram
3/24/22​
C
6​
775.00​
Kilogram
3/24/22​
I
4​
100.00​
Kilogram
3/24/22​
N
4​
50.00​
Kilogram
3/24/22​
P
4​
50.00​
Kilogram
3/24/22​
P
1​
26,000.00​
Gram
3/22/22​
G
4​
100.00​
Kilogram
3/22/22​
L
4​
400.00​
Kilogram
3/22/22​
N
4​
10,975.00​
Kilogram
3/21/22​
B
4​
450.00​
Kilogram
3/21/22​
S
4​
1,600.00​
Kilogram
3/18/22​
A
1​
1,000.00​
Gram
3/18/22​
D
4​
825.00​
Kilogram
3/18/22​
E
4​
1,300.00​
Kilogram
3/18/22​
E
5​
750.00​
Kilogram
3/18/22​
E
4​
100.00​
Kilogram
3/18/22​
I
4​
25.00​
Kilogram
3/18/22​
M
1​
2,000.00​
Gram
3/18/22​
M
4​
150.00​
Kilogram
3/18/22​
N
4​
450.00​
Kilogram
3/18/22​
S
1​
1,000.00​
Gram
3/18/22​
U
1​
300.00​
Gram
3/17/22​
A
1​
1,000.00​
Gram
3/17/22​
A
4​
50.00​
Kilogram
3/17/22​
C
4​
75.00​
Kilogram
3/17/22​
C
4​
25.00​
Kilogram
3/16/22​
C
1​
1,000.00​
Gram
3/14/22​
D
1​
100.00​
Gram
3/14/22​
N
4​
1,000.00​
Kilogram
3/14/22​
N
7​
3,600.00​
Kilogram
3/14/22​
P
1​
2,000.00​
Gram
3/14/22​
V
1​
3,000.00​
Gram
3/14/22​
V
1​
25,000.00​
Gram
3/14/22​
V
1​
4,000.00​
Gram
3/11/22​
C
4​
25.00​
Kilogram
3/11/22​
Z
4​
125.00​
Kilogram
3/10/22​
D
4​
50.00​
Kilogram
3/10/22​
D
4​
75.00​
Kilogram
3/10/22​
D
6​
200.00​
Kilogram
3/10/22​
P
5​
175.00​
Kilogram
3/9/22​
I
7​
50.00​
Kilogram
3/9/22​
S
1​
1,000.00​
Gram
3/8/22​
Z
1​
3,000.00​
Gram
3/7/22​
A
1​
5,000.00​
Gram
3/7/22​
A
1​
5,000.00​
Gram
3/7/22​
P
4​
300.00​
Kilogram
3/4/22​
A
4​
50.00​
Kilogram
3/4/22​
S
4​
1,000.00​
Kilogram
3/3/22​
N
1​
10,000.00​
Gram
3/3/22​
W
1​
1,000.00​
Gram
3/2/22​
A
6​
175.00​
Kilogram
3/2/22​
I
5​
250.00​
Kilogram
3/2/22​
L
1​
25,000.00​
Gram
3/2/22​
S
1​
1,000.00​
Gram
3/2/22​
V
4​
75.00​
Kilogram
3/1/22​
A
4​
125.00​
Kilogram
3/1/22​
A
1​
500.00​
Gram
3/1/22​
A
1​
500.00​
Gram
3/1/22​
A
4​
50.00​
Kilogram
3/1/22​
B
1​
1,000.00​
Gram
2/28/22​
D
4​
100.00​
Kilogram
2/28/22​
N
4​
2,000.00​
Kilogram
2/25/22​
B
4​
1,050.00​
Kilogram
2/25/22​
B
4​
200.00​
Kilogram
2/25/22​
G
7​
200.00​
Kilogram
2/25/22​
M
4​
25.00​
Kilogram
2/25/22​
S
4​
25.00​
Kilogram
2/25/22​
T
4​
200.00​
Kilogram
2/24/22​
A
4​
50.00​
Kilogram
2/24/22​
C
4​
10,000.00​
Kilogram
2/24/22​
C
1​
20,000.00​
Gram
2/24/22​
D
1​
1,000.00​
Gram
2/24/22​
D
4​
150.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
150.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
25.00​
Kilogram
2/24/22​
D
4​
50.00​
Kilogram
2/24/22​
Z
4​
150.00​
Kilogram
2/23/22​
A
4​
25.00​
Kilogram
2/23/22​
C
4​
25.00​
Kilogram
2/23/22​
C
4​
10,000.00​
Kilogram
2/23/22​
C
6​
1,375.00​
Kilogram
2/23/22​
C
4​
625.00​
Kilogram
2/23/22​
C
4​
1,925.00​
Kilogram
2/23/22​
C
6​
1,250.00​
Kilogram
2/23/22​
C
6​
50.00​
Kilogram
2/23/22​
L
3​
350.00​
Kilogram
2/23/22​
P
4​
6,000.00​
Kilogram
2/22/22​
C
4​
150.00​
Kilogram
2/22/22​
C
4​
1,500.00​
Kilogram
2/22/22​
C
1​
10,000.00​
Gram
2/22/22​
F
1​
100,000.00​
Gram
2/21/22​
C
1​
2,000.00​
Gram
2/18/22​
V
4​
75.00​
Kilogram
2/17/22​
S
1​
500.00​
Gram
2/16/22​
E
1​
2,000.00​
Gram
2/16/22​
E
7​
2,000.00​
Kilogram
2/16/22​
P
1​
400.00​
Gram
2/16/22​
S
1​
300.00​
Gram
2/15/22​
A
4​
25.00​
Kilogram
2/15/22​
E
4​
2,050.00​
Kilogram
2/15/22​
E
1​
500.00​
Gram
2/15/22​
H
1​
75,000.00​
Gram
2/15/22​
K
1​
300.00​
Gram
2/15/22​
M
5​
125.00​
Kilogram
2/11/22​
S
4​
150.00​
Kilogram
2/11/22​
S
1​
2,000.00​
Gram
2/10/22​
J
1​
5,000.00​
Gram
2/10/22​
J
6​
2,625.00​
Kilogram
2/10/22​
M
6​
250.00​
Kilogram
2/10/22​
M
4​
375.00​
Kilogram
2/10/22​
N
4​
1,250.00​
Kilogram
2/9/22​
A
4​
325.00​
Kilogram
2/9/22​
G
7​
25.00​
Kilogram
2/9/22​
T
1​
500.00​
Gram
2/8/22​
A
1​
500.00​
Gram
2/8/22​
A
1​
1,000.00​
Gram
2/8/22​
C
4​
525.00​
Kilogram
2/8/22​
F
3​
225.00​
Kilogram
2/8/22​
P
1​
5,000.00​
Gram
2/8/22​
S
1​
25,000.00​
Gram
2/8/22​
S
4​
200.00​
Kilogram
2/7/22​
I
1​
10,000.00​
Gram
2/7/22​
L
4​
100.00​
Kilogram
2/7/22​
P
5​
250.00​
Kilogram
2/4/22​
E
5​
125.00​
Kilogram
2/4/22​
E
6​
4,825.00​
Kilogram
2/3/22​
I
4​
650.00​
Kilogram
2/3/22​
I
4​
175.00​
Kilogram
2/3/22​
S
4​
350.00​
Kilogram
2/3/22​
U
6​
175.00​
Kilogram
2/3/22​
Z
4​
2,000.00​
Kilogram
2/2/22​
A
1​
10,000.00​
Gram
2/2/22​
F
2​
25.00​
Kilogram
2/2/22​
N
2​
200.00​
Kilogram
2/2/22​
N
2​
800.00​
Kilogram
2/2/22​
N
4​
75.00​
Kilogram
2/2/22​
P
4​
200.00​
Kilogram
2/1/22​
B
4​
150.00​
Kilogram
2/1/22​
E
4​
750.00​
Kilogram
2/1/22​
I
3​
25.00​
Kilogram
2/1/22​
P
4​
7,300.00​
Kilogram
1/31/22​
C
4​
2,500.00​
Kilogram
1/31/22​
C
1​
100,000.00​
Gram
1/31/22​
C
1​
1,000.00​
Gram
1/31/22​
E
1​
2,000.00​
Gram
1/31/22​
I
1​
4,000.00​
Gram
1/31/22​
I
1​
1,000.00​
Gram
1/31/22​
N
5​
200.00​
Kilogram
1/31/22​
S
4​
325.00​
Kilogram
1/31/22​
S
4​
325.00​
Kilogram
1/31/22​
S
4​
25.00​
Kilogram
1/28/22​
C
6​
25.00​
Kilogram
1/28/22​
G
7​
25.00​
Kilogram
1/28/22​
G
5​
25.00​
Kilogram
1/28/22​
G
1​
3,000.00​
Gram
1/28/22​
H
1​
5,000.00​
Gram
1/28/22​
P
6​
75.00​
Kilogram
1/27/22​
S
1​
1,000.00​
Gram
1/27/22​
S
6​
25.00​
Kilogram
1/27/22​
T
7​
50.00​
Kilogram
1/27/22​
W
4​
175.00​
Kilogram
1/26/22​
N
1​
1,000.00​
Gram
1/25/22​
D
4​
350.00​
Kilogram
1/25/22​
F
4​
25.00​
Kilogram
1/25/22​
I
4​
225.00​
Kilogram
1/25/22​
I
6​
275.00​
Kilogram
1/25/22​
I
4​
100.00​
Kilogram
1/25/22​
I
4​
1,000.00​
Kilogram
1/25/22​
N
1​
1,000.00​
Gram
1/24/22​
D
1​
1,000.00​
Gram
1/24/22​
D
4​
125.00​
Kilogram
1/24/22​
D
4​
25.00​
Kilogram
1/24/22​
D
4​
25.00​
Kilogram
1/24/22​
D
4​
25.00​
Kilogram
1/24/22​
D
4​
25.00​
Kilogram
1/24/22​
D
4​
25.00​
Kilogram
1/24/22​
D
4​
1,400.00​
Kilogram
1/24/22​
H
4​
25.00​
Kilogram
1/24/22​
J
3​
5.00​
Kilogram
1/24/22​
J
1​
1,000.00​
Gram
1/24/22​
N
4​
350.00​
Kilogram
1/24/22​
N
4​
25.00​
Kilogram
1/24/22​
N
7​
25.00​
Kilogram
1/24/22​
T
4​
125.00​
Kilogram
1/24/22​
U
1​
2,000.00​
Gram
1/21/22​
F
4​
25.00​
Kilogram
1/21/22​
G
1​
3,000.00​
Gram
1/21/22​
P
1​
5,000.00​
Gram
1/21/22​
S
1​
25,000.00​
Gram
1/21/22​
S
4​
25.00​
Kilogram
1/21/22​
Z
4​
50.00​
Kilogram
1/21/22​
Z
4​
675.00​
Kilogram
1/20/22​
C
4​
100.00​
Kilogram
1/20/22​
C
7​
50.00​
Kilogram
1/20/22​
N
5​
300.00​
Kilogram
1/20/22​
S
4​
725.00​
Kilogram
1/20/22​
S
4​
100.00​
Kilogram
1/20/22​
S
4​
100.00​
Kilogram
1/19/22​
B
1​
10,000.00​
Gram
1/19/22​
N
1​
2,000.00​
Gram
1/18/22​
A
1​
100,000.00​
Gram
1/18/22​
C
1​
100.00​
Gram
1/18/22​
N
1​
3,000.00​
Gram
1/14/22​
S
1​
5,000.00​
Gram
1/14/22​
S
4​
2,000.00​
Kilogram
1/13/22​
A
1​
10,000.00​
Gram
1/13/22​
I
4​
150.00​
Kilogram
1/13/22​
N
1​
1,000.00​
Gram
1/12/22​
A
4​
100.00​
Kilogram
1/12/22​
B
4​
25.00​
Kilogram
1/12/22​
C
4​
5,275.00​
Kilogram
1/12/22​
C
4​
2,700.00​
Kilogram
1/12/22​
C
5​
150.00​
Kilogram
1/12/22​
D
7​
25.00​
Kilogram
1/12/22​
J
1​
10,000.00​
Gram
1/12/22​
N
7​
1,700.00​
Kilogram
1/12/22​
P
4​
25.00​
Kilogram
1/12/22​
V
4​
350.00​
Kilogram
1/11/22​
M
4​
2,400.00​
Kilogram
1/11/22​
N
5​
100.00​
Kilogram
1/11/22​
N
3​
25.00​
Kilogram
1/11/22​
X
1​
200.00​
Gram
1/7/22​
A
1​
200.00​
Gram
1/7/22​
A
4​
5,500.00​
Kilogram
1/7/22​
A
4​
125.00​
Kilogram
1/7/22​
G
1​
1,000.00​
Gram
1/7/22​
V
1​
1,000.00​
Gram
1/7/22​
V
1​
5,000.00​
Gram
1/6/22​
A
4​
50.00​
Kilogram
1/6/22​
C
5​
50.00​
Kilogram
1/6/22​
G
4​
425.00​
Kilogram
1/6/22​
N
7​
50.00​
Kilogram
1/6/22​
N
1​
200.00​
Gram
1/5/22​
C
1​
300.00​
Gram
1/5/22​
C
1​
1,000.00​
Gram
1/5/22​
C
1​
1,000.00​
Gram
1/5/22​
C
1​
10,000.00​
Gram
1/5/22​
D
1​
1,000.00​
Gram
1/5/22​
D
1​
6,000.00​
Gram
1/5/22​
D
1​
200.00​
Gram
1/5/22​
N
7​
500.00​
Kilogram
1/5/22​
S
4​
75.00​
Kilogram
1/4/22​
A
4​
300.00​
Kilogram
1/4/22​
F
4​
50.00​
Kilogram
1/4/22​
M
4​
425.00​
Kilogram
1/4/22​
N
1​
5,000.00​
Gram
1/4/22​
S
4​
500.00​
Kilogram
1/3/22​
A
4​
2,000.00​
Kilogram
1/3/22​
A
 
Upvote 0
is this an assignment / homework ?

dont you even get header titles
Sales Data Project.xlsx
ABCDE
1SKUQtyU Of MInvoice DateCustomer Name
2450.00Kilogram5/13/22A
34100.00Kilogram5/13/22C
415,000.00Gram5/13/22C
511,000.00Gram5/13/22I
613,000.00Gram5/13/22S
715,000.00Gram5/13/22S
8110,000.00Gram5/11/22D
913,000.00Gram5/11/22I
1013,000.00Gram5/11/22I
1113,000.00Gram5/11/22P
124100.00Kilogram5/10/22B
13675.00Kilogram5/10/22I
1413,000.00Gram5/10/22P
1515,000.00Gram5/10/22P
1649,000.00Kilogram5/9/22C
171500.00Gram5/9/22N
1811,000.00Gram5/9/22N
191500.00Gram5/9/22R
204100.00Kilogram5/6/22A
2111,000.00Gram5/6/22D
2242,450.00Kilogram5/6/22D
234550.00Kilogram5/6/22D
244200.00Kilogram5/6/22D
2511,000.00Gram5/6/22G
2651,050.00Kilogram5/5/22E
274100.00Kilogram5/5/22L
2812,000.00Gram5/3/22D
296825.00Kilogram5/3/22I
3014,000.00Gram5/3/22J
31115,000.00Gram5/3/22J
3215,000.00Gram5/3/22T
334225.00Kilogram5/2/22A
34110,000.00Gram5/2/22N
3541,000.00Kilogram5/2/22N
36650.00Kilogram4/29/22I
374800.00Kilogram4/29/22I
38325.00Kilogram4/29/22N
3914,000.00Gram4/29/22N
407125.00Kilogram4/29/22N
417500.00Kilogram4/29/22P
421500.00Gram4/29/22S
431100.00Gram4/29/22S
441300.00Gram4/29/22S
451100.00Gram4/29/22S
464625.00Kilogram4/27/22E
4741,825.00Kilogram4/26/22A
484625.00Kilogram4/26/22G
49153,000.00Gram4/26/22G
501100,000.00Gram4/25/22C
5141,050.00Kilogram4/25/22N
52450.00Kilogram4/22/22B
53425.00Kilogram4/22/22C
54425.00Kilogram4/22/22C
55450.00Kilogram4/22/22C
56425.00Kilogram4/22/22M
571500.00Gram4/22/22P
5815,000.00Gram4/22/22S
59450.00Kilogram4/21/22C
6035.00Kilogram4/21/22N
6113,000.00Gram4/21/22V
6215,000.00Gram4/21/22V
631200.00Gram4/20/22F
6411,000.00Gram4/20/22F
6511,000.00Gram4/20/22N
66350.00Kilogram4/20/22N
674475.00Kilogram4/19/22E
68425.00Kilogram4/19/22G
693275.00Kilogram4/19/22P
70425.00Kilogram4/19/22S
71425.00Kilogram4/19/22Z
724325.00Kilogram4/18/22B
7313,000.00Gram4/18/22E
7411,000.00Gram4/18/22R
7513,000.00Gram4/18/22W
76110,000.00Gram4/14/22B
77120,000.00Gram4/14/22B
781500.00Gram4/14/22M
791500.00Gram4/14/22U
804100.00Kilogram4/13/22C
81110,000.00Gram4/13/22N
82116,000.00Gram4/12/22G
83750.00Kilogram4/12/22T
8411,000.00Gram4/11/22A
8514,000.00Gram4/11/22A
8612,000.00Gram4/11/22V
8713,000.00Gram4/11/22V
88125,000.00Gram4/11/22V
89450.00Kilogram4/8/22C
90475.00Kilogram4/8/22C
914100.00Kilogram4/8/22D
92475.00Kilogram4/8/22D
93425.00Kilogram4/8/22D
944100.00Kilogram4/8/22S
954350.00Kilogram4/8/22U
961500.00Gram4/7/22A
971500.00Gram4/7/22A
984150.00Kilogram4/7/22C
99450.00Kilogram4/7/22P
100450.00Kilogram4/7/22P
1016100.00Kilogram4/7/22P
1021500.00Gram4/7/22P
10315,000.00Gram4/7/22S
104125,000.00Gram4/7/22S
1054325.00Kilogram4/6/22N
1067525.00Kilogram4/5/22C
1074100.00Kilogram4/5/22D
1084150.00Kilogram4/4/22N
10915,000.00Gram4/4/22S
110125,000.00Gram4/4/22S
1114125.00Kilogram4/4/22S
11212,000.00Gram4/4/22S
113110,000.00Gram4/4/22S
11442,950.00Kilogram3/31/22C
11512,000.00Gram3/31/22L
1164125.00Kilogram3/30/22S
117425.00Kilogram3/29/22E
1184175.00Kilogram3/29/22G
119750.00Kilogram3/29/22W
12012,000.00Gram3/28/22A
12115,000.00Gram3/28/22P
122475.00Kilogram3/25/22A
1236400.00Kilogram3/25/22C
12441,125.00Kilogram3/25/22C
1256200.00Kilogram3/25/22C
126410,700.00Kilogram3/25/22C
127425.00Kilogram3/25/22D
1284100.00Kilogram3/25/22D
129475.00Kilogram3/24/22C
1306775.00Kilogram3/24/22I
1314100.00Kilogram3/24/22N
132450.00Kilogram3/24/22P
133450.00Kilogram3/24/22P
134126,000.00Gram3/22/22G
1354100.00Kilogram3/22/22L
1364400.00Kilogram3/22/22N
137410,975.00Kilogram3/21/22B
1384450.00Kilogram3/21/22S
13941,600.00Kilogram3/18/22A
14011,000.00Gram3/18/22D
1414825.00Kilogram3/18/22E
14241,300.00Kilogram3/18/22E
1435750.00Kilogram3/18/22E
1444100.00Kilogram3/18/22I
145425.00Kilogram3/18/22M
14612,000.00Gram3/18/22M
1474150.00Kilogram3/18/22N
1484450.00Kilogram3/18/22S
14911,000.00Gram3/18/22U
1501300.00Gram3/17/22A
15111,000.00Gram3/17/22A
152450.00Kilogram3/17/22C
153475.00Kilogram3/17/22C
154425.00Kilogram3/16/22C
15511,000.00Gram3/14/22D
Sheet
 
Upvote 0
there are loads of insights you could summarise from that info

but if homeowrk / assignment i would not list them now - also i spent years in Business MI and consultancy doing these sort of Metrics and KPIs

the idea is you learn and see it - not me , i'm retired now :) :) .... and not learning

i have listed about 12 off the top of my head

have a go - and post back

are you expected to actually do the stats - or just provide insights as a list

what would a business want to know about there sales , customer, SKU's invoices
 
Upvote 0

Forum statistics

Threads
1,221,417
Messages
6,159,789
Members
451,589
Latest member
Harold14

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top