Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

Video Transcription

00:02
in this module. I'm going to talk about customizing dxl interface. So this model you learn, what are the elements of fix selling to freeze
00:11
already? You probably are quite familiar with them, but
00:15
we just call them by their proper name and defined them all. Then
00:23
in ah, other less. And I will talk about how to customize peak access to a bar
00:29
and, at the end, how to customize ribbon.
00:34
So it was go from the elements.
00:37
So Excel User interface is similar to other office programs. And if you look at this excel, worksheet or or file opened full screen,
00:53
the 1st 1 first element of the quicker says of the excellent interface is a quick access to a bar. It's located in the top left corner of the
01:04
screen, but it doesn't have to be there, But I defaulted. Stare,
01:11
then. The speaking most important element for interaction with Excel is the ribbon where all the commands are.
01:19
Ah, then we have right click menu, which is
01:25
happening when you click the right
01:27
miles key Hermosa
01:30
Button on ah appears on the place where your cursor the moment is,
01:37
and it's usually there to do some you have some shortcuts about the cell you have selected a group of cells elected or some element off excel,
01:48
Uh, file like, for example, some drawing or or some important picture. Or maybe your chart, whatever you can by clicking on the right click, you get the this menu.
02:00
The next one is dialogue box that can show whenever you're doing something, usually when you're doing something wrong
02:09
and then Doris task pain, which happens when you go into some operation that has additional things that you have to do others than
02:22
just typing in a cell or doing something with the cell. For example, if you're doing what feels or if you're doing the animations like this animation you see now in the power point S O, I mean this in Power point, you get the animation Ah, task pane.
02:38
In excel, for example, you would bring people table. You get the pure table Spain, which is absolutely necessary to customize your
02:46
we weren't able to make it work the way you want it
02:53
and of course, their keyboard shortcuts, which I cannot show here because this is just the picture. So
03:00
but those difficult control C and control re, which are
03:05
copy and based or control X, which is kept.
03:08
So these these air also very important because you can customize some things. For example, you can assign keyboard shortcuts to Mac rose. And in that way, if you're using them frequently, you can save yourself time,
03:25
Uh, by going through menus and selecting the right macro.
03:31
So
03:34
this is it about this. Listen,
03:37
And the next one we're going to go
03:39
on, how to Ah, dude. Aah!
03:45
Because how to customize that we accessed toolbar.

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