6 hours 3 minutes
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
in previous example that whenever we change
the value off the cell, it automatically
Recalculates all the cells in which this
reference to the cell is used for in formula.
it's, Ah, very simple.
We can go again in formulas, tab off the ribbon
and change calculation options from automatic to manual.
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
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
37 nothing happens.
So what, we do have to click then on if we want
the changes to be
is calculate now,
and it will recalculate
both of these formulas.
So this is how the recalculation works.
Why would you want to turn the calculation options to manual?
Well, for some reasons, it might be that you want to first developed the
the sheet you're working on so you don't want it to be recalculated all the time
or to be re calculus different or something? It by accident.
But this is mostly from the past,
machines were peces were a little bit too slow for the capabilities of excel.
And at those times people used to
switch the automatic calculation off because it took a long time.
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.
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
every time you enter a cell, it will recalculate all
a couple of 1000 of
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,
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.
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.
LPI Linux Essentials
LPI Linux Essentials practice exam helps to prepare for the LPI Linux Essentials 010-160 certification ...
Being an intermediate level user of Excel can help save a user hours of work ...
9 CEU/CPE Hours Available
Certificate of Completion Offered