background top icon
background center wave icon
background filled rhombus icon
background two lines icon
background stroke rhombus icon
header logo icon

Download "EXCEL - Conception Tableau de Bord avec Design (Module #2)"

input logo icon
Cover of audio
Please wait. We're preparing links for easy ad-free video watching and downloading.
console placeholder icon
Previous video: Excel - Gestionnaire des Commandes/Livraison et Suivi de StockNext video: 100 Exercices sur Excel : Exo53
Similar videos from our catalog
|

Similar videos from our catalog

Video tags
|

Video tags

Bureautique
Excel
Pack Office
Word
Access
Powerpoint
Power Pivot
Power Query
BI Desktop
tableau de bord
excel tableau de bord
tableau de bord excel
excel segment
bureautique informatique
tuto excel
bureautique excel
excel 2016
formation excel
cours excel
bureautique cours
tuto excel avancé
cours excel 2016 complet en francais
tuto excel complet
créer un tableau de bord sur excel
créer un tableau de bord rh sur excel
bureautique avancée
Subtitles
|

Subtitles

subtitles menu arrow
  • ruRussian
Download
00:00:00
or everyone and welcome to this
00:00:02
new video so today follows
00:00:04
module
00:00:07
1 that I did so here we are going to start
00:00:09
the u2 mode so I recall the principle
00:00:12
is to build a dashboard
00:00:13
with a little bit of design so I
00:00:15
already made you a first video which
00:00:19
presented a dashboard with a little
00:00:21
bit of design so the follow-up to your
00:00:23
request you wanted to know how to
00:00:25
build it so I had already made
00:00:27
a first video so these modules are
00:00:29
now we are going move on to
00:00:31
module 2 and do the continuation of this
00:00:33
construction of dashboards
00:00:34
perhaps then so we had already
00:00:37
started well we had left I
00:00:38
recall a source where we had here
00:00:41
the sources of comada of commands of the
00:00:43
tour this basic sales with here so
00:00:46
some small calculations small
00:00:49
pivot tables okay ki moon
00:00:51
allowed us to do some small
00:00:53
traffic rosé lamic there some small
00:00:55
measurements indicator
00:00:57
is there so we are now going to
00:01:00
continue well so we had almost
00:01:02
finalized the first the first
00:01:03
dashboard so we're going to check them we're going to make
00:01:05
several sheets and we're going to see them
00:01:08
how how to manage all that come on
00:01:10
so we're going we're almost ready what we
00:01:14
had already finished the first part so
00:01:16
we're going to start now
00:01:17
so I want that the dashboards are
00:01:20
more or less dynamic I remind you so we are
00:01:21
going to duplicate a sheet we can
00:01:23
duplicate the sheets control calf
00:01:24
is supported tighten the two
00:01:26
sheets okay and then you push
00:01:29
and it will automatically
00:01:31
click the tob hockey here we has the
00:01:35
second dashboard
00:01:36
which does exactly the same thing as the
00:01:38
first except that we are going to
00:01:41
give it another name we are going to call it
00:01:43
commercial dashboard for example
00:01:48
what we had planned here general terminals table
00:01:50
commercial dashboard and
00:01:53
to tell him what we know about this end
00:01:55
so here we started from the
00:01:56
dashboard sheet we are going to go to the sheet or
00:01:58
commercial here we are going to
00:02:00
select the small white area
00:02:01
that we saw the whole of last time
00:02:04
okay quickly only the zone where
00:02:07
the age we what we want is to recover
00:02:10
the age zone
00:02:15
by having these
00:02:18
camps controlled against itself
00:02:23
and we are going to recover it to put it
00:02:26
next to here control will
00:02:29
therefore that this
00:02:32
could include well we'll see
00:02:36
delete it when it no longer has to
00:02:38
be there
00:02:39
okay so we're going to ask it to
00:02:42
delete or how do you know this piece
00:02:43
there here it is we're going to put it in white
00:02:48
okay we did it on purpose
00:02:52
and he
00:02:55
agrees
00:02:58
well we're going to step back is
00:03:00
so form
00:03:02
ok we're going to step back and move back so we
00:03:07
can step back in naples humble and so
00:03:08
we're not going to see it appear so we're going
00:03:10
vinci here it is we can see it clearly
00:03:12
so the view that we put in the same
00:03:14
color as the one who has it so we're not going to
00:03:16
see it on the other hand here the commercial
00:03:18
okay we're going to have the cgi lifted on the other hand we
00:03:21
want it now for the link that we
00:03:23
knew this sheet removed to the north
00:03:26
like that we are going to leave try two
00:03:31
dashboards and we are going to go here alone
00:03:34
the commissioner ok everything without the people
00:03:41
we also have our our our label
00:03:43
so obviously here we are going to change a
00:03:45
little little this the
00:03:49
commercial dashboard we are going to try to present
00:03:52
things a little bit different but
00:03:53
here we just changed a few small
00:03:56
little little traffic so down here the
00:03:58
graph we agree we are not going to
00:04:01
put this one there
00:04:02
ok
00:04:06
so here we could resume if the
00:04:08
graph is there and the master here
00:04:10
whatever here we are going to raise the top
00:04:14
the top 5 when we are going to create one here we are going to
00:04:20
create
00:04:21
bleeding which will pilot
00:04:25
here you will put selection but here it is by
00:04:29
and then we will
00:04:32
send back m
00:04:34
bleeding have not regio by
00:04:36
commercial and all that so we will
00:04:39
try here to create his hands
00:04:41
here we will
00:04:45
we will try well here here to remove
00:04:48
some small small objects that we do
00:04:50
not need
00:04:52
we will this one if the number of orders
00:04:55
it we are going to take it but
00:04:57
drag it here
00:04:59
even be able to change a little bit a
00:05:01
little bit these voices there try
00:05:03
to optimize the space
00:05:04
it could change a little bit all
00:05:07
that after once again they can
00:05:09
have the different heads you have
00:05:13
your dashboards then you just
00:05:15
have to design and imagine what
00:05:18
you want to see on your table
00:05:20
okay we're going to take six tries it's 4
00:05:23
these three pieces
00:05:25
we're going to tell it to go from ti forn
00:05:28
aligned to us for the master same level
00:05:31
and distributes horizontally to
00:05:34
put them in the same place here we are going to do
00:05:36
we are going to take the small bleeding here
00:05:38
like at 10 and there like that we will be able
00:05:39
here filtered on May 6
00:05:43
but calendar period of okay so there
00:05:47
it's a little too long so like here the
00:05:48
downstream segment m on
00:05:53
6 like that we will have
00:05:56
the possibility here to
00:05:58
go and see but only here
00:06:03
we are obviously going to resize it a
00:06:05
little bit just so that we can be
00:06:07
able to 'one and the same screen
00:06:10
ok
00:06:18
we're going to try to take here this little
00:06:20
john blake will that we had created the
00:06:23
voice him the month to do a little
00:06:26
check c we're going to put it the itie
00:06:29
control v that's how we're going to be able to
00:06:32
take this white area here and we
00:06:36
are going to put it under there so that it is
00:06:37
a little more present and it is not
00:06:41
like that
00:06:43
we put it at the same level as the other
00:06:45
here it was worth telling him to move it back
00:06:49
okay
00:06:54
and then we will be able to take
00:06:56
the feedback on it a little
00:07:00
like that we will go and see
00:07:02
and here we can change the color we
00:07:05
can give it the color we want
00:07:06
full burgundy ok ok to get better
00:07:09
since by pressing the calendars in
00:07:10
them we are going to go the lifting we are going
00:07:13
to put rather bad drawings now
00:07:15
a little bit particular
00:07:18
here so
00:07:20
120 the lifting we see the masters
00:07:23
below by commercial there that we are going to
00:07:26
take it that that of the worst ones are going to mount it
00:07:30
here by example here a
00:07:34
megaphone gets back to taking the same level
00:07:40
of agreement have earned it ashes
00:07:45
here and then we are going to put it to the
00:07:47
end and we are going to try to create a small
00:07:50
dashboard we kill it present my
00:07:52
salespeople
00:07:55
ok from from there we will be able to
00:07:58
create a teaching which will be driven by
00:08:00
salespeople so we will go into our
00:08:01
calculation that we had created the okay we
00:08:05
will take the eu for example
00:08:06
analysis of cross tables the liked
00:08:09
list of fields we will look here for the
00:08:13
salespeople who are right in this way
00:08:15
teaching like it goes to have a
00:08:17
commercial park and we are also going to have one
00:08:20
per region so we are going to put ourselves on the side of
00:08:23
the regions which right adds a diagram
00:08:27
like that we will have one of our hands per
00:08:30
region
00:08:32
okay
00:08:33
so that's it we're going to be able to also
00:08:37
transform them a little bit we're going to
00:08:38
put them on one knee didn't know how to come out
00:08:40
also bleeding yellow okay
00:08:45
to properly select the hands we're going to
00:08:48
change the year property of colors
00:08:49
the yellows we're going to take the two
00:08:52
hiccups control
00:09:15
here transfer of shares we
00:09:17
are going to put this on two
00:09:24
hockey columns like that I have all my list of
00:09:27
my salespeople we are going to bring up the little
00:09:29
box here here are the regions the same
00:09:37
we are going to put them in the same the same
00:09:40
size so the little shape which is
00:09:42
there we can shrink it so we will
00:09:45
save a little space with here up
00:09:48
to be able to also enlarge our
00:09:49
graph place attane wait if we
00:09:51
can have slightly larger graphs
00:09:55
here so here we will be able to
00:09:57
select in the soul and annecy game
00:09:59
which really skis on them there is not
00:10:00
much and which works okay
00:10:03
so here already in iron which right
00:10:05
parameters of segma mass that me the
00:10:08
data is a body element we are going to
00:10:10
do the same thing for sales people
00:10:11
right click
00:10:13
by ahmed hossam to hide the elements
00:10:16
in saint denis ok so I don't know if we
00:10:19
had done it over the months but if we
00:10:20
ignore right by amel of his death that's
00:10:23
already done since we have made a copy and paste of time but
00:10:26
this pilot segment must
00:10:29
leave but only them during by
00:10:32
my two hands which right collect
00:10:34
report and we are going to tell him down here
00:10:36
you should pilot all the decided
00:10:39
that we have in our sheet of calculation
00:10:41
I do ok
00:10:43
I will do the same thing for him
00:10:45
connection the report of agreement and the ama
00:10:49
of the link between pilots you you you you you
00:10:51
you
00:10:53
so the mistress if I do to harry if
00:10:57
we have the figures of everyone no
00:10:59
period here we have them all here it's going it's
00:11:02
not going to be able to manage your entire
00:11:04
career
00:11:05
come on we're going to try to
00:11:08
create now a small table
00:11:12
by commercial steps
00:11:15
going to go up a little bit that put him on the
00:11:18
same level as the 'other
00:11:19
suddenly him to put it a little
00:11:21
bigger so that it is more or less
00:11:24
fair okay we are already going
00:11:26
to save a little bit
00:11:28
so here for municipalities and
00:11:31
small indicators since its good very
00:11:33
good this is how it works
00:11:36
directly having 18 so flew for
00:11:39
that so for that
00:11:42
we are going to have to create a little
00:11:44
bit of labels too
00:11:46
so we are going to create small
00:11:49
little labels so we see inserted
00:11:52
data icon precisely
00:12:01
06 65 you are all fed up with
00:12:03
images free the right edges that
00:12:05
you can use that Microsoft offers you
00:12:07
where we have here vineyards of
00:12:08
people here so here we have we have
00:12:11
some thumbnails of people we have
00:12:13
plans we have here we have different people
00:12:16
whatever you will be able to try
00:12:18
recover a few a few
00:12:22
people then to him recovered their
00:12:26
their head whatever you will be able to
00:12:29
recover
00:12:30
there a few
00:12:35
few people
00:12:37
so well here
00:12:42
it is so here you therefore have the
00:12:45
possibility of being able to recover images
00:12:47
then you also have here a little matter
00:12:50
your countries if m no one was going to
00:12:55
be able to recover the DNA of the
00:12:59
profits of people it doesn't matter but there
00:13:02
you have them here automatically in
00:13:04
the
00:13:06
ten people come on so example if I
00:13:11
go here I will hang here we will be able to
00:13:13
go and squeeze one
00:13:16
no less than give me back little face of
00:13:19
people no matter
00:13:21
who we're going to take them from him
00:13:25
we're going to learn like him we're going to
00:13:29
take them from him we're going to take them
00:13:33
perhaps also young women women
00:13:37
they for example there are
00:13:40
others in the list obviously
00:13:42
you would have understood go we take them from
00:13:45
the east we went to take from the east see them
00:13:48
already inserted that
00:13:53
and we are going to go towards a little bit of the
00:13:55
towers and all that
00:13:59
so
00:14:02
I think that the images they all have a
00:14:04
series here is down
00:14:07
so we see in Valais we are going to try to
00:14:10
take all of this and we are going to see them
00:14:12
here how here but recover it comes
00:14:15
necessary so for that we are going to put
00:14:16
tools of shape
00:14:20
okay we are going to try to take a
00:14:23
small circle no matter come on we are going to
00:14:25
make
00:14:29
a put skull to keep the real
00:14:32
circle that said if the feet like this
00:14:39
now like this we will be able here
00:14:41
then in the scene tools
00:14:47
and to go to image format
00:14:51
put back and the shape
00:14:54
we will tell it to come back on the shape
00:14:57
the circle
00:15:00
how the city six months if to
00:15:03
do it ensures that this shape there
00:15:13
ok
00:15:14
then we will take the image
00:15:18
cropped
00:15:22
in relation to the end
00:15:51
it will crop the image
00:15:54
in relation to the height of the shape
00:15:57
so here we're just going
00:15:59
to learn 7.7 this circus here we're going to reduce
00:16:04
okay
00:16:06
we're going to do it roughly about a
00:16:09
circle
00:16:11
we're going to make it a 5 5
00:16:13
out of 5
00:16:18
we're going to make it a draw
00:16:25
and we're going to take it long
00:16:32
we
00:16:33
can get used to it a little bit
00:16:35
more,
00:16:39
we're going to tell him that ronnie is happy
00:16:42
with the guard that the form is good there
00:16:44
we're going to do it also the same so here we
00:16:46
're going to tell him
00:16:48
raw format neither in relation to the form
00:16:54
is
00:16:59
Okay
00:17:05
the effect is also what it needs
00:17:20
I understood principle I'm not going to
00:17:23
do it again every time but hop
00:17:27
1
00:17:32
and then sent in pissed off so we already have
00:17:34
two little faces so we're going to
00:17:36
take this person there we will also
00:17:39
trim
00:17:40
from the shape
00:17:44
again
00:17:52
and we will make them a dad is also
00:17:54
our little
00:18:02
easy trim to make a little bit of a circle
00:18:12
and then the audi car
00:18:20
it is the same thing to trim
00:18:24
from the liszt shape
00:18:29
we will tell him deny
00:18:34
grab the trimming tool the little
00:18:38
wrists
00:18:50
at orly
00:18:52
when we will be able to learn how to place
00:19:01
our commercials
00:19:04
I think we come from below and we have 1
00:19:06
2 3 4 5 6 7 8 8 so we still have
00:19:11
four in common moreover
00:19:14
laly cropping of ronnie from the
00:19:17
shape
00:19:18
of agreement but here we are going to take them
00:19:21
the same there also the little handle which is going
00:19:24
well pop can go we tried to
00:19:27
crop a little bit all that
00:19:32
we are going to slide the image a little bit in the
00:19:34
middle
00:19:35
like that take that
00:19:43
why why a circle and sent
00:19:48
that went here's one more
00:19:52
and we're going to do also
00:19:56
so I don't know how many sir
00:19:58
even lorna
00:20:00
m23
00:20:09
and we're going to do
00:20:11
ronnie
00:20:13
from the form
00:20:17
of agreement
00:20:19
and we will also take care of him only keep
00:20:23
there
00:20:25
that the village we know to put six months
00:20:30
that same time there we are going to go down and
00:20:35
try to recover
00:20:38
no this morning pope in the middle we are going to
00:20:43
cut back here it is now there and we
00:20:46
still have nothing going take this face also
00:20:48
cropped by the form
00:20:52
of agreement and we will tell him even if you
00:20:55
start talking to who for marnie
00:20:57
indirectly
00:21:01
of employment point you could have done
00:21:04
that we can more quickly
00:21:06
but no once again
00:21:17
we have placed the image
00:21:20
and we our lives
00:21:26
go so these characters many
00:21:28
months a little bit have them
00:21:30
agree
00:21:32
but as long as it is our salespeople
00:21:35
we have perhaps that we could last a
00:21:37
little bit
00:21:47
then she also months maybe be what
00:21:50
to reduce a
00:22:03
little we are going to place them almost all entered
00:22:05
in 2 3 4 5 6 7 1 2 3 4 6 7
00:22:13
8 even at
00:22:16
2.478 so a farm still m then I
00:22:19
can commit at the time of
00:22:21
the kind so I think that must
00:22:23
maybe we were missing sir
00:22:26
come on we're going to insert so we're
00:22:29
missing some we might still have had so
00:22:31
we're going to try gathered towards an icon of
00:22:34
character type
00:22:38
and we're going to look in the characters
00:22:40
we'll come back maybe even that I have not
00:22:41
yet done a
00:22:45
relaunch
00:22:48
so often the same people who
00:22:50
come
00:22:52
come on we're going to go and take this I think we
00:22:55
haven't taken it I don't think
00:23:04
it's less trying to see where
00:23:06
the mine is but if it has a little bit
00:23:10
lower
00:23:12
go so here we are going to
00:23:16
take the first image formats with
00:23:20
the form
00:23:21
in time
00:23:23
and we are going to go there
00:23:27
free or the part that it was a
00:23:30
gentleman who we
00:23:32
therefore needed shots because sir that 'it was
00:23:35
therefore necessary to know her a year
00:23:36
earlier nikon of clips
00:23:41
people vignettes and we are going to try it
00:23:45
I don't have like the heavens we are going to take I do
00:23:48
n't know who
00:23:50
likes to learn him for example
00:23:52
the nacion
00:23:55
I understand that the gentleman we went
00:24:01
we didn't succeed
00:24:04
come on so here we are going to go
00:24:07
from a cropped image format
00:24:10
from a shape
00:24:16
was going to take huilin
00:24:22
what we only need to
00:24:24
recover there is I have took a blow to the
00:24:27
face also putting it in the center is a
00:24:29
little bit here and we end like that
00:24:33
normally real name character go
00:24:36
here
00:24:38
here a little bit tighten them up
00:24:40
the versions little or not to reduce them a
00:24:43
little bit
00:24:56
come on now we're going to try to
00:24:58
put small little pieces of information here
00:25:00
since the salespeople are green we
00:25:02
will try to put small
00:25:03
green shapes to try to also put
00:25:05
indicators as we did here
00:25:06
here we could take eight in
00:25:09
iron who control these
00:25:12
controls so we will
00:25:17
and that we are going to put it in glass
00:25:22
in glass that we had put the same color
00:25:25
as there like that it makes a little reminder
00:25:27
of the little numbers
00:25:30
we are going to also take this little
00:25:32
label to check these
00:25:35
controls
00:25:38
so here we are going to row your understand
00:25:40
it is not me maria
00:25:47
again we're going to do it m
00:25:51
well I'll take your first names lé
00:25:54
maria
00:25:59
maria neira but
00:26:03
then we're going to put it maybe not
00:26:05
as serious
00:26:07
we're going to put it a caliber y
00:26:16
a little darker so it shows a
00:26:18
little more
00:26:20
and let's say that it is another
00:26:22
commercial
00:26:29
the soul is a little more with here are without
00:26:32
numbers so here we will have to
00:26:33
search for each one
00:26:35
okay
00:26:42
and we will see them here how we can
00:26:44
recover them to go and search
00:26:46
in each of these sources so we will
00:26:48
see them here what do we need
00:26:50
to go and recover
00:26:51
the
00:26:54
the po
00:26:55
here is
00:26:58
the information directly
00:27:01
like that it will also allow us the
00:27:03
weight to recover no our non-
00:27:06
commercial information in relation to their
00:27:08
percentage in relation to to their
00:27:11
sales value also so well we are going to go and
00:27:15
prepare my race
00:27:18
here our calculation of indicators so we
00:27:22
had created here our our tcd
00:27:28
so we are going to have here how we can
00:27:31
recover all our salespeople and
00:27:34
recover the information then if I
00:27:36
I don't want all my salespeople to move
00:27:37
with the tcd so they are about to take and
00:27:40
if this little table
00:27:41
agrees we do a little check
00:27:45
against
00:27:47
HIV there it becomes a source
00:27:50
directly
00:27:56
aclan
00:28:00
and if I want to retrieve here the information of
00:28:03
each one corresponding docly if we are going to
00:28:05
be rigal month do a little
00:28:08
research v the search will so we will
00:28:11
look for this value there
00:28:13
from what from another table
00:28:18
here we will freeze it on the 4th
00:28:21
okay and we will look for that in the
00:28:23
second column we want this to be the
00:28:25
true value were ok
00:28:27
we are going to put theirs here
00:28:33
within the so bad then we are going to pull the
00:28:36
bare skin a copy okay so if
00:28:38
I made trifi the segment if I come back
00:28:40
here that I filter I think
00:28:44
liana here I go here in my calculation
00:28:46
and in front of here there will be an apartment or
00:28:48
so to avoid the nerves because
00:28:50
there are more than now so from
00:28:52
pouma it would be necessary that the others are
00:28:53
also not so we're going to come back here and
00:28:56
put it back to everyone
00:28:58
is here in the invaded place so put
00:29:02
error 6 hours
00:29:03
if we see that an error we're going to
00:29:06
put it here semicolon schmid and we
00:29:08
close the parenthesis so that if tomorrow the
00:29:11
filter is done
00:29:12
without get lost on your own engine
00:29:15
and there we are going to look for these
00:29:17
figures and put them in our
00:29:19
commercial dashboard so here we are
00:29:21
going to look for Marjah's figure so we
00:29:23
are going to take it we are going to the public is already
00:29:25
controlling the
00:29:26
laws we are going to m me if for him we are going to put
00:29:30
for him we are going to put one for him
00:29:34
and we are going to put them side by side we
00:29:37
validate before all the seven
00:29:44
like that we will have the heads of each
00:29:46
so we are going to look for a husband ya so here
00:29:49
we are going to complain igal we saw it the time not
00:29:51
if we go looking here and maria she will
00:29:54
never move we will look for her figure
00:29:56
to whom she still
00:29:58
like that my tasks can take him and
00:30:01
click it here and like that to put it
00:30:03
all a verb so and so that's this
00:30:05
number in marjah and she's going to do the
00:30:06
same thing
00:30:08
hop we're going we're going to put that the
00:30:11
doctor the
00:30:13
weather has it
00:30:14
[Music]
00:30:16
now I'm calling here I'm the
00:30:18
self-control this allows you here to be
00:30:20
able to
00:30:22
duplicate objects quickly
00:30:25
so let's admit that it is andrew
00:30:28
again here we are going to look so andrew
00:30:36
then we are going to look for a hole
00:30:43
andrew c
00:30:45
let's admit that it is n'a if we are going to
00:30:49
look for my
00:30:52
6th
00:30:54
hockey him and let's say that it is
00:30:58
but yan
00:31:00
yan case quotas and let's say that madame
00:31:05
is not
00:31:07
her ok him
00:31:12
michael
00:31:15
n
00:31:17
hockey
00:31:20
laura but as long as it is Lorrain
00:31:24
g what is the last by putting that it
00:31:29
is robert
00:31:32
you are bouquet like that we will take place
00:31:35
at each one come on we go there so
00:31:37
now we have to 'we're going to get the turnover of andrew therefore
00:31:40
equal and we're going to look for the turnover
00:31:42
of andrew it's there ok here the
00:31:48
turnover of nazis is
00:31:49
equal
00:31:52
so it's the first
00:31:54
of turnover business of equal gan
00:32:04
we are going to do the turnover of
00:32:06
hann equal
00:32:10
ok we are going to look for the illegal michael
00:32:16
michael he is there the valid one
00:32:20
I am going to look for laura
00:32:23
legal I am business of laura
00:32:28
that is it and we are going to look for robert so
00:32:32
equal
00:32:36
nymphomania must now he will have
00:32:39
double click on the brush you are going to
00:32:41
do the same thing here same thing here
00:32:42
same thing here to duplicate the
00:32:45
formats like that hop we are going to stop macro
00:32:49
increase whereas now when I am
00:32:51
going to have here and my small numbers
00:32:52
here if I want have here calls the
00:32:55
periods to see that in the beautiful round number
00:32:56
each time it is updated since
00:32:58
moreover it goes it goes automatically
00:33:00
here we see the figures of
00:33:01
each hour clearly if I want that for andrew
00:33:04
and michael and there you go have the
00:33:06
figures that Andrew and Mickaël so
00:33:08
you don't have the others since
00:33:09
besides my own go rowing all
00:33:10
like that you are going to have here or your
00:33:13
dashboard which will control
00:33:15
all that ok
00:33:17
so here we have just done our
00:33:20
second
00:33:21
dashboard okay
00:33:24
directly so we're doing pretty well being
00:33:27
able to directly access a
00:33:30
second table here we started
00:33:32
here with a
00:33:34
general table we're going to go here after looking for the
00:33:38
sales dashboard we're going to
00:33:41
do now the customer dashboard
00:33:43
so we're going to check how we
00:33:45
could do we can do a little on
00:33:46
board customers
00:33:48
pretty much not why obviously
00:33:50
it's the same it's the same it's even
00:33:52
possible so for that
00:33:54
well we could here he
00:33:58
do a good duplication so we are going to
00:34:01
take him to duplicate it once again
00:34:03
to control pop and I duplicate this
00:34:06
sheet here we push here I am going to
00:34:09
call it customers
00:34:14
dashboard customers
00:34:17
we will be able to put some little
00:34:20
information here constant so if we could
00:34:22
put but since it's the customers
00:34:23
number of customers
00:34:26
the information we already have it we're going to look for it in the
00:34:29
right place so that's the number of
00:34:30
customers we're going to make it equal and we're
00:34:34
going to look in our calculation for the number
00:34:37
of customers that we had made, it is this
00:34:39
figure, we are here again and we
00:34:42
said that we could not find in the
00:34:44
welcome tab commented the size for the m 24
00:34:47
years old is
00:34:49
therefore there it will be another
00:34:52
here we could put we will also keep
00:34:56
here they are here we will change we will put
00:34:58
earlier 1 only in veiled words
00:35:00
it is the semapa region but if we are going to
00:35:01
put the saint mark have of course we will
00:35:03
remove the runoff commercial park
00:35:06
no call him back m
00:35:10
ok and then we will especially tell him that
00:35:13
salar now you
00:35:15
again him you have lounges and 4 m here
00:35:21
again the cup of customers
00:35:24
so he should put
00:35:28
on white
00:35:30
hockey again is he
00:35:33
again to black
00:35:36
to say each time that you come
00:35:39
two loads of hockey sheets
00:35:41
to commercial customers
00:35:45
customers and May 8 by coming here on our
00:35:49
tables ok so go there now and
00:35:53
well create a bleeding by
00:35:58
by customer I do not believe that in the
00:36:00
main we had it so we're going to go
00:36:03
to another calculation
00:36:05
look here
00:36:07
okay go to the t&d analysis
00:36:10
field list and we're going to ask him on the non-
00:36:12
customer side to insert a senate we're going to get them
00:36:16
back we have them all here control x
00:36:18
for bring it back into my
00:36:20
customer dashboard, okay, we're going to put them
00:36:22
against the country, we're going to do the same thing
00:36:24
as we did earlier, we're going to
00:36:25
leave a yellow like that, that's fine,
00:36:28
we're going to put that in two three columns
00:36:34
1
00:36:37
the role of m here
00:36:45
to see here our non-customer information
00:36:56
go percent
00:36:59
yes if we could even separate them if
00:37:02
we want to make a whole appear day per
00:37:04
year per customer
00:37:06
okay and we will try to put
00:37:09
all written the same way here they are here
00:37:13
for that so now
00:37:16
so there we are not going to display the
00:37:18
laon graphics where is displayed here we
00:37:22
could display for example the top the
00:37:24
top three clients for example so three
00:37:28
leaflets
00:37:31
ok we will try here the girl if the top
00:37:34
3 clients
00:37:41
go so we will have created the top three
00:37:44
clients
00:37:46
okay we will be able to know who
00:37:49
these devices are but we will have to
00:37:51
against the calculation the top 3 clients
00:37:52
game for the moment we do not I don't know who
00:37:55
it is, okay here we have the top 100 each time, okay,
00:38:02
but so we're going to try to be able to
00:38:04
recover if the information or each time
00:38:05
from the first three, we know what
00:38:07
the full rate was that was the top 10
00:38:08
since we're going to always put them in a
00:38:09
mode a mode here
00:38:11
of young people in hockey so we're going
00:38:15
for that but we're going to create a
00:38:17
little bit of a little top so we're going to
00:38:20
insert the shape of a small circle we
00:38:25
are going to leave its shift key so that it
00:38:26
is true circle
00:38:28
the pharmacies
00:38:30
so here by putting back the circuses
00:38:34
the a22
00:38:37
2.2 m short circle come on we are going to make a
00:38:40
little top so we are going to put a little
00:38:42
lace top by
00:38:44
cutting 0.28 here we are and we are going to put a
00:38:48
number inside we will have understood it
00:38:49
so there it is my full rate
00:38:51
okay you type again and this number
00:38:56
we will the center and the master a sheet and
00:38:59
we will put it on all
00:39:01
that it's my top one ok once we've
00:39:04
done it we're going to put
00:39:08
the top 2
00:39:10
again and
00:39:13
the top 3
00:39:30
so go there we made the top bottom
00:39:32
2,3 so we're going to look for lissine at the
00:39:35
labels what we have needs to go
00:39:37
get our cousins ​​so here we
00:39:39
will be able for example to take down
00:39:41
so this label doesn't matter
00:39:44
where even [ __ ] don't have the
00:39:47
controls d ok we're going to take it we're going to
00:39:51
put it here
00:39:53
already to go and display the number
00:39:56
d 'Okay we're swallowed m we're going to like it
00:40:00
wine color numbers we were going
00:40:01
to put a black or dark blue there
00:40:03
whatever so we're going to look for it it's
00:40:06
the top one equal and we're going to look for
00:40:09
another indicator the first it could be
00:40:11
that the first here I validate then it
00:40:15
will tell you that you are not going to find them
00:40:17
we had already seen here so we are going to do the
00:40:21
same thing that we did earlier
00:40:22
here we will want to be proud that the state
00:40:24
grants so we are going to take the
00:40:26
first three ends here the least control of the
00:40:30
controllers
00:40:35
we are going to do how to do better than that
00:40:37
yes here we go there done we go to the form
00:40:40
and hop
00:40:42
and if we add displayed in three
00:40:44
rounds 3 then we're going to need here
00:40:48
the head so here to put me to
00:40:50
put directly here important
00:40:53
top 3 is here takes too long
00:40:58
for it to remain the dynamics in
00:41:00
hell equal we're going to look for the first
00:41:02
one okay we're going to pull the handle their
00:41:04
copy ok equal we're going to look for the top one
00:41:09
equal we're going to look for the top 2 of the guys we
00:41:13
're going to look for our too
00:41:15
and that we want it to be formatted a
00:41:18
euro so here we're going to put
00:41:21
him it's the same amount control these
00:41:25
controls controls v
00:41:29
is here to put the same top
00:41:34
it is so here well we lie the years
00:41:36
like that if it will filter but there will
00:41:38
always be the same data here so
00:41:40
for that
00:41:42
well here we go we will go to the
00:41:45
clients and we will look here for the amount
00:41:47
of an equal talent and we will look for the
00:41:50
top one the topo announced forget it
00:41:52
maybe that the first number
00:41:56
is without bold also
00:41:59
much better ok
00:42:02
the mole one and to know who it is the
00:42:05
top one so check
00:42:10
ok
00:42:15
yes we're going to look for volume 2,
00:42:21
still missed for the bacchus mountain
00:42:23
and the top 3 like 3 on
00:42:27
May 10th by that
00:42:30
which is
00:42:33
missing and that you
00:42:37
're going for that so b him we're going to look
00:42:40
there where it should be we're going to put a
00:42:43
little more bottom we're going to put it on it
00:42:45
the day after the customer's order
00:42:47
so here it's the top 2 equal we're going to
00:42:50
look in the kakulya sheet but the
00:42:51
top two valid and him we're going to look for
00:42:55
round 3 equal but we're going to look for the
00:42:58
cold weather which is located here
00:43:02
so that we are going to do it with the brush
00:43:05
here with the brush here come on we are going to
00:43:10
take but if this small measure
00:43:11
also control
00:43:13
so we are going to put it over here here we are going to make
00:43:16
the name of the company known so we are
00:43:19
going to put it in greater care so the
00:43:21
top 2
00:43:23
control control here
00:43:28
control here
00:43:30
happy that we will be able to see
00:43:39
more names of the companies like crazy
00:43:49
so here we will look for the name of the top 3
00:43:52
so I get into the rhythm
00:43:54
obviously facing the text which is in and
00:43:57
here we are going to type is calm what we need to
00:43:59
paste another dynamic there our
00:44:01
calculations the top 2 is the company h ok here
00:44:04
we go so we are going to try to
00:44:07
succeed that it was also visible
00:44:11
here
00:44:14
come on we are going to do the same thing so here
00:44:16
we are going to delete the content we are going to look for
00:44:18
the name of the client top now equals
00:44:21
calculation here
00:44:25
and we are going to do the same thing for
00:44:28
the top-3 equals
00:44:32
calculation it is him
00:44:36
and if we want
00:44:38
it to do it here here we have the information
00:44:42
so there we now have the top is the
00:44:45
same if I click here this regional
00:44:47
we will see the tops so here will put
00:44:49
to seek to buy back we will see them
00:44:50
why because down here he saw that
00:44:54
he did not have not he did not find and
00:44:57
because behind but he is looking in relation
00:44:59
to the value of these unions which if he
00:45:01
went to look to read data and to
00:45:03
dig lamic so that will bother you
00:45:04
so for that send quickly and I 'I had to
00:45:08
look for this formula read it gives and
00:45:09
academic English files
00:45:11
option
00:45:14
of agreement in the formulas here you
00:45:17
go one told me not to use here
00:45:19
you are going to sleep on the manipulation
00:45:20
of the formulas used the
00:45:21
civil servants you are not going to use
00:45:23
you do ok now you do not have to
00:45:25
do legal again go get
00:45:27
him and have you automatically like
00:45:29
you are going to click on the outfit
00:45:31
now we will always look for the
00:45:33
vouchers okay so the mornings it's
00:45:36
like it's going to be done all alone in
00:45:38
whatever region here you will have
00:45:40
each time the different companies
00:45:42
here it tells you that the southern network is
00:45:45
the companion and b which is shameful one and
00:45:48
we will check that it is indeed the
00:45:49
company b with these figures ok so that's it
00:45:52
it works alone and we're
00:45:53
also going to do the same thing to say it
00:45:55
senna's parameters have hidden the
00:45:58
scattered elements and for him parallel in
00:46:01
life ok and I put everyone back
00:46:06
so here we already have our top
00:46:10
3 customers we will be able to make a little
00:46:12
graph here so we don't need
00:46:14
that we already have two salespeople we will
00:46:17
let go now not the
00:46:19
young one and we don't need that either we we
00:46:22
're going to do a control control control
00:46:27
we're going to do sugar
00:46:35
sugar
00:46:36
and we're going to recover
00:46:39
also be careful to select
00:46:41
the areas
00:46:44
made sugar ok here we're going to draw a little
00:46:48
a little graph we're going to go we
00:46:50
had prepared it here we're going to close sale
00:46:52
by business messi per month why
00:46:55
not so here we are going to create a
00:46:59
short type pivot table well here we are going to do
00:47:02
earlier with points do ok
00:47:04
we are going to put my sales per
00:47:08
month okay the buttons that it seems
00:47:11
big things
00:47:13
here the young people and that's not much
00:47:15
the grid it appears that one thing
00:47:17
the label at the bottom m above agree
00:47:20
so we will be able to remove the box
00:47:22
there
00:47:27
is here we could put in title but
00:47:29
me not lemaitre on 100 m in a little
00:47:31
train directly in the form go
00:47:33
see a very small graph control
00:47:53
a problem is to put a
00:47:55
small title
00:47:56
control of
00:47:58
and they will tell me here
00:48:06
annual evolution
00:48:10
of sales
00:48:13
ok
00:48:16
so we will try to improve the
00:48:19
data here so we will put them also
00:48:21
ungrateful could note a little bit the size
00:48:24
to see the figures
00:48:25
of these ungrateful people who are getting darker
00:48:28
we are going to put since they are customers
00:48:31
we are going to put here the formats as
00:48:35
even presented all this storm contours
00:48:39
with a turn and made a little wider
00:48:43
okay we are also going to take advantage of this to
00:48:45
put the small buttons there we go
00:48:47
first which mark and markers case
00:48:50
which right format the marks
00:48:52
so here we are going to click on the
00:48:55
paint can we are going to look for the
00:48:56
brand brand options here we are going to complain it is
00:48:59
the circle but we are going to do it a little
00:49:01
bigger then to be conducive to the
00:49:04
flock were worth m
00:49:07
here is a storm color the filling
00:49:10
not blue but storms it's all in rage
00:49:13
still no borders
00:49:16
and we could also put in effect
00:49:19
this button which was made small
00:49:22
relief effect button so we're going to put a little
00:49:23
kiss for example like that it makes it
00:49:27
fart it makes it makes little circles
00:49:28
in sheep format it's not too bad
00:49:31
it's a little more than ten and we're going to
00:49:34
take advantage of it to put
00:49:38
the months around in perspective
00:49:41
tried to put the months
00:49:43
in particular
00:49:48
it promises here to be able to
00:49:50
put a little bit the months he liked
00:49:52
as much as bigger
00:49:54
it's finished
00:49:56
ok that
00:49:58
's how we're going to tear off the
00:50:01
graph we're going to tell him at war format
00:50:03
outlines without outline filling without
00:50:07
filling in particular our pride
00:50:09
in being by separating its aisles we did
00:50:13
here we are going to save
00:50:15
we were already calling for our
00:50:17
second the 23rd page okay so I
00:50:22
'm already having trouble stopping there for for
00:50:24
this part there because on the videos
00:50:25
we It's still a little long so we're going to
00:50:27
try to
00:50:28
generate all that directly.
00:50:32
I'll see you soon on the
00:50:35
next one in the rest of this
00:50:37
tutorial.

Description:

Bonjour, Faisant suite à vos commentaires concernant la présentation d'un Tableau de Bord Excel avec effet Design. Voici la deuxième vidéo explicative d'élaboration pas à pas d'un Dashboard sous Excel. Vous en souhaitant un bon visionnage. Ci-dessous le lien permettant de récupérer le fichier source : https://learnaccess.kneo.me/content/b36d22iu/ Learnaccess ********************************************************************************************************* Utiliser mon lien de parrainage pour acheter un produit Tesla et obtenir des crédits gratuits : - kilomètres gratuits en Superchargeur - des vêtements et accessoires. https://ts.la/jeanpaul673722 *************************************************************************************************************

Preparing download options

popular icon
Popular
hd icon
HD video
audio icon
Only sound
total icon
All
* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."
** — Link intended for online playback in specialized players

Questions about downloading video

mobile menu iconHow can I download "EXCEL - Conception Tableau de Bord avec Design (Module #2)" video?mobile menu icon

  • http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.

  • The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.

  • UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.

  • UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

mobile menu iconWhich format of "EXCEL - Conception Tableau de Bord avec Design (Module #2)" video should I choose?mobile menu icon

  • The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

mobile menu iconWhy does my computer freeze when loading a "EXCEL - Conception Tableau de Bord avec Design (Module #2)" video?mobile menu icon

  • The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

mobile menu iconHow can I download "EXCEL - Conception Tableau de Bord avec Design (Module #2)" video to my phone?mobile menu icon

  • You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

mobile menu iconHow can I download an audio track (music) to MP3 "EXCEL - Conception Tableau de Bord avec Design (Module #2)"?mobile menu icon

  • The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

mobile menu iconHow can I save a frame from a video "EXCEL - Conception Tableau de Bord avec Design (Module #2)"?mobile menu icon

  • This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

mobile menu iconWhat's the price of all this stuff?mobile menu icon

  • It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.