Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:01
except for standard text that you can type in a cell.
00:06
There are some things that you might want to put in in your Excel sheet, especially if you're doing some math calculation to explain better
00:15
the formulas using.
00:18
And you want them displayed in
00:22
typical math four month. Or you just want to add some symbols into your
00:27
ah cells or
00:30
somewhere on your Excel sheet, which are not typical characters that you can just type in a cell.
00:36
So in that case, you could insert symbols and equations, and if we go again to the insert tab
00:44
and go to the symbols, you get all these symbols that you can insert. So why would you want to do that? Typical thing is
00:52
that here you do the some offer revenue for a week,
00:57
and for some reason you don't want to put
01:03
in a cell a nine, the total
01:07
or total revenue.
01:08
You just want to put the Greek symbol for some sigma,
01:12
and you just wanted there.
01:15
So you want to insert symbol. You click on symbol
01:19
if you can insert
01:21
and is there. So some people preferred this type of four months. Then, too right total something
01:27
or you have a situation in which you want to add something like
01:36
copyright
01:38
or
01:40
he won't insert toe insert. Ah, symbol here.
01:46
Ah, that represents the currency.
01:49
So, for example,
01:52
found British pound.
01:55
So this will tell you that this is some off revenue and it's in British pounds,
02:01
so all these symbols can be found here. Ondas, You see some of a ll. These symbols can be placed within that cell so they don't need a special object to be placed there.
02:14
Now, for example,
02:16
you want to put the equation in your table that will explain
02:23
something about what you're doing here. So, for example, let's take a typical,
02:29
um,
02:30
formula from
02:32
physics. Like kinetic energy is equal mass times the speed squared, divided by two.
02:43
So you go to these equations
02:46
and you have the option to insert the equation
02:51
and you will say e
02:53
kinetic
02:55
equals.
02:58
And then you can add
03:00
things like uh,
03:02
X Y fraction,
03:06
for example, something like
03:10
this.
03:13
And then you can edit this so you can say M
03:17
dimes
03:21
the
03:23
square
03:25
divided by two
03:32
and then you can make it bigger,
03:37
larger.
03:38
You can, uh,
03:40
increased the front
03:44
and then here you can select these and say OK, I wanted to be a sub script because that's the way to write it.
03:53
And I want to this one to be
03:55
superscript.
04:00
And now we have
04:05
the regular formula like it is supposed to be written
04:11
and it can be placed when there were you
04:13
want. And you can
04:16
also
04:18
do it to be moved with cells or not moved, and it can be locked. You can lock, text or unlock it
04:28
and everything you would like to do
04:30
with the formula
04:32
in order to make it sit where you want it.
04:36
So if you go again to the insert Anglican,
04:42
this arrow here
04:44
you have quite a nice collection off predefined formulas
04:49
that you can
04:51
then use,
04:57
and you can modify them in the way that you like.
05:00
So we're just going to do one undo and another one
05:05
because we inserted that formula inside this one because we were editing it.
05:12
So, um,
05:14
again, like with any object that is inserted in excel, you can change size. You can train properties,
05:24
you can add Ah,
05:28
some things. In this case with formulas, you don't shadows or reflection or soft edges.
05:35
But essentially, this is
05:39
the other things you can do. Like, for example,
05:44
you can resize it.
05:46
Ah,
05:47
but not with the properties function. You have to do it like this.
05:51
And then the funds, you can change the size, so it's pretty much like a text.
06:00
So this is all about
06:01
in certain formulas. Again, you can play with it on again if we goto edit.
06:11
Ah, you can. So if we had another formula, for example,
06:16
this one here, you get all these types.
06:21
Ah, for example Ah,
06:26
we can say that
06:28
speed is equal.
06:30
Um,
06:32
both
06:35
do I have to make time
06:39
and then you can resize it.
06:45
Sorry,
06:58
Let's do it again. So
07:00
Asian, Okay, See
07:03
equals
07:09
And then
07:11
we can do it in a linear fashion or we can make it in a professional fashion, which means
07:15
that ah,
07:18
it looks a little bit like this or we can change it into normal text. We can use the ink in creation in which we will draw it. But we need some kind of
07:29
drawing instrument like pen to make it nice. And you have all these structures that you can use to change alter the appearance of formula. You can also add symbols through your formula, like Greek letters, which are usually used.
07:46
And once you finish designing your formula, you can resize it. You can change the text size
07:54
and so on and so on. So
07:56
quite a lot of functionality again, I recommend that you
08:01
practice these things according to your preferences. If you need formulas, it all.

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