Hello and welcome to our new video
For example, I want to remove the background or I want to
apply a filter
If I tell you, we can do all these things in Excel
I don't tell you yet
Let's see
So what to do for this?
First of all, I open Excel
And you are seeing some data
This is the same data that I used in the last video
Other than this, where will I get the picture option?
So where do you have to go?
You have to go to the Insert tab
If you go to the Insert tab
So you will get this option of pictures
And next to it you will get the option of online pictures
So let's see what happens
I found out that if we go to the Insert tab, we get the
picture option
If I click on the picture
So you see
This is showing me
Where do you want to get the picture in your file manager?
So I select that folder
You can pick it up from any folder in your folder
Pictures are lying on my desktop
I'm going to pick up the pictures from here
So what did I do?
Select the pictures
And then press the Insert button
Now this zebra has come
If you want to resize it, what do you have to do?
If you go to any corner
So you will see this arrow
Simply click on it and drag it down like this
And its size will be reduced
Now you will notice one thing
Whenever you click on a photo
There is some background behind it
But this picture that I have just inserted
There is no background behind it
So how is this?
So there are two formats of pictures
Always remember
One is PNG
There are many formats
But normally the background pictures
They have JPG or JPEG format
But whose background is transparent
What do we call it?
PNG files are called
PNG format
So the background of this photo
Which I have inserted
What will it be?
It will be transparent
And what will this picture be?
It will be PNG
Now why am I telling you this thing?
PNG or JPG
How is this going to be useful to us?
So we will see this now
Apart from this, you will notice one more thing
Look at the screen
There was no format tab yet
I inserted the picture
A tab was added to my ribbon
Which is called format tab
This format tab has a lot of features
I will tell you a little
For example, you can remove the background
Then you can do this photo
You will say that there is no background
I will insert one more picture
In which I will show you
What is the background
And how can you remove it?
Apart from this, what is this?
Some correction options have been given
Artistic effect
Some frames have been given
Styles have been given
And all the pictures
We are going to see one by one
So I insert one more picture
What will you get in it?
You will get to see the background
So what do we have to do again?
Go to the insert tab
Go to pictures
After that
Whichever picture is in your folder
You can insert from there
For example
I take this picture
Of Vicky Kaushal
I inserted
So what will be the format of this file?
It will not be PNG format
Because we know
PNG format pictures
What is the background of it?
It is transparent
It is not transparent
It is transparent
So we have selected this photo
Now we have to see
How can we remove its background?
The way this
Zebra is coming
The background is completely transparent
In the same way
The background of Vicky Kaushal
Can we make it transparent or not?
So what do you have to do?
From two pictures
I select this picture
After that I go to the
Remove background option
When I remove background
You will see that some areas
You can see some areas
What is the remaining area?
It is selected
Now what I do?
I do keep changes
So the area
I can see in pink
This area will be
Disappeared And the skin tone I can see
That area will be saved
Okay
So here
There are two options
When we apply
Remove background on any picture
It shows me three options
First option is
Mark area to keep
Mark that area
The rest will be removed
Apart from this
Mark area to remove
Or we can select that area
Delete mark
Wherever we have marked
Delete it
Discard all changes
I change anything in it
For example, I do like this
And after that
If I do discard all changes
You will see
The option of remove background
What will happen?
Discarded We have to do things again
So I go to remove background again
After that keep changes
Keep changes means
All the changes you have done
So what I do
I mark
That I want this area
So what you have to do
You have to work hard
I am not perfect in this
So it is not possible
That whole background
Comes Removed Because If we do that
You have to work hard
One by one
And it automatically select
It does not select so accurately
I show you
That By default
We take that
Remove it
Discard all changes
After that remove background
The area it is showing
We take that
So now what changes
If I do keep changes
The rest of the background
Disappeared Only this part is left
I know it is not looking good
You will say
It is not perfect
Like in zebra
The finishing is so good
But it is not there
You can say
You have to work hard
Like in one picture
Ctrl Z
Remove this picture
Remove it
Cut it
I have to bring one more picture
I go to picture option
I bring coliseum
To resize this picture
From any corner
You have to drag it down
I drag it down
Like this
Select this picture
Remove background
Let's see
By default it select which area
I remove background
If I do keep changes
The blue jersey
I can see
The rest of the area
Will be removed
What Excel is considering
Background But I want face
So what I do
I mark
From here
I marked
Then I marked from top
Then I marked
From here
You can see
Which ever area I am selecting
It is moving from pink
Ok So one by one
You have to select this area
It will take time
Definitely Ok
So what you can do
You can select this area like this
One by one
So like this
I take this much area
Where I have marked
I do keep changes
The pink color
The rest of the area
Background will be considered
And this will be removed
I do keep changes
So you have to work in detail
But it will work
Ok So this is done how to remove background so what i do we
go to insert now i have seen how to insert pictures i go to
browse from file manager i can bring any picture now we see
how to insert online pictures so when i click on online
pictures it shows me two options one drive personal one
drive is cloud picture means all your google photos by
default stored in your drive if you have backup so this one
drive is cloud service in which your photos can be stored
like saved in drive so what we
for this when you download your photos what you need to
download again you need internet connection so what is this
this option is given on online pictures other than this
Bing image search you can search any picture like i search
animal here i search animal now it will show me this
picture so i can insert any picture online for example i
select this and insert now it is so big so we know how to
make it small from these four corners like you have two
corners so from any corner you have to pull it like this so
this picture will be small
so if you want to remove background let's see how much
portion by default selects remove background so i click on
remove background now whatever area is selected it will be
gone i discard all changes after this next option let's see
after this next option is correction i click on correction
here it is written sharpen, soften, brightness or contrast
like in mobile phone i want to increase brightness so i
increase contrast so here predefined value is set
brightness, contrast and for example i
this it is sharp if i select this it is not sharp it is
blurry apart from this i select sharpen 0% apart from this
some options are given so you can select any option
according to your choice like i select this it is whitish i
select this it is blackish here it is written
brightness-40% contrast-20% so like this some values are
set like in instagram filter is set we have to apply filter
which you like here also same options are given next option
is color here you can see color saturation, color
recolor when i insert it it was in black and white but you
can select other color and give it like i select this it is
orange apart from this if i select this it is green if i
select this it is reddish so you can select any color you
want apart from this you can select color tone and color
saturation so all these options are given predefined values
you have to select those values like this i select this it
is looking good after this next option is artistic effect
if we click this here also some
are given like in mobile phone in any app many effects are
given here also predefined effects are given you can select
any effect like this many times we see some photo on
instagram if you want to blur someone's face so the effect
is applied here it is applied on whole picture apart from
this all these options are given whatever you like you can
select so now i do not do any effect after this next is
compress picture compress means if the size of the picture
is 5 MB then reduce it to 2 MB or
MB like this, so if I click on compress picture then it
shows me some options, now see here here some options are
disabled now because it is a transparent picture so it is
disabled, like we cancel it we select this picture on this
picture if we compress the picture then you will see this
option now what is this option? now let's see compression
options, apply only to this picture and delete cropped area
of the picture, if you select any area and want to crop it
you can crop it, now this is
output, HD 330 ppi good quality for high definition display
now what happens, these 4-5 options which are given to you,
why are they given? see the size of your photo can be big
or small if you don't compress it for example, there is a
10 MB picture you have to send it with mail with mail when
you send it with mail whatever you have written in word in
word means whatever message you have written suppose it is
message in KB, 400 KB, 500 KB message, but the picture you
are attaching is of 10 MB,
the size of the file will increase so what do we try? we
try that the quality of the picture loosens a little and
this happens in compress in compress, the original quality
of the picture loosens but it is not so loose that you
can't see it, so here the same options are given that if
you want to attach a photo on the web, then you can select
this option if you want to print, then you can do this if
you want to send a photo with email, then you can select
this email option so this is different
of options are given to me
I can select any of these options according to what I am
doing so it is clear, after this let's see, there is a
different option of change picture now see if you want to
change the original picture then we can do that for
example, let's browse so where will it take us? in
computer, where the picture is saved for example, let's
browse and let's bring Mr.
Kohli when I insert, the original picture is replaced so we
can do this what you can do to change the picture? for
example, how to download the original picture? you can
download and insert you can do this again for example, I
have written nature and I have entered so now you will see,
so many pictures of nature
I select any picture of nature so this picture will replace
this picture
I have inserted sorry, we could not download the picture
now it is not downloading let's download another picture
and see ok now it is not downloading any picture may be
there is some network problem
so let's cancel it but we have understood this option
before this, we have seen when we have downloaded the
online picture let me show you when you go to insert here
this is the same option we can do this let me select this
when you select any picture then you will see this option
in which you can format many things so we have understood
this change picture we can do offline all the pictures in
our device if we bring it this picture will be replaced let
me show you if I bring
Vicky Kaushal this picture will be replaced or we can do
online then go to Reset Picture what does reset picture do?
Reset Picture is if I have done any changes then it resets
all the changes in the picture ok see, I clicked on Reset
so whatever changes I did in this picture, it got reset
after that what is shown here? it shows picture styles by
selecting this so you will see different frames are getting
added for this you don't have to download any photo editing
app you don't have to download any software for photo
editing in excel, we have already got these options we have
used these options there are many
if you click here, you will see more options like this you
can select all these for example, let's select this ok
after that, let's move ahead picture's border what is
picture's border? you have to give some color to the border
this thick border you can see it is called border and what
is the color of this? it is black if I want to change this
color then I will select the same color like I want green
after that next option is picture effect what is picture
effect?
I clicked on shadow and I got many options how is it?
shadow is a shadow where do you want the shadow of this
zebra? inside this frame or outside? for example, I
selected shadow of this zebra and you can see shadow of
this zebra you can select from here you can select inside
or outside you can select like this let's go to picture
effect you can see reflection reflection is more visible
after that you can go to glow option you can see outside of
this frame how is the outline visible? you can see
color variation you can select the glow of the photo you
want you can see many glow if you go to more glow colors
you will get more glow you can select soft edges 1.2.5 you
can select all these options you can select bevel you can
select angle you can select 3D rotation you can select 3D
rotation you can select all these options after this you
can select picture layout in picture layout you can see
layout you can select on any layer you can select on image
there is a text option the rest of the
is cut by using the ctrl let's go back select it again we
understand we can select this option based on our needs if
you don't need after that bring forward and send backward
I will tell you after this there is an option of selection
pan you have two photos what you can do is layer by layer
you can do it on top of it what I did is hide bring forward
the picture which was at the back is now at the front if I
send backward the picture which was at the front is now at
the back and if I do it on picture 4 or picture 1 what I
can do from here
I will remove picture 1 from here both pictures are removed
from here which picture you want to show this eye which you
can see if you click on this eye picture 4 is now gone what
you can see now picture 1 is visible you can do some
editing on picture 1 you can do some editing on picture 1
I will close it after that let's go to format after this
you have to align the photo
I selected align top, align middle, align bottom
I selected align top, align middle, align bottom because
this picture is in 3D so we are not able to align it but if
it was straight we can align it or if I want to rotate this
picture you can rotate it you can flip it all these things
are possible first I flipped it first it was in this
direction now it is in this direction now if I want to crop
this picture you can crop it you can crop it what I have to
do
I have to crop it what I have to do
I have to crop it so you can do this so you can do this you
have other option you have other option you have other
option you have other option
you have other option you have other option
you have other option
so,this is height and width so,this is height and width so
I can set it
I will take another picture
I will edit it more
I will go to insert
I will go to pictures
I will take colis
I will resize it
We know how to resize it
Select this ladybug
Select this ladybug and drag it down and drag it down and
drag it down but it's not like we can't do it we can do
some things like removing background or resizing the
picture or resizing the picture we can do these small
things in excel we can do these small things in excel
I think that's enough for today's video
I will meet you in the next video
If you want to understand anything then play this video
again and keep practicing till then