MS Excell tools

Hi everyone i want to ask about the following, examples of using the following tools on spreadsheets or Ms Excel in related databases:
a) Pareto Analysis and Data Sorting
b) Search Function
c) Pivot table

Thank you