Microsoft Excel Advanced Tools

Microsoft Excel Advanced Tools

1. Pivot Tables

   • The most powerful tool in Excel
   • Also called "dynamic"
   • The data on them can be changed by rearranging or changing the position of the column and row headers in an easy and quick way.

2. Search and Logic Fuctions

   • The search and logic functions allow you to perform certain operations with the data
   • The search functions help you to find text or numeric values
   • The logic functions are used in the decision-making