Hello and welcome to our new video. In this video we are
going to learn how to maintain stock.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
In this video we are going to learn how to maintain stock
in excel.
I am trying to do this.
If we have bought pen tab then it will tell us by sum
If we have not bought it then it will tell us by zero
After that, the last thing is the next parameter or
argument is sum range
So what to do for sum range
Select it all
I have told you this range and I have entered
Now notice one thing that what came here zero came purchase
Now check here if we bought pen tab and brought it
It was in our list that we have to bring but we have not
brought
So what is shown here, zero
Can I drag it like this
Let's see
Here I have dragged it like this
So these items are 12, 20, 0
As it is
Now you will see here
Some items are like speaker
So we bought speaker here 10 but it did not show
Now why it did not show because we did not lock the range
So you always remember
We should always lock the range
Whenever we are going to another product
Like this one
Or third
So what will happen
If our range
If it is locked
Then it will be beneficial
When we go to the next tab
When we go to the next product
When we go to accessories
Then it will be beneficial
We will not show the wrong output
As it is shown here
So let's delete it
And in the formula of zero
We lock this range
Like E9 to E19
F9 to F19
We will not do N9
Because when we go to next
Like I will go here to see the HDD data
So this is changing
Product accessories are changing
Other things are not changing
So here we will lock it
To lock the range
To lock the simple range
Let's press F4
Like I selected this
And then I pressed F4
From keyboard $E$9$E$19 We will not do this
N9 Now we will do F9
F9 to F19
I selected this
After selecting this
I pressed F4
Now I pressed enter
Now it is showing 0
It is showing 0
But the outcome will be correct
Drag it down
Now look at the speaker
Is it 10 or not?
Now the same thing is
I purchased this
And I put it in the stock
But now
I have to sell this product
So to sell
Suppose I sell it on 15th 15th April 2023 I will copy and
paste
From here
That we are doing this product on the same date
As I
On 15th
I sold 7 items
And the name of the accessories
Now look at the name of the accessories
Like this drop down list
If this drop down list
Is not made
Then you have to select it again
Now I made it
That's why you can see
You have to go to the data tab
Go to data validation
As we made it here
Go to data validation
As it is here
You have to select the list
Select the source
I will remove it
The item you have purchased
You have to select this item
After selecting this
You have to come back here
And click on OK
Now the way I was showing you in the purchase
I will show you here
Suppose A person came to me
I sold him a power brick
I had 5 minutes
I sold him 3
Went down
A person came
He asked me for a mouse
I sold him 2 pieces of mouse
A person came to me
He asked me for a hard disk
He took 12 hard disks
Now a person came again
He asked me for a hard disk
He took 12 hard disks
I had to say
Sorry, I do not have
After that
A person came
He bought me a ring light
He bought 2 pieces of ring lights
I sold him a keyboard
I sold him 3 pieces of keyboard
At last
I sold him
A mouse so this is our 15th date in which we have sold
these things, now what we have to do is we have to maintain
this in the stock, so what we have to do to maintain in the
stock, the same sum if formula, we do not have to do
anything here and there, we have put equals here, put sum
if, double click it and then it is asking me what will we
take in the range, we will take in the range the things
which we have sold, these things, so what we have to do is,
we have selected the whole range from
after that what we have to do is criteria, in criteria we
have put pen tap and after that what we have to do is sum
range, all the dates which we have sold in sum range, we
will put that, then we have closed the bracket and entered
it, now see it is showing 0, now if you have not bought pen
tap, then how will you sell, that is why it is showing 0,
now if I drag it down, remember no, first what we have to
do is, we have to lock the range, so what we have to do to
lock the range, here we go to
bar and the things which are going to change, like n9 will
change every time when we go down, so leaving this, all the
other things will be locked, so the same things are going
to be done from j9 to j15, I have selected and after that
what I have done is, I have selected and after that I have
pressed F4, now you can see on the screen that dollar has
come, now from dollar we can confirm that our range is
locked, same thing what we have to do is, from k9 to k15, I
have selected from k9 to k15 and
that I have pressed F4 and now see, now I enter from here
and now if I drag, then now there is no problem
at all, now you can see that from 12 hard disks only 12
have been sold, from 5 power bricks only 3 have been sold,
from 30 earbuds only 2 have been sold, very good business
is going on, from 30 keyboards only 3 have been sold, from
10 speakers not a single one has been sold, so this may be
the data of 15th, that means after the month is over, we
can check the stock, whether we have things left or not, or
you can check the stock daily
even, now the last column is the stock column, now what we
have to do in this, we have to find out that all the things
we bought, we have sold some of them, so I have to find out
that now we have some products left in the stock or not,
suppose take the example of hard disk, how many hard disks
did I bring here, I brought 12, 12 sold, so I should know
whether this thing is in stock or not, or as soon as the
customer comes, I can check
in the stock that brother is not there, otherwise what will
happen, if I do not maintain the stock, then I will not
know what product I have, what product is not there, so
what are we going to do in the stock, now there is a very
simple way to remove the stock, that remove the sale from
the purchase, so what are we going to do, put an equal sign
and select my cell here, minus this cell from it and I did
enter, see 0 came, now this is going to come 0, now you
will ask in this, do we lock the
no, no need to lock the range, we are simply reducing
things, so what will we do down here, we will drag it up to
here and it came to us that see, I bought it in 30, I sold
it for 2 months, 28, the example of hard disk, see I bought
it for 12 months, I sold it for 12 months, how many are
left, 0 are left, so you understood that now I have this
stock, now any customer
will come, so I can tell you by looking at it, like someone
came to me and asked for pen tap, I will say 0, you just
have to look at the stock, you do not have to look at the
purchase sale, someone came to ask for SHD, I will refuse
that we do not have it, so this column is very useful for
you, it is very important, so I hope you understood how you
can maintain the stock in excel, you can make it better
than this, it is not that I made it, it is visible, it is
visible, it is a little good, but
can make it better, so if you still have any doubts in this
video, then play this video again and see and I will meet
you in the next video.