Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
in this model, I will be talking about inserting all kinds of objects into ex Elder. Is there quite a lot of them? And I'm not going to talk about all of them because some of them
00:11
belonged to what would be intermediate level off usage of excel. But I'm going to take a look at the most important ones and most common ones.
00:22
Ah. So, um,
00:25
in the first lesson in this, listen, we'll be talking about what? Some The insert tab about some of the functions there.
00:33
So let's go directly to excel.
00:36
And if you look at the insert tab there, quite a lot of things you can do. You can insert people table table,
00:44
and we're not going to talk about this. In this module, there is a separate model module just for that,
00:52
people table things.
00:56
Then we have illustrations which could be pictures or shapes or smart of art.
01:02
Um, it means we're not going to
01:06
talk about in this course.
01:07
Then we have charts.
01:11
We have three D maps, and we're not going to talk about them. Also, a people tracked this part of the modulate,
01:18
um slicer and timeline also, not that much interesting for for intro to excel as well as the link. But these I'm going to take a little bit more attention to so text box Heather and Footer is going to be covered in Module nine. When we talk about printing,
01:38
but worked were that signature line
01:40
and equation, and symbols are also going to be covered.
01:45
So let's start with a simple text box so you go to the insert tab. So when you open excel, you're usually in your home tab. You go to insert, you go to text box
01:56
and you just drag here. It's if you have are familiar with textbooks in words except words, it's the same thing.
02:04
So you type your
02:07
fixed.
02:09
Yeah,
02:10
and then you resize your box to decide you wanted to be,
02:15
and you select your box. And then what you can do is you change
02:22
the background, for example,
02:24
and you changed the fund color.
02:28
Two. White and you can change the size. You can change
02:34
the alignment the same way it is done in.
02:38
Ah,
02:39
for for any cell.
02:42
Just this is this conflict oat all around your excel sheet, and it's not bound to any cell
02:50
when you when you right click here.
02:53
Sorry.
02:54
You get to the standard properties,
02:58
uh, window
03:00
and you can go to size and properties.
03:07
So and then get this
03:08
space here
03:10
where you can define the kites Exactly how you wanted to be. Um, you can have,
03:22
for example, you can make it have shadow
03:25
like this, And you can make the shadow to be,
03:31
for example, like green, light blue or, ah,
03:37
maybe a little darker.
03:38
You can make it less transparent or more transparent.
03:44
You can ads
03:46
sizes to the blower. You can change the size of the shadow and so on and so on.
03:53
So they're quite a lot off,
03:57
uh,
03:58
options that you have for the
04:02
So you can you can add something like this
04:06
like a reflection.
04:10
You can change its eyes
04:12
and so on. And so you can You can play until you get the desired effect it
04:17
There are so many options I'm not going to go into all into all of them. So this is all about
04:24
adding text boxes.
04:27
Now let's go again to insert. And now we can insert some word art as well,
04:33
so you can choose what kind of world art you want. You have these predefined
04:39
types,
04:41
and we'll leave it to the simple text. And then again, the right sorry, right click here
04:47
and we go to form a shape,
04:53
and then we can go to text options and change the size of it.
04:59
And then the text box. Ah, we can change the margin between text and
05:05
the border of the box of this text, and we can go toe options
05:13
and again can, uh,
05:17
and the shadow
05:19
we can change the type of the shadow
05:24
of the text itself. We can change the color. It doesn't have to be black. It can be
05:30
something like this.
05:32
Um, the text itself. We can change its color. So
05:42
to this
05:44
and someone on son, so you can play with it until he reached the desired effect.
05:50
Then you can close this. You can also click here
05:55
and do size and properties,
05:59
and you get just the
06:01
part of the
06:04
next you want to do so. This is it.
06:08
Um,
06:09
And the next thing we can do here
06:13
is ah that we can have the signature line,
06:16
and, uh,
06:19
just cancel this so we could click here
06:23
you can have Microsoft Office signature line or you can add Signature Service is so if you're using some kind of signature service is for digitally signing documents or signing documents online, you can use that. We're not going to show you that here. But you can have this
06:41
signature set up so you can have suggested signers title email address if needed. And there isn't there some instructions
06:50
and so on and so on. So let's do something simple. Just my name.
06:58
And, uh,
07:00
I don't have any,
07:02
and we'll delete this,
07:06
and, uh
07:10
and here it is,
07:12
so this can be placed, but never you want in a document. So at the end of the page or something like that,
07:18
and it can be used to
07:21
when, when printed for people to sign it. Or if you're using online signing service, you consign it online.
07:30
So this is about the insert tab, and now in next lessons, I'm going to go into details about the particular functions on that step

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