8 hours 33 minutes
Okay, so we're going to talk about customizing ribbon,
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.
Ah, groups of commands, uh, that you have
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,
Andi. You have editing portion without some feel clear and all this stuff. So this is what's it by default in home, Deb.
Now, if we speak sure to excel,
toe, get to this, you just press
tab and then you go toe options
and you get the scene
dialogue like selections that you have
seen in previous lesson. When we customize the quick access still bar, except we're going to go here
and customized the ribbon.
But before that, we were going just to go to
this part of estimate station, which is also part of customization of Excel
and s O,
for example, you can customize this part off off his background and if you say OK, you get something different here,
which is probably not the most important thing in the world.
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,
HD display. But if you're using force key display,
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.
And when I press this, nothing really much changes. Except when you start typing Kier.
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
is not simply visible because there is nothing to show that change.
Ah, but for ah people who were doing
some more complex things going to 220 p p. I is something that they might need.
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
going to quite a lot off
every day Oh, and oh, and you need simply more.
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
ah. Also, you can at the quick access for the recent the workbooks which is
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,
and just to show you how it looks, so I see.
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.
so let's go toe these options again to the advanced and change this too.
on dhe Uh, you can customize this. So if you're
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.
Okay, So, uh, let's go to customize ribbon option.
And when you want to customize ribbon, you get it pretty much the same. Like
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
because then you get this one.
And also if you
ah, the difference between ah, customizing ribbon and customers a quick access still bar
is this so if we want to add something like form, it sells
and we want to edit toe to home
and we say
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
quick new group.
you can create you tab or
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
Then we can add this form itself here
and then do that. Remember that wasn't home.
So when we go to home,
we get this here,
which is extremely convenient.
you didn't help you
puts things you use
closer to you also form. It sells ca NBI placed in
So let's go to customize driven
and ah, but say that we work a lot in formulas
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,
uh, we can remove this.
You say remove.
And then if you say OK,
it's gone. Because if we're not using styles all the time
or we're not using them a toll,
then we don't need them. And we don't want them populating the space, which can be used more,
usefully for something else.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand