Hi Folks,
In this article, I’ll briefly touch on a handy feature in MS Excel. That is, how to make Excel calculate the values of cells using a given formula automatically. Why is this important? It is handly if you want to do things like calculating values in an entire area (group of rows and columns). This means, where you calculate the value of the top left cell using a formula, then simply drag your all the way to the bottom right cell in the tabular area and Excel will calculate all values in the region.
To allow Excel calculate values automatically you need to make sure the calculation mode is set to Automatic. To do this, click Formulas > Calculation Options. Then click Automatic.
That’s all for now. Till next time, happy data analysis.