Register now or log in to join your professional community.
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,
