 # What are Formulas, How are They Entered?

Video Activity
Join over 3 million cybersecurity professionals advancing their career
or Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6
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
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