Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:01
Okay, So
00:03
to customize the big success toolbar
00:06
in the quicker Cristal bar itself, you have
00:09
the drop down menu that is actually meant for that.
00:13
And the reason for it is because most of
00:16
most people that there
00:19
advanced users of excel.
00:22
They want some things in the quicker system here, which is not there by default, because these things they use a lot.
00:30
So let's go to
00:33
excel sheet
00:35
and do it.
00:37
So you're simply click here and you get the customers quick access to a bar.
00:41
No,
00:43
um,
00:44
you feel
00:45
just till, like this one,
00:47
you will get the new
00:50
willing to control and
00:52
small I can hear in the quick Sistol bar.
00:56
We can also switch it off because it's something that
00:59
people don't usually d'oh.
01:00
But you can put here preview in print
01:04
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
01:19
doing the regular action for print.
01:23
But if you're printing a lot and ah,
01:26
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
01:45
in front of the self than the screen.
01:48
S O. There are quite a lot of reasons to print,
01:53
and it's It's convenient to have this one as well as you can have a quick print which
02:00
Okay, so there is nothing to print, but
02:05
yeah,
02:06
but this is Ah, this is convenient.
02:09
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.
02:22
But maybe I want to print on my colleagues jet and then it's Ah,
02:27
it's a different story, So I have selected
02:30
every time I go to print. So the quick, clean button is just for
02:35
quite special,
02:37
uh, set up. If you have it,
02:42
you can add spelling if you type a lot in your excel and you want to check spelling.
02:46
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,
02:55
you have sort of sendings or descending if you do what? The sorting while looking at the Excel file and then the analyzing data.
03:05
But also, you have the option to do more commands. And this is the important one.
03:10
Oh, yeah. By the way, before we go there,
03:14
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,
03:24
uh, then you can put it here. And then again, you can, uh,
03:30
put it back.
03:31
Um,
03:34
for some people who are
03:37
who have been using office for quite a long time,
03:39
this position here is much more convenient because it reminds them or the old
03:46
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,
04:05
so
04:06
let's go to the final part of this system is issued process.
04:12
And here we have more commence,
04:15
and then we get this and this is basically the XL options dialogue. And when we are going to talk about customizing
04:25
ribbon, we're going to pay a little bit more attention.
04:29
But here's the quick exist over. So
04:31
you're just, for example,
04:33
you want to add at the removal filters, and it just appears there nothing special.
04:40
If you're doing a lot of for changing the field color of the cell,
04:46
you can add that as well.
04:48
And then when you say OK, you get these. So this opens,
04:54
uh, drop down
04:58
that log so you can
05:00
do whatever you want to these cells. Okay, this is quite a nine version of magenta, so we can
05:06
change it to something more pleasing to the eye off course. You can still
05:12
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,
05:24
it's a convenient thing to have there
05:26
and as matter, effects lot off Ah, functions that you have in home. Ah, tab of the ribbon
05:35
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
05:46
and then for a simple fun size
05:50
or the front itself
05:55
and then we get the size, we get the fund. The default delivery front of the cellar
06:04
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.
06:16
But this is actually something that is extremely useful.
06:20
Now. If we go to more commands here, you can also ah, recent the customization
06:30
and you can reset only quickly, says Gilbert, which is what we're going to do.
06:33
Ah,
06:36
yeah, Enrique. Okay. And then it's Ah,
06:41
it's back to the standard.
06:43
Now let's do something about it again.
06:46
And let's say, for example, we want front
06:51
added and fun size and maybe fund color
06:57
and maybe Phil color
07:00
and maybe form it sells.
07:04
Or maybe a painter, because this is useful. If you want to copy for mating from one cell to another,
07:13
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
07:19
the list of commands you can add two quick exist toolbar
07:25
is ah
07:27
defined by this dropdown list so you can choose them by tabs or you can see just all commands. And then you get
07:38
quite a lot of them, which is
07:41
probably something that you won't need because in physical Sistol Bar
07:46
there is only a few of them that you can actually add here. And having too much of them
07:54
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,
08:09
for example, to to, uh, I don't know,
08:15
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.
08:31
I mean,
08:33
uh, the name of the
08:35
worksheet or file, So
08:39
adding too much of them is not recommended.
08:45
So we're going to reset this
08:50
do bar,
08:54
and we're going to close this lesson
08:56
and, uh, next lesson we're going to talk about ribbon

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