6 hours 3 minutes
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.
I will be talking about automatic and manual recalculation and pretty much everything regarding the existence of formulas and wired. A so important.
So, um, let's keep the
ah, the whole thing would slide And let's just go with it
just the Excel sheet and to explain what the formula is.
So formula, by definition,
is expression which calculates the value of a cell.
in in the cell, you can have some data as you have seen. So what say we have some numbers
and then we want to calculate this some of these two numbers and we can do that with a very simple
We just going to sell in which we want
calculated some envy, press enter,
and then we click on the first cell,
and then we just add. Plus, we click on the second cell and we press enter
and we got to some.
So the whole point of excel The power of excel lies in effect that no matter how many formulas have,
if you change something in this cell,
it will automatically recalculate the well you
in cells where we have formulas referencing too.
Um, how do we see that if we have very complex formula which points to different sheets and stuff like that,
we can click
in formula Stab on this
function of the XL.
And we got this arrows that shows that these two cells go into that cell.
Look, just remove these arrows
and then click on this cell and click entrees dependent. So here, with the trace President. So we traced the cell that
comprised together work as a formula in this cell.
But if you click here and weekly country's dependence, it will show us
to which sells this cell points in terms of being used for a formula. So this l can be used in 10 20 or
unlimited number off formulas in different cells
and s so if we would have here, like other formula. So
let's say this one.
when we have to remove the arrows first, so we se here equals, and then
this one just times two
and then if we click here
and here we get
these arrows pointing to all off the cells. So let's remove them
see that So So that you can you can see this. So if we change here that the value of this cell,
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.
what we also can do is click here on show formulas
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,
it will show you not the values it will show you that the formulas itself.
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
can be made to work in your advantage for whatever you want to do in Excel