Pivot Table in Excel

Pivot Table in Excel:

Select whole table and Go-to insert tab and click on pivot table. 

Drag and drop column accordingly.

On pivot table you are able to Filter and conditional formatting and chart also.