Video Transcription

00:00

in this module I'm going to talk about forming wasn't excel. So what are formulas? How they entered what kind of formulas there are.

00:09

I will be talking about automatic and manual recalculation and pretty much everything regarding the existence of formulas and wired. A so important.

00:23

So, um, let's keep the

00:27

ah, the whole thing would slide And let's just go with it

00:34

just the Excel sheet and to explain what the formula is.

00:38

So formula, by definition,

00:42

is expression which calculates the value of a cell.

00:47

So, um,

00:49

in in the cell, you can have some data as you have seen. So what say we have some numbers

00:56

and then we want to calculate this some of these two numbers and we can do that with a very simple

01:03

way.

01:03

We just going to sell in which we want

01:07

calculated some envy, press enter,

01:10

and then we click on the first cell,

01:12

and then we just add. Plus, we click on the second cell and we press enter

01:19

and we got to some.

01:22

So the whole point of excel The power of excel lies in effect that no matter how many formulas have,

01:30

if you change something in this cell,

01:32

it will automatically recalculate the well you

01:36

in cells where we have formulas referencing too.

01:42

That cell.

01:42

Um, how do we see that if we have very complex formula which points to different sheets and stuff like that,

01:53

we can click

01:53

in formula Stab on this

01:57

here

01:59

function of the XL.

02:01

And we got this arrows that shows that these two cells go into that cell.

02:08

Also,

02:10

Look, just remove these arrows

02:14

and then click on this cell and click entrees dependent. So here, with the trace President. So we traced the cell that

02:27

comprised together work as a formula in this cell.

02:31

But if you click here and weekly country's dependence, it will show us

02:37

to which sells this cell points in terms of being used for a formula. So this l can be used in 10 20 or

02:46

unlimited number off formulas in different cells

02:51

and s so if we would have here, like other formula. So

02:57

let's say this one.

03:00

Sorry,

03:00

when we have to remove the arrows first, so we se here equals, and then

03:07

this one just times two

03:10

and then if we click here

03:13

and here we get

03:15

these arrows pointing to all off the cells. So let's remove them

03:21

and

03:23

see that So So that you can you can see this. So if we change here that the value of this cell,

03:31

we get automatic recalculation for both of these. Now, we're going to talk very soon about possibility to switch this automatic calculation off. But at this point, this is it.

03:45

So, um,

03:46

what we also can do is click here on show formulas

03:52

and then instead of values, it will show us formulas in these cells. This is very useful if you have some problem with the calculation, or you just want to see if you did everything right according to what you plan to put here,

04:05

it will show you not the values it will show you that the formulas itself.

04:11

So

04:13

this is all about entering formulas in Excel and, ah, as we go further with this course, I will show you more and more ways to enter formulas and how these formulas

04:28

can be made to work in your advantage for whatever you want to do in Excel

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