Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
this is going to be a relatively short lesson, and I'm just going to Tokyo to about automatic and manual recalculation of formulas. So you have seen
00:09
in previous example that whenever we change
00:13
the value off the cell, it automatically
00:17
Recalculates all the cells in which this
00:22
reference to the cell is used for in formula.
00:26
So
00:27
it's, Ah, very simple.
00:29
We can go again in formulas, tab off the ribbon
00:34
and change calculation options from automatic to manual.
00:39
Now there is 1/3 option here, automatic except for data tables. But we're not going to touch that here because it's rarely used on
00:47
it's there just for some special cases. So at this level, let's go just to manual and explain how it works. So now we type here
00:58
37 nothing happens.
01:02
So what, we do have to click then on if we want
01:06
the changes to be
01:07
implemented
01:08
is calculate now,
01:12
and it will recalculate
01:15
both of these formulas.
01:18
So this is how the recalculation works.
01:21
Why would you want to turn the calculation options to manual?
01:26
Well, for some reasons, it might be that you want to first developed the
01:30
the sheet you're working on so you don't want it to be recalculated all the time
01:38
or to be re calculus different or something? It by accident.
01:42
But this is mostly from the past,
01:45
when
01:46
machines were peces were a little bit too slow for the capabilities of excel.
01:53
And at those times people used to
01:57
switch the automatic calculation off because it took a long time.
02:02
It can take a long time today as well. If you put several 1000 formulas in your sheet, which can be done, I don't know why, but it can be done.
02:13
And then you might have some delay. So, for example, if you're entering some data in your data sheet and you have some formulas that will work on it
02:23
every time you enter a cell, it will recalculate all
02:28
a couple of 1000 of
02:29
formulas.
02:30
And, uh,
02:32
that can slow down the data entrance entering process. So what? What you can do is you can turn it to manual, just entered the data if you're entering it manually. If you are not just copy pasting it from somewhere,
02:49
and in that case you can do the data input and then say, OK, let's go now back to recalculate or switch back to automatic calculation and do a calculation.
03:01
So this is all about automatic and manual recalculation and excel. My default to the calculation option is turned to automatic. And unless you have some very special reason, I don't see why you shouldn't keep it like that all the time.

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