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
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

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor