Quick Filtering Using Tables

[Monirul Islam]

Sorting and filtering are two of the most commonly used commands. The Format as Table option allows you to speed up your sorting and filtering. You can also  select multiple filters, sort or filter by colour.

Select the data to be used in your Table
Click on Format as Table
Select your Format Style
You will have a Live Preview of the Formatting options
Excel automatically adds Drop down options to the first row of your Table
You can Filter from the Drop downs

Extra Features

Click on the Table
The Table Tools appears above the Ribbon
Click  on  Total Row
A Total Row is added to your table
Click in the cell containing the Total data
A Drop down appears
You can now select many of the functions used to  Analyse Data such as Average, Max, Min etc


When you have competed your analysis you may want to convert your table into a Range and remove the Drop downs.

To Convert your Table to a Range

Click on the Table
The Table Tools appears above the Ribbon
Click on Convert to Range 

Source: Really Useful