In today’s world, we are all presented with huge amounts of data. It can be an overwhelming task to try to analyze the data to get some meaningful information. These built-in tools in Excel can help you analyze your data and get the results that you need.
Using the Scenario Manager
The Solver Add-in
Data Analysis Tools
Sumif, Countif,Averageif, Sumifs, and Countifs formulas
If, And, Or, and Nested If formulas