Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:00
So let's continue
00:02
this lesson about customizing ribbon.
00:05
So we have done something that, uh, we feel, uh,
00:09
you shouldn't have done, like, removed the styles section. So we go back to customers ribbon
00:15
and we go to reset. Then we say is reset only selected ribbon tab, and it will return style. So we click. Okay, Is back there, So Okay, we said something. We did something you shouldn't have done. It was Oops. Moment. And we're now back to
00:33
going through customizing ribbon.
00:36
So, um,
00:38
you have seen that you can remove default groups from tabs.
00:43
You can create a new tab, which can be Ah,
00:48
it's a yeah.
00:52
Special matte crows.
00:57
Yeah.
00:58
And then we didn't that new time we can have
01:02
Ah,
01:03
you grow, Which can be
01:06
Mylan's.
01:07
My crew's.
01:11
Because that's me and I have created Semak Rose and I want it there. I don't have them yet, but it's going to be there, so
01:21
Okay, Special Mac Rose. No, nothing's here. So there is nothing in the group. I could have added something, but I don't have any markers at the moment to add just showing this is
01:34
example.
01:36
And, uh, this is what we have done.
01:38
So,
01:41
um, a
01:42
in the hole.
01:46
Oh,
01:47
things that we, for example, Adan's. It's usually something you don't need to remove it help as well, because you get it in pretty much every function and almost every every window you get.
02:00
But, uh,
02:01
you can change things. So, for example, and insert tables, you have people table recommended people table is a table. And, uh, when you go here and you go,
02:15
uh, for old tabs and then you go to
02:19
smart the picture, your table tools, you can add
02:30
to this one.
02:31
So here is like this one,
02:35
and you have, for example, adding viewed style table options, which is a group. And then, if you're put this, you get the quick styles and you get throw Heather's called Heather's and stuff like that. So if you please okay.
02:49
And you get here and you get
02:53
these things oak off course. Because if you don't have any people table that is actually here, we be done. So it's a really powerful thing. You can
03:04
you can do whatever you want.
03:06
And then the nice thing about this is that you're customizing something
03:13
you can go to import expert and essentially save
03:16
your
03:17
estimize ations
03:20
so you can go to this beach documents and I sail excellence. Excellent customization exported you he and I can put a date. Today's
03:30
10 3 2019
03:35
Sorry.
03:36
Those 19
03:38
Andi I can kiss, uh, this'll ce
03:45
on. Then I can save it.
03:46
And if we go to the documents,
03:51
me suddenly
03:53
get
03:54
this file
03:55
So it's here
04:00
just to see it. It's in
04:03
here
04:08
so
04:09
we can now reset.
04:12
And recent resettle custom is ations.
04:15
And when you say OK,
04:19
everything is back to normal. So we don't have this one here. We don't have millions. Jack Rose, nothing like that.
04:28
And then we can go back to the options
04:30
and we can select
04:33
Ah customize ribbon
04:35
and say, OK, import customization file makes a crystallization.
04:42
It will ask you Are you sure? Like
04:46
it's normal
04:47
and then
04:50
it's okay
04:53
is back.
04:54
So we are going to reset it again
04:58
just so it doesn't
05:02
us problems,
05:05
and this is it. Now we're going to go through one thing a cz well,
05:14
which has nothing to do with customizing interface.
05:17
But it has something to do with customizing the way your excel sheet is displayed.
05:26
Andi, uh, we're going to do that. Incantation off this lesson

Up Next

Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor