Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
and this model, I will be talking about former thing cells and sheets.
00:05
So talking about what? The properties of cells, you conform it how to do some conditional former thing, how to enter tables within your worksheet and basically all of these things that you can do to improve the visual appearance off your worksheet.
00:26
But before that, let's go to a short to question quiz which will help you
00:32
check your learning so far about two previous models.
00:40
So, uh, the first question this quiz
00:44
is which square you need to press before sorting sub total. So if you remember, subtitles function.
00:51
Uh, when you enter it, you get the next to the roles you get these three squares numbered 12 and three. And the question is, which one you need to press before you go to sorting sub totals.
01:07
And, of course, possible answers. Air 12 and three.
01:12
And the right answer is,
01:15
too, because we too, you get only subtitles and grand total visible.
01:23
So let's go to the next question. When you open a template file and you want to save it using save option,
01:30
what is the default file type for saving it. So what is the default file type XL is giving you when you want to save a template?
01:40
Is it that excellence? Um,
01:42
is it does excel t X or the ex L A ***
01:48
and the right question. Right? Answer to this question. Is that X l s X.
01:55
So
01:56
now let's go to Ah, what
02:00
is that
02:00
topic off this lesson which is Sell properties.
02:06
And if you go in excel and you get the normal look of it when you open the file and you enter anything in one of the cells, for example, number
02:16
and then when you click on this
02:20
cell and do the right click,
02:23
you get some of the options. These are from copy and basting. You don't want me. We're not looking at them.
02:30
Um, then we have, ah
02:34
option to insert comment in a cell which is sometimes useful. For example, if you click here, it gives you the name of the person who gave the comment. And I say,
02:45
for example, this cell needs
02:49
to be
02:51
form. It'd
02:53
and, uh,
02:54
I just pick outside. Oh, it's so now that this is entered and when I hover over this red triangle.
03:01
It gives us the option, and it gives us the content off my comment.
03:07
If multiple people are working on this file, whoever makes the comment will have their name displayed before the comet itself in the box.
03:17
So let's go here and right click again.
03:22
And, for example, we can edit the comment. We can delete the comment, but that's not directly on point with what we're talking about in this lesson. So first up here
03:36
you have the main
03:38
ah, the simplest parts off the form a thing of the cell. So you have the front,
03:45
you have the phone size. You can go up and down on the front size. You can
03:52
do the accounting format of the cells to think that we have already talked about when we talked about former the data types. Or you can use the percentage. Or you can use the common style you can do merge in center function. So this is all here is as a quick ah
04:12
ah, list off commands and then you can do the balding off the front. You can do italic. You consent to it.
04:20
Um, you can change the color off the background and this is one of the things that is important to formatting cells or color of the text. You can add the border to the
04:33
so
04:35
and you can increase in decreased number of decimals. And in the end you have this very useful former painter option or function, which, when you click it
04:46
it, just select. Sit all the forms from this cell, and then we select some other cells and all the former thing is copied.
04:55
Notes are not copied. This is not the part of it.
04:58
But what we're looking at this point is this function here in this drop down list, which is form it sells.
05:05
And then we get the
05:08
full view off all the funk A ll, the formatting options for the self.
05:13
So one you have seen, it is the number. So
05:16
which type off data is in this cell?
05:20
But then we have alignment and we have horizontal and vertical alignment.
05:26
And you see here it can be very similar to
05:30
text processing programs like word you have left. I invented. You have centered. You have right you have filled, which means it fills the cell fully.
05:46
You have justified you have center cross selection or you have distributed. So this is, uh this is it. And you can also have Ah, it. I dent so, meaning that the first line can be moved to a certain
06:04
position.
06:05
You have vertical alignment, which can be top center, bottom justified, or Syria it'd.
06:12
And then you have a text control functions. You have wrap text,
06:15
and I will explain to immediately what it does. I will just check it.
06:20
Um, you also have ah
06:25
possibility Check shrink to fit
06:28
and you can do the merge cells. If you have selected more than one cell
06:31
and text direction can be left to right or right to left or in context,
06:38
which is not that important that this time. But here you also can have the orientation of the text so you can change the angle. It doesn't have to be horizontal or vertical on. This is, uh, at this point not very interesting, but it can be useful if you are doing some text that should
06:58
align with some objects that are not just
07:01
pure text. For example, if you have some pictures or some graphs in the in your worksheet and you want to change the angle so it matches better the the object you have inserted in the text.
07:15
Let's go to wrap text, which is one of the things that I want to talk to you about
07:19
and let's adhere some text instead off
07:25
just number. So let's, uh,
07:28
you're a B C D E f g
07:30
age
07:32
and, uh,
07:36
look
07:39
okay, so this is what text trapping does it automatically,
07:44
uh, pushes the text in the next line and next line and next line without changing the
07:53
with off the
07:56
calm.
07:58
So if we go here
08:01
and
08:03
changed this con the width of this column,
08:07
it will
08:09
remain the It will keep the text
08:13
in one line. It will not change the height of this row,
08:18
and, uh,
08:20
it will allow the all of the text to be fitted in one line.
08:24
So if you click here and you go here, you see, the height is 15 so you can go here and click on row hide
08:33
and entered the same number, which is 15 and it will return to the previous
08:39
size.
08:39
Now, if you click here again to form, it sells and go to alignment, and instead of rep Text, click, shrink to fit
08:48
and like, OK, nothing is happening because there is enough space for this text in this cell.
08:54
But if we do this like this now,
08:58
it will automatically change
09:01
the zoom of this cell. So if you look at the size of the texting, the cell, it has stayed 11. But it will be shrunk to fit the width of the cell
09:11
so you can either force the text too.
09:15
Be moved into next line and subsequently the row height off the height of that cell and the entire row will be changed. Or you can just
09:28
change the width of text. And if you double click here, it will push the width off this cell, Toby. Just enough to fit all of the text in it.
09:43
So again, you move. You get to this point er and your double click. So if it's here and I double click, it will be like this. Even if shrink is on and I double click, it will be written
09:56
changed back to the defaults, the size that was in this window here
10:01
and change their So these are the basic things about former thing, the text,
10:07
um, the the cell and the text within it

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor