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

Download "DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)"

input logo icon
"videoThumbnail DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)
Table of contents
|

Table of contents

0:00
Introdução
0:30
Considerações Iniciais
1:35
Criando o Menu
5:00
Formatando o Menu
Similar videos from our catalog
|

Similar videos from our catalog

Video tags
|

Video tags

como criar menu de navegação no excel
botões de navegação no excel
menu planilhas de excel
link entre planilhas no excel
menu de navegação excel
menu dinâmico excel
criar menu no excel
inserir menu de opções no excel
menus e links de navegação entre planilhas no excel
criação de links no excel
criar menus de navegação no excel
hiperlink entre planilhas
menu excel
aula de excel
curso de excel
Ninja do Excel
mmc220814
Curso Online de Excel
aprender excel
Excel
aprenderexcel
cursoonlinedeexcel
excel
menudenavegaçãonoexcel
botoesdenavegaçãoexcel
linksnoexcel
cursodeexcel
Subtitles
|

Subtitles

subtitles menu arrow
  • ruRussian
Download
00:00:02
another class today we're going to learn a really
00:00:03
cool thing, which are these
00:00:06
little tabs that are here at the
00:00:08
top, you can see when you click, it
00:00:10
goes there and comes back here as if it
00:00:12
really were a tab of a website, right?
00:00:14
We're going to learn this here and do
00:00:16
it here step by step here in Excel,
00:00:18
then there's the vignette, we're going to start
00:00:20
another class here on the Excel Ninja channel
00:00:22
[Music]
00:00:25
Hello, welcome, very
00:00:31
welcome my name is Edson Cavalcante
00:00:33
I am the creator here of this Ninja
00:00:35
do Excel channel here on YouTube and also of the
00:00:37
blog Ninja excel.com.br and we also have
00:00:40
something new that the blog Ninja de Excel
00:00:43
which is our blog in Spanish yes we have
00:00:47
the blog Spanish is now also Brazil
00:00:48
exporting knowledge to other
00:00:51
languages ​​So if it's the links, I'll leave them
00:00:53
below, okay, but then subscribe
00:00:55
to the channel, I also saw the Update there, the
00:00:56
notification bell so you can be
00:00:58
notified with each new class, we always
00:01:00
add classes new ones every
00:01:03
week here for you, okay, let's go,
00:01:06
how do we put this in? I'm not going
00:01:08
to talk about this dash board specifically,
00:01:09
it's already ready, where in the
00:01:12
new file are you going to look for it, you put
00:01:15
weight loss control there and it's already there
00:01:17
bring a test mold ready for you, I'll
00:01:19
just give Tec a little bit about this issue with the
00:01:22
Flaps here, let's do it here step
00:01:24
by step, you can see that it's fine,
00:01:25
but it takes a little work to do a
00:01:28
little bit, but it takes a while to
00:01:31
do these little details, right, but if
00:01:33
really the result is better how
00:01:35
we do this what is this here, I'm
00:01:37
just going to show you if I move the
00:01:39
mouse over here you will see that this one
00:01:41
is an object, you can see a
00:01:43
separate object there, you can see that this object
00:01:46
here is this object of a control here
00:01:48
to return it is here, insert a
00:01:51
shape, right, and I took this one, this one,
00:01:53
I put it here like this and just
00:01:58
increase it by putting a little bit of it on the
00:02:00
edge here, I did this from
00:02:03
this now I added the colors and removed the
00:02:06
smaller outline, that's how I created this
00:02:10
shape, you see,
00:02:11
and here, very well, they are all the
00:02:15
same, the difference is the size here, right,
00:02:17
so I'm going to pay Zé to make it so you can
00:02:19
write it down here, so far, I'm going to delete this one.
00:02:23
here I'm going to leave it, I'm going to delete it and here I'm going to
00:02:27
delete it so here, let me open it and it
00:02:30
opens down here to find out which one it
00:02:32
sprouted from in the data entry tab So
00:02:35
I'm going to take it, put it here, ok, come
00:02:38
here, let me zoom in to make it easier
00:02:41
For you, here it's easier for me to see
00:02:44
everything on the same screen, right here, right here,
00:02:47
I'm just going to reduce the size a little bit,
00:02:50
right, just to fit here just right? And then
00:02:52
you're going to leave it more or less here and
00:02:54
you're going to give a space, a situation, a
00:02:58
touch down, see, just so it doesn't have a
00:02:59
percent aligned here, you can
00:03:01
see, right button and I'm going to put it here to
00:03:04
send to the back, you'll be behind
00:03:07
this text box here, it's a
00:03:09
text box, you can see, insert it
00:03:11
into a normal text box I'm going to come
00:03:14
here and I wanted to type, right,
00:03:17
data entry, but then the formatting is a
00:03:19
different color, so I'm going to do it now,
00:03:23
right click, I can copy, right, or against you,
00:03:25
control over, I'm going to come here and also put it
00:03:29
here, just a little bit down
00:03:32
so that it stays exactly here on the
00:03:35
right button, send to the back and then I can
00:03:38
enlarge it, leaving it more or less here at the
00:03:40
same size, I can select
00:03:43
both here, select both, I'll go there in the form
00:03:45
of shape, align it and I'll
00:03:49
put it here, align it in the middle, it will
00:03:51
be just right and also align the middle
00:03:55
no and it was already aligned I'm going to put it here
00:03:58
and it's aligned
00:04:00
and it's the one centered here, it looks
00:04:04
cute with this one too, right, this one
00:04:08
also aligns to sensualize
00:04:10
the ball show there, I'm going to do the
00:04:14
same as copy paste just now in this
00:04:17
one I'm going to change the size a little, right,
00:04:21
and let me put it back here, send it
00:04:23
to the back, put it more or less here,
00:04:26
and beauty, all of them I created, you'll
00:04:30
notice here with what, with a gray color,
00:04:32
it's here, your ring to make
00:04:37
all of them with the color gray But
00:04:39
you will come back here when I click
00:04:41
on one of these here on this one here for
00:04:43
example it has to be like the
00:04:46
highlighted water it has to be in red
00:04:48
this little red rose here I don't know
00:04:49
anything you see then I see
00:04:51
red you are because or service but I
00:04:55
see red he started saying that orange anyway and when the guy goes to
00:04:58
another tab he has to stay too
00:05:00
see red This red here and I
00:05:03
that is highlighted is blank and the
00:05:05
rest looks like this, can't you see to give
00:05:07
this effect beauty how we do this
00:05:09
is the following this one is highlighted
00:05:12
So I'm going to take format and I'm going to put
00:05:15
loan here, I'm still going to put
00:05:17
White because now let me
00:05:20
go back here to 100%
00:05:22
and it just stays there, it just happens, this one
00:05:25
goes from there to here, you see, that's what
00:05:27
we're going to do with everyone now, very
00:05:30
simple, the others, o I'll even delete it and
00:05:32
do it again, oh,
00:05:33
hi, come here, delete, come here, delete, I'll go to
00:05:38
the data entry and that there is acceptance
00:05:41
from those who have already been using sky for a
00:05:42
while, just see if I'm going to get them
00:05:45
here, copy them here, select them, I can
00:05:48
even group them if I want, the right button,
00:05:51
group them and it's one way, just copy them,
00:05:55
I'll go to the other there necklace but it looks
00:05:58
a bit like this, you see mine, you're going to have to
00:06:00
find the right spot to keep going back
00:06:02
and forth, I'm going to give you a seat here
00:06:05
on an old boat here, heaven, that's all it's going to do.
00:06:08
Take it here, ungroup it, right, ungroup it, it
00:06:11
takes it any shape, any shape, it
00:06:13
can be a small square, put the
00:06:16
square directly pasted here, well
00:06:19
glued, you can take it here for example.
00:06:22
Glue doesn't matter the size. You just
00:06:24
paste it here. Yes, you'll be teaching
00:06:26
them with shift held. The peacock is there.
00:06:31
cat that with shift here here and here
00:06:35
right button group group and now
00:06:40
copy go there here paste and then you'll just
00:06:44
go down because it's already aligned
00:06:46
to the maximum here you see, I know it
00:06:49
's a really cool feel for you to
00:06:51
put send it to the back, it's already in the
00:06:53
same format here, just
00:06:56
ungroup it, I told you, it's a
00:06:58
bit of a pain to organize it
00:07:00
here, this one here, for example, is the
00:07:04
information about BM, that is, this one here
00:07:07
has to keep it highlighted here, in the format,
00:07:09
I'll go there and put it blank seeing ok
00:07:13
he stays here if I go back here
00:07:15
to data I'll have to
00:07:17
right click here because I need it now I
00:07:19
'm going to ungroup I'm going to get this guy I'm going to
00:07:23
delete if he's just the three of us here the
00:07:26
right button send to back,
00:07:28
it's strange here, So ask here
00:07:32
Hello, not now, the last one is missing here,
00:07:36
this guy here, let's do the same
00:07:39
thing, I'll delete it here And do it from scratch
00:07:41
as you see, I'll go there, I should have already
00:07:45
done it, actually here, since I I copied it. I
00:07:47
should have bought it too, but there's no
00:07:49
problem, so here,
00:07:51
I selected this one with shift shift
00:07:55
and chip, here I copy it, I go to Sueli's lap panel,
00:08:00
right here, we're here, there's one more,
00:08:05
actually, well, people here,
00:08:08
talk great seeing this guy, delete him,
00:08:12
I go to them, I select the right button, send
00:08:17
back and in this guy who wants the guy
00:08:19
selected format here and white Then yes,
00:08:24
complete, how do you move
00:08:27
back and forth, Edson, if it's the right button,
00:08:29
you'll leave it here, ok you can
00:08:31
either select both, right button,
00:08:34
I don't think it's possible, it has to be a pure one,
00:08:37
even though it's here, this one already has it, in
00:08:39
fact, select it, right button,
00:08:41
hyperlink, see, but I can put it
00:08:44
here too, right button link And then,
00:08:47
where do the Let's go in this document
00:08:50
then you will choose which water
00:08:53
you want, right in this case here the
00:08:55
data input So I'm going to put
00:08:56
data input here so when
00:08:58
both the text and the tab arrives it goes
00:09:01
there to There you see, this is how
00:09:03
we do it so you can put it in
00:09:04
all of them too or just in the
00:09:08
images in the same one, you see, and
00:09:10
now we have it very dynamic, very cool, very
00:09:12
interesting, these Tabs where you can
00:09:15
place another photo, delete a guy who is
00:09:18
this guy that's missing I chose here
00:09:20
now but now it's beautiful these
00:09:22
Tabs here as if it were a menu on a
00:09:24
website that you can put so much here in the
00:09:26
part up there, right But you can also
00:09:29
suddenly put it in the part here right, on the
00:09:33
vertical side and the information
00:09:34
and finally I'm done with your creativity
00:09:37
I would recommend doing this last
00:09:40
because wow, it can be a lot of work, it's
00:09:43
worse that I'm doing it kind of quickly so as
00:09:45
not to make the class too long, but if
00:09:47
you're going to do it like this, dedicate a little time
00:09:49
later to Doing this here ends up being
00:09:51
a kind of tinkering in the end, right, but
00:09:54
it's very cool, it's very attractive,
00:09:55
it's very elegant. As my friend
00:09:57
Fábio Baldini says, when he talks about
00:10:00
beautiful flags, he talks like that, right?
00:10:02
Elegant, so it's very elegant. It's
00:10:04
worth doing So, calculate your
00:10:07
time well, then you need to spend a lot of time, it's
00:10:09
also busy here, choosing here,
00:10:11
beauty, that's it, see you, so in the next
00:10:14
class, it will be a pleasure to have you there with
00:10:16
us, and I also take the opportunity to
00:10:18
invite you to discover our courses. We have
00:10:20
several courses in Excel for you, as
00:10:23
your intermediate base on Saturday,
00:10:25
dashboards, a complete one, anyway, there are
00:10:27
a lot of things, if you already like these
00:10:29
classes here on YouTube, which are
00:10:31
free classes in the course, you will definitely
00:10:33
like it even more, the link below
00:10:35
and go there and it will be a Nice to have you
00:10:37
there for us too, big hug and see you
00:10:38
next time

Description:

Criando Menus em Planilhas como se fosse um SITE Curso de Excel Completo: https://ninjadoexcel.com.br/curso-de-excel-completo/ Nesta aula, você vai aprender como criar Menus em suas planilhas como se fosse um Site. São menus de Navegação, que vão dar uma toque extra em suas planilhas de Excel, formatando como se fosse um site de navegação. Este tipo de menu também é conhecido como menu dinâmico, ou botões de navegação no Excel. São botões com links entre planilhas que deixam os relatórios mais sofisticados e otimizados. Nesta videoaula ensinamos a criar estes menus em formato de "Abas superiores", porém, com a mesma base de conhecimento é possível aplicar para o design que desejar. A ideia é a mesma, e você consegue personalizar o seu menu, ou seja, vai de acordo com a sua criatividade. Se você não ainda não é inscrito aqui no canal, faço um convite para se inscrever, e por favor não esqueça de deixar o seu like, comentar abaixo se gostou da aula e a sua sugestão para os próximos vídeos. Ótimos estudos. Link desta aula: Criando Menus em Planilhas como se Fosse um SITE https://www.youtube.com/watch?v=vFPlQ_HWqUs Aula Complementar no Blog: Como Criar um Menu no Excel para Navegação https://ninjadoexcel.com.br/como-criar-um-menu-no-excel/ Já é inscrito no canal? Clique aqui e inscreva-se: https://www.youtube.com/user/ninjadoexcel?sub_confirmation=1 ----------------------- CURSOS DE EXCEL Se você quer aprender Excel diretamente comigo, acesse o link e veja os cursos disponíveis. VAGAS LIMITADAS. Curso de Excel Completo: https://ninjadoexcel.com.br/curso-de-excel-completo/ ----------------------- MEUS CONTATOS ▶ www.ninjadoexcel.com.br ▶ Grupo de Estudos no Facebook: https://www.fb.com/groups/ninjadoexcel/?fref=ts ▶ Facebook: http://www.fb.com/ninjadoexcel ▶ https://www.linkedin.com/in/edsoncavalcantejunior ▶ Email: [email protected]

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 "DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)" 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 "DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)" 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 "DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)" 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 "DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)" 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 "DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)"?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 "DASHBOARDS NO EXCEL - Criando Menus de Navegação em Planilhas (Como se Fosse um SITE)"?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.