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

Similar Content