OK.
So before we start let's take a look at our demographic file this time on it a file can be downloaded
in the course the sorts of available in this particular lecture I will highlight for this you download
this file and practice along as we move forward.
So in this file you will see that we have the right idea for our program through a name for it.
As for you retail price.
And then there are two columns one for recyclable and one for low fat let me explain two things to you.
So as to you specifically.
Different for each different product available in the same bit.
So for example if we have one book which which is available in five different sizes worth as you will
be different for each of them.
So to some sort of unique identifier for a different type of war.
And then the two columns that we have one is recyclable.
In this column you will see that either we have ones these ones indicate yes these words are recyclable.
And will we have blends these indicate not that new products are not recyclable and same thing goes
for low fat so before we start.
One thing that we need to do with our Deca is that we need to make these ones and antidote to yes or
no.
So we have to replace these ones with Yes and these blanks did not one be a thing that is going to eat
so particularly and doing it one by one you know.
But it could be taking a lot of time.
So rather I would have to find some technique where I can replace the all the ones in the third to go
on PBS.
And before I move to that technique that we would use to to move them back to one.
And now to replace all the ones in this particular column I will click on on here on the slip all the
column and I will go to home now click on finance select and I'll click to replace the subpoenas it
is asking what I want to replace.
So I want to replace one find one and then replace it with a guess and replace what you will see then
all the one in this vertical column have been replaced by a yes and the same thing goes again replace
find what nothing it means find land and replace them but no click on replace all and you will feel
that all of these blanks have not been replaced by now.
So it is a pretty good technique to replace your data with something else.
Quick on on Cape please point this wedding video for two seconds and do the same thing for on this column
for a look back to replace all the ones with.
Yes.
And with all the blanks with all your time starts now OK.
Welcome back.
And the select this column here and now let's do the same thing.
Find and select by the way you can go to the finance select dialog both by simply pressing control F
then cool up and it could open the same dialog box for you.
Just click on replace your analysis say replace one with the yes replace all or has been replaced.
And now I will say that replace zero with no and you will see that there is no view copy it's blank
but no.
And you will see that all the blends have not been replaced by the No.
Perfect.
So now you can apply this technique to the computer.
So you will see done.
What I will do next is that I would completely replace one word in the compute sheet now.
And the thing that I want to I'm going to repeat is blue the word blue with green.
So click here to select the complete file.
Now click on control F again I will press can pull up again on my keyboard.
I'll click on replace another thread.
I will say the place blue with the green so before I click on the place.
Take a look here you will see blues Europe and blues in the circular column.
I will click on the place all and you will see that all of these blues have been replaced with green
in your both columns.
So that is a beautiful way of replacing data in excel file.
So before I move forward other pictures show you one more technique and that is legacy we have to find
something in this company.
That's the file dissatisfied fight as you would if I can show you at the bottom.
We have things that's the one that was in this particular file so I need to find the word Milt.
How it just goes.
You're an alcoholic on this finance fine or you can just press control F on your keyboard throw open
the same that box now say find the work find Mel here now click on buy next you will see it is highlighting
the column I'll highlight the cell value refined the word milk again again again again again so you
can quickly find anything in your Excel file just by this find function so you can use the board find
and find in the place I really hope that was helpful.