0:01
hi and welcome back to Exel Lise on this
0:04
video we are going to teach you how to
0:06
import multiple country flags at a go
0:09
rather than having to download each flag
0:12
and importing it to your Exel sheet
0:14
therefore ensuring that you're saving a
0:17
lot of time and you get more time to do
0:20
other tasks so the first method I'm
0:23
going to show you is a normal method
0:25
that people normally do and this method
0:28
uh makes them waste time and this is
0:31
what we are trying to ask you to avoid
0:34
doing and then I will show you another
0:37
method that is easier to do so the first
0:40
one is whereby you'll you'll move to
0:45
insert insert tab under illustrations
0:48
you click on pictures place in cell and
0:53
device uh by here I mean that you you've
0:57
already done your research you've
0:59
downloaded the flags of course that are
1:02
that's tedious for you to go on Google
1:05
search for the different flags for each
1:07
country that you need and then click
1:10
insert this will take like a couple of
1:13
minutes or hours if your database is
1:16
very huge so rather than wasting your
1:19
time doing all this uh the easiest way
1:22
is to do this let me delete that so the
1:27
easiest way to do the same tasks but Now
1:33
click on the celles that have your
1:36
countries Ure that you select
1:39
all but you can actually you don't need
1:42
to select the the header column so we
1:45
will leave that out once you've you've
1:48
got that selected move to your data Tab
1:51
and then look for data types click on
1:54
the small arrow down and then choose
2:00
once you've done that a small plus sign
2:03
that says add column will appear click
2:07
it and at this time you just look for
2:10
the image and once you've clicked on the
2:13
image the respective flags for your
2:16
countries appear and then you can now
2:18
customize your sheet to your liking like
2:22
here we'll just rename this to
2:28
flag so you see it's very simple you
2:31
don't have to go to on Google to search
2:35
your for your flags and download them
2:38
and bring them here that's a tedious
2:41
process so just by data data types and
2:45
choosing your image you've done
2:47
everything that you need and you save
2:51
time thank you very much for watching
2:54
and we look forward to seeing you on the
