6 hours 3 minutes
There are quite a lot of occasions in which you are supposed to insert in your excel sheet something that is not to just, uh, the regular content off Excel sheet, which is sell and formulas.
So sometimes you need to put some shapes there some graphics in order to emphasize
your point, especially if you're using Excel to present some findings or some calculations toe
Anybody interested? So,
in certain shapes is a standard function that existed in Excel, which is similar to any other office program.
So, for example, can you imagine? This is one simple calculation and it was done by a student. And now Professor is reviewing this,
and basically they need to put the formula there to calculate speed.
Now, this formula is absolutely okay,
but is not taking care of some things like,
what if time is entered to be zero. So
there should be a formula here
using a function to check if if this is zero and if it isn't, then it should calculate a to slash be, too. But if it's not, it should put here the information that
time cannot be zero,
and in that case,
whoever entered it can
not to enter zero instead of getting an error which may confuse people.
So imagine you're a professor and you want to emphasize something. Now, what you can do is you can insert comment
like there is no
be, too is
it's not really visible. So if you want to emphasize something, you can insert shape
and for example, you can use this block Aargh.
And you can put it here
and then you can change the shape of it.
And you can change Phil
to be read,
and you can make outline to be none because you don't need any.
You can add some preset effects like,
for example, of some kind of emphasis, like shadow or something. Or you can make it three d and then move it a little.
And you can even add a text box with the comment here,
Uh, and, uh,
put it here on Dhe. Say
I have used
form. You'll, uh,
or in case off
that is not zero than it's Ah,
a to slash be too. So that would be correct formula. And then you can correct this.
And now this is much more noticeable than
And this is one of the reasons why you shapes the other reason why you would use shapes is that if you want to add some
graph graphic studio so you can, for example, make a flow chart within your,
excell sheet to explain something. And
then we can go here and we had can have something like this.
And we can,
do something like this.
Yeah, and so on and so on. So these air shapes
and once you have entered your shapes, then you can forward them. And to do that, you just select
the edge of the shape with you till you get this Ah crossed arrow
pointer in. Sorry. Then you click right click, and you can form a shape.
And once you do that, you get your
You can add shadow. It's, um, presets,
for example, inner shadow. You can make it more or less transparent.
You can add some blower, tow the inner shadow and so on and so on. So all the standard ah,
properties off shape that exist in any other Microsoft office program is pretty much the same here. So, for example, if you wanted to be exactly 20 by 50 millimeters, you can change that.
And, uh, you can also do some
properties of, like, moving size would cells
00 are Don't move inside would sell. So, for example, if food
insert themselves here
Yeah, this one you see still has the property move inside cells and this one was moved. But this one stayed there and didn't move. So
there are quite a lot of them. If you're familiar with using shapes, informal thing shapes in Microsoft office programs, it will be you quite comfortable. If not, I suggest that you spent some time just playing with these shapes
because you never know when you might You need them.
And once you start using them, you might be able to use them much easier and with much more confidence. If you had some practice
and that's it about uncertain Informa thing shapes
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered