Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:01
Okay, so we're going to talk about customizing ribbon,
00:05
and you can see here ribbon split in two lines for better legibility. So the ribbon consists off tabs. You have file home insert page layout formulas, data review of you and help tab. And then if you click on Tab, you get a ll these default.
00:25
Ah, groups of commands, uh, that you have
00:30
for for that tab. So, for example, in ho tab, you have the clipboard portion than the fun portions in the alignment number. Former thing in terms of condition for mating, form it stable than you have styles. You have cells,
00:45
Andi. You have editing portion without some feel clear and all this stuff. So this is what's it by default in home, Deb.
00:56
Now, if we speak sure to excel,
01:00
um,
01:00
toe, get to this, you just press
01:03
filed
01:04
tab and then you go toe options
01:07
and you get the scene
01:11
dialogue like selections that you have
01:14
seen in previous lesson. When we customize the quick access still bar, except we're going to go here
01:22
and customized the ribbon.
01:25
But before that, we were going just to go to
01:29
this part of estimate station, which is also part of customization of Excel
01:34
and s O,
01:37
for example, you can customize this part off off his background and if you say OK, you get something different here,
01:46
which is probably not the most important thing in the world.
01:51
But what you can get here is some things about, for example, default resolution. So you get it's here. They set it 220 p I. But for example, if you're using uh four k display, which I'm not I'm using just, uh,
02:08
HD display. But if you're using force key display,
02:12
then your resolution might be different. Especially if you're using notebook with I don't know, 15 or 17 inch notebook with four K display so you can go toe 330 p p. I.
02:24
And when I press this, nothing really much changes. Except when you start typing Kier.
02:31
Ah,
02:32
you don't see this change because my display and the this video being captured is captured in ah in, uh, full HD resolution. So this change
02:44
is not simply visible because there is nothing to show that change.
02:49
Ah, but for ah people who were doing
02:54
some more complex things going to 220 p p. I is something that they might need.
03:04
This is something that you want to customize, which is show the number of recent world books. So you go to file anyone toe open the recent file the list will contain last 50 opened workbooks. You can reduce it to get it better eligible or ah, you can increase it if you are
03:23
going to quite a lot off
03:25
files. Um,
03:28
every day Oh, and oh, and you need simply more.
03:32
Uh, also, Ah, Ruler units can be default units, which are some kind of excel units, but you can change your two millimetres as well. And, uh
03:45
ah. Also, you can at the quick access for the recent the workbooks which is
03:53
may default for, and you can decrease it. Now I'm saying millimeters because in from Europe and we're using that but for the rest of this,
04:02
and just to show you how it looks, so I see.
04:06
Ah, yeah,
04:10
makes nothing not much different except the sea I see now here in millimeters. If I'm preparing something for printing, this might be quite important.
04:20
Um,
04:23
so let's go toe these options again to the advanced and change this too.
04:31
Unfortunates
04:33
on dhe Uh, you can customize this. So if you're
04:38
America's or North America, you'll probably use inches if you want to pre presented for printing because then it's much clear how it's going to look.
04:49
Okay, So, uh, let's go to customize ribbon option.
04:55
And when you want to customize ribbon, you get it pretty much the same. Like
05:00
when you're customizing quicksand, Stool bar, except for a few things. For example, when you want to work with Mac Rose, you have to turn the developer on
05:12
because then you get this one.
05:15
And also if you
05:17
ah, the difference between ah, customizing ribbon and customers a quick access still bar
05:23
is this so if we want to add something like form, it sells
05:28
and we want to edit toe to home
05:31
Ah,
05:32
cells
05:34
here. Ah,
05:36
and we say
05:38
ads.
05:40
You get this message you says commands need to be added to custom groups to create a group. It could have been the list and then crypt
05:46
quick new group.
05:47
So, uh,
05:49
you can create you tab or
05:54
you can click here and create new group. And it can be custom. It doesn't have to be. We can rename it and use it, can call it sells
06:06
two
06:09
and ah,
06:11
Then we can add this form itself here
06:15
and then do that. Remember that wasn't home.
06:20
So when we go to home,
06:23
we get this here,
06:25
which is extremely convenient.
06:29
And
06:31
you didn't help you
06:33
puts things you use
06:35
frequently
06:38
closer to you also form. It sells ca NBI placed in
06:43
any other.
06:46
So let's go to customize driven
06:47
and ah, but say that we work a lot in formulas
06:54
and we want to move these cells here because we want to form itself by typing formulas so we don't want it here also. For example, if we are working with Stiles,
07:08
uh, we can remove this.
07:12
You say remove.
07:15
And then if you say OK,
07:18
it's gone. Because if we're not using styles all the time
07:24
or we're not using them a toll,
07:26
then we don't need them. And we don't want them populating the space, which can be used more,
07:31
um,
07:32
usefully for something else.

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