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.