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.