Category: Excel

How to make MS Excel calculate values of cells automatically

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.

 

Some Cool MS Excel Features: Filtering and Easy Average Calculation

Hi,

Today I will go over two cool features I like in Ms Excel. Filtering and easy Average calculation.

Filtering is very useful if you end to extract subsets of data. To access filters in Excel, first create a table from a range of data.

To do this, highlight the entire table, then click Insert > Table. Then click OK to confirm the cell range to use for creating the table.

With a table you can apply filters easily.

To calculate average easily for a column of values simply highlight the column and the average, count and sum appears on the bottom status bar.

That’s all for now. Till next time.