What are the powerful tools for data analysis in MS EXCEL?

There Is alot of function in excel as per requirment we decide wich tool me need to use few example i have share filter, data sorting,Pivot Table, Count Familiy & Sum Family/Pivot Table With Dashboard

There are a lot of tools used for that purpose, some of them are built-in, please refer to this article for more information:

http://www.excel-easy.com/data-analysis.html

Regards,