8 hours 33 minutes
to customize the big success toolbar
in the quicker Cristal bar itself, you have
the drop down menu that is actually meant for that.
And the reason for it is because most of
most people that there
advanced users of excel.
They want some things in the quicker system here, which is not there by default, because these things they use a lot.
So let's go to
and do it.
So you're simply click here and you get the customers quick access to a bar.
just till, like this one,
you will get the new
willing to control and
small I can hear in the quick Sistol bar.
We can also switch it off because it's something that
people don't usually d'oh.
But you can put here preview in print
and you get the print dialogue, which is, by the way, accruing to quicken file and then print. So it's ah, not that many more clicks. It's just one click more than it would be when you're
doing the regular action for print.
But if you're printing a lot and ah,
contrary to the common opinion, some people that use Excel print a lot. So people that do accounting people like me who has reached a certain age and if they want to analyze that, that they actually feel much more comfortable when they have a printed paper
in front of the self than the screen.
S O. There are quite a lot of reasons to print,
and it's It's convenient to have this one as well as you can have a quick print which
Okay, so there is nothing to print, but
but this is Ah, this is convenient.
So if you have your printer's set up, you have your printer options already set up. You don't have to choose which printer using because, for example, here I have by the folk Microsoft print to PdF.
But maybe I want to print on my colleagues jet and then it's Ah,
it's a different story, So I have selected
every time I go to print. So the quick, clean button is just for
uh, set up. If you have it,
you can add spelling if you type a lot in your excel and you want to check spelling.
Okay, so there is nothing to spell, but you get it there. So it's It's quite a convenient thing to put here. Ah,
you have sort of sendings or descending if you do what? The sorting while looking at the Excel file and then the analyzing data.
But also, you have the option to do more commands. And this is the important one.
Oh, yeah. By the way, before we go there,
uh, there is an option show Bill of the ribbon. This is what they told you the beginning. So the quickest esta libre is usually here. But if you for some reason, wanted here,
uh, then you can put it here. And then again, you can, uh,
put it back.
for some people who are
who have been using office for quite a long time,
this position here is much more convenient because it reminds them or the old
user interface. The toughest programs had some 10 years ago. So this is this is something simply more convenient. It does reduce the viewing space of the worksheet itself. But if you like it here,
let's go to the final part of this system is issued process.
And here we have more commence,
and then we get this and this is basically the XL options dialogue. And when we are going to talk about customizing
ribbon, we're going to pay a little bit more attention.
But here's the quick exist over. So
you're just, for example,
you want to add at the removal filters, and it just appears there nothing special.
If you're doing a lot of for changing the field color of the cell,
you can add that as well.
And then when you say OK, you get these. So this opens,
uh, drop down
that log so you can
do whatever you want to these cells. Okay, this is quite a nine version of magenta, so we can
change it to something more pleasing to the eye off course. You can still
do this, but if you're doing that while, for example, in Formula Seven ribbon and you don't want to go jumping to home to change and then back to typing formulas,
it's a convenient thing to have there
and as matter, effects lot off Ah, functions that you have in home. Ah, tab of the ribbon
is, ah, convenient to have here if you are using them a lot while being in other taps So if we go to your commands
and then for a simple fun size
or the front itself
and then we get the size, we get the fund. The default delivery front of the cellar
on this is the way that we can make it actually work for us very conveniently. So a lot of people never did do this. They get used to the routine.
But this is actually something that is extremely useful.
Now. If we go to more commands here, you can also ah, recent the customization
and you can reset only quickly, says Gilbert, which is what we're going to do.
yeah, Enrique. Okay. And then it's Ah,
it's back to the standard.
Now let's do something about it again.
And let's say, for example, we want front
added and fun size and maybe fund color
and maybe Phil color
and maybe form it sells.
Or maybe a painter, because this is useful. If you want to copy for mating from one cell to another,
and I don't know when you go here, you see quite a lot of them. But it's also important to hear that you have
the list of commands you can add two quick exist toolbar
defined by this dropdown list so you can choose them by tabs or you can see just all commands. And then you get
quite a lot of them, which is
probably something that you won't need because in physical Sistol Bar
there is only a few of them that you can actually add here. And having too much of them
also makes a problem because then it gets complicated and picking the rug. One becomes common practice. So unless you need the, for example, something from table tools, which is ah,
for example, to to, uh, I don't know,
have removed duplicates, you can add it here and then when you say of ***, you get it here. Is he reacted? Just a couple of them. Maybe 87 or eight. And we have already filled the half of this space.
uh, the name of the
worksheet or file, So
adding too much of them is not recommended.
So we're going to reset this
and we're going to close this lesson
and, uh, next lesson we're going to talk about ribbon
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