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
(http://reallyusefultraininganddevelopment.ie/wp-content/uploads/2011/11/image_thumb17.png)
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