Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
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.
00:15
So sometimes you need to put some shapes there some graphics in order to emphasize
00:20
your point, especially if you're using Excel to present some findings or some calculations toe
00:28
Anybody interested? So,
00:32
in certain shapes is a standard function that existed in Excel, which is similar to any other office program.
00:43
So, for example, can you imagine? This is one simple calculation and it was done by a student. And now Professor is reviewing this,
00:51
and basically they need to put the formula there to calculate speed.
00:56
Now, this formula is absolutely okay,
01:00
but is not taking care of some things like,
01:03
um,
01:04
what if time is entered to be zero. So
01:08
there should be a formula here
01:11
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
01:27
time cannot be zero,
01:30
and in that case,
01:32
whoever entered it can
01:36
No,
01:38
not to enter zero instead of getting an error which may confuse people.
01:42
So imagine you're a professor and you want to emphasize something. Now, what you can do is you can insert comment
01:51
like there is no
01:53
check if
01:57
be, too is
02:00
zero,
02:02
but, uh,
02:05
it's not really visible. So if you want to emphasize something, you can insert shape
02:09
and for example, you can use this block Aargh.
02:14
And you can put it here
02:16
and then you can change the shape of it.
02:21
And you can change Phil
02:24
to be read,
02:27
and you can make outline to be none because you don't need any.
02:31
You can add some preset effects like,
02:38
for example, of some kind of emphasis, like shadow or something. Or you can make it three d and then move it a little.
02:50
And you can even add a text box with the comment here,
02:57
Uh, and, uh,
03:00
put it here on Dhe. Say
03:04
you should
03:06
I have used
03:08
form. You'll, uh,
03:13
sorry,
03:15
Tyco
03:19
and, uh,
03:21
for example,
03:23
equals if
03:28
be too
03:29
equals zero,
03:30
then
03:35
time
03:36
come
03:38
be zero
03:39
or in case off
03:45
that is not zero than it's Ah,
03:47
a to slash be too. So that would be correct formula. And then you can correct this.
03:57
And now this is much more noticeable than
04:00
just the
04:02
comment here.
04:04
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
04:17
graph graphic studio so you can, for example, make a flow chart within your,
04:24
um,
04:26
uh,
04:27
excell sheet to explain something. And
04:32
then we can go here and we had can have something like this.
04:40
And we can,
04:42
ah,
04:45
do something like this.
04:56
Yeah, and so on and so on. So these air shapes
05:00
and once you have entered your shapes, then you can forward them. And to do that, you just select
05:08
the edge of the shape with you till you get this Ah crossed arrow
05:14
pointer in. Sorry. Then you click right click, and you can form a shape.
05:21
And once you do that, you get your
05:26
shape options.
05:28
You can add shadow. It's, um, presets,
05:32
for example, inner shadow. You can make it more or less transparent.
05:41
You can add some blower, tow the inner shadow and so on and so on. So all the standard ah,
05:48
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.
06:05
And, uh, you can also do some
06:13
properties of, like, moving size would cells
06:16
00 are Don't move inside would sell. So, for example, if food
06:23
insert themselves here
06:27
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
06:38
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
06:56
because you never know when you might You need them.
07:00
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
07:10
and that's it about uncertain Informa thing shapes

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